$connection = int odbc_connect(string dsn, string user, string passWord) establishes a database connection,
$query_string = "Query record conditions"
For example: $query_string = "select * from table"
Use $cur = int odbc_exec(int connection_id, string query_string) to retrieve the database and put the record set into the $cur variable.
Then use while (odbc_fetch_row($cur)){
$var1=odbc_result($cur,1);
$var2=odbc_result($cur,1);
...
}
Read the data set $cur returned by odbc_exec().
Finally, odbc_close(int connection_id) closes the database connection.
The odbc_result() function takes the specified field value of the current record.
The above introduces how PHP uses ODBC to connect to the database under NT IIS, including the content of ODBC connection to the database. I hope it will be helpful to friends who are interested in PHP tutorials.