PHP code:
Note that php uses realpath to obtain the path.
Copy codeThe Code is as follows:
<? Php
$ Connstr = "DRIVER = {Microsoft Access Driver (*. mdb)}; DBQ =". realpath ("data. mdb ");
$ Connid = odbc_connect ($ connstr, "", "", SQL _CUR_USE_ODBC );
$ Issuetime = date ("Y-m-d H: I: s ");
$ SQL = "insert into test values ("","",...)";
$ Result = odbc_exec ($ connid, $ SQL );
If ($ result) echo "successful ";
Else echo "failed ";
?>
II:
Copy codeThe Code is as follows:
<? PHP
// Create An ADO connection
$ Conn = @ new COM ("ADODB. Connection") or die ("ADO Connection failed! ");
$ Connstr = "DRIVER = {Microsoft Access Driver (*. mdb)}; DBQ =". realpath ("temp/TempData. mdb ");
$ Conn-> Open ($ connstr );
// Create a record set Query
$ Rs = @ new COM ("ADODB. RecordSet ");
$ Rs-> Open ("select * from blog_Content", $ conn, 1, 3 );
Echo $ rs-> Fields ["log_Title"]-> Value; // output the log_Title Field
Echo "<br/> ";
$ Rs-> Movenext (); // move the record set pointer down
Echo $ rs-> Fields ["log_Title"]-> Value;
$ Rs-> close ();
?>
Method 3: Use ODBC to create a system data source for db1.mdb In the ODBC controller (server permissions are generally required and not recommended)
Name: dbdsn (set by yourself)
Driver: Microsoft Access Driver (*. MDB)
Code:
Copy codeThe Code is as follows:
$ Conn = odbc_connect ("dbdsn", "admin", "123"); // connect to the data source
$ Doquery = odbc_exec ($ Conn, "select * from table name where condition"); // execute the query