Use ODBC to connect to the database under NTIIS

& #36; connectionmongodbc_connect (stringdsn, stringuser, stringpassword) to establish a database connection. & #36; query_string query record conditions include: & #36; query_stringselect * fromtable & #36; currentdbc_exec (intc $ connection = int odbc_connect (string dsn, string user, string password) to establish 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.

Use while (odbc_fetch_row ($ cur )){
$ Var1 = odbc_result ($ cur, 1 );
$ Var2 = odbc_result ($ cur, 1 );
...
}
Read $ cur from the dataset returned by odbc_exec.

Finally, odbc_close (int connection_id) closes the database connection.

The odbc_result () function is used to obtain the specified field value of the current record.