My php code, however, fails to connect to the database server. I've tried the following:
Code: Select all
<?php
$hostname1 = "10.3.1.27:3306";
$hostname2 = "10.3.1.27";
$hostname3 = "marcian.stthom.edu:3306";
$hostname4 = "marcian.stthom.edu";
$username = "root";
$passWord = "XXXXXXXX";
$dataBase = "test";
$conn = mysql_connect($hostName4,$userName,$passWord) or die ("Failed to connect to server");
mysql_select_db($dataBase,$conn) or die("Failed to select database!");
?>Code: Select all
<?php
$hostname = "marcian.stthom.edu";
$username = "root";
$passWord = "XXXXXXX";
$dataBase = "test";
$query = "SELECT field1, field2, field3, field4 FROM marciantest";
#connect
$connect = odbc_connect("$hostname:$dataBase",$username,$passWord) or die("aarrrrrgh, could not connect<br>");
$result = odbc_exec($connect, $query) or die("Couldn't execute statement. Query = $query");
?>TIA