PHP connects to access database instances and access instances. PHP connects to an access database instance. the access instance uses the structure of Delphi and access because the previous PingSwitch is used as a front-end for WEB display, while Delphi and MySQL connect to PHP to operate access database instances and access instances
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"
";
$ 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.
Because the previous PingSwitch is used as a front-end for WEB display, the Delphi and access structures are used at the beginning, while the connection between Delphi and MySQL is...