PHP connection operation access database instance, access instance
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 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.