Use ODBC to connect to the database under NTIIS. $ Connectionmongodbc_connect (stringdsn, stringuser, stringpassword) establishes a database connection. $ query_string query record conditions include: $ query_stringselect * fromtable $ 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.
Connector = int odbc_connect (string dsn, string user, string password) to establish a database connection. $ query_string = conditions for querying records, such as: $ query_string = select * from table $...
