PHP connection to access database, phpaccess Database

PHP connection to access database, phpaccess Database

Because the previous PingSwitch is used as a front-end for WEB display, the Delphi and access structures are used at the beginning, and the connection between Delphi and MySQL is relatively troublesome, at last, I can only choose a combination of PHP + Access, which is strange but reasonable ·····

To connect to the access database in PHP, We must connect to ADO, which is very similar to connecting to the database in ASP. A demo is provided below for your reference.

<? PHP/* Create An ADO connection */$ conn = @ new COM ("ADODB. connection ") or die (" ADO Connection faild. "); $ connstr =" DRIVER = {Microsoft Access Driver (*. mdb)}; DBQ = ". realpath ("DATUM/cnbt. mdb "); $ conn-> Open ($ connstr);/* create a record set query */$ rs = @ new COM (" ADODB. recordSet "); $ rs-> Open (" select * from dbo_dirs ", $ conn, 1, 3);/* read data cyclically */while (! $ Rs-> eof) {echo "$ rs-> Fields [" title "]-> Value; echo" <br/> "; $ rs-> Movenext (); // move the record set pointer down} $ rs-> close ();?>

In this way, it will be okay ····

The above is all the content of this article. I hope you will like it.