using ODBC with PHP
Connecting to ODBC
There is an excellent tutorial on using PHP’s ODBC extension at ASPToday, a popular ASP web site. An example taken from the above article:
<?
# connect to a DSN "mydb" with a user and password "marin"
$connect = odbc_connect("mydb", "marin", "marin");
# query the users table for name and surname
$query = "SELECT name, surname FROM users";
# perform the query
$result = odbc_exec($connect, $query);
# fetch the data from the database
while(odbc_fetch_row($result)){
$name = odbc_result($result, 1);
$surname = odbc_result($result, 2);
print("$name $surname\n");
}
# close the connection
odbc_close($connect);
?>
