http://www.unixodbc.org/doc/FreeTDS.html#Configuration - 0 views
-
<?php # connect to a DSN "MSSQLTest" with a user "cheech" and password "chong" $connect = odbc_connect("MSSQLTest", "cheech", "chong"); # query the users table for all fields $query = "SELECT * FROM users"; # perform the query $result = odbc_exec($connect, $query); # fetch the data from the database while(odbc_fetch_row($result)) { $field1 = odbc_result($result, 1); $field2 = odbc_result($result, 2); print("$field1 $field2\n"); } # close the connection odbc_close($connect); ?>
-