PHP connection operation access database instance, access instance_PHP tutorial

PHP connection operation access database instance, access instance

Because the PingSwitch I made before was to be a front-end for WEB display, because the structure of Delphi and access was used at the beginning, and Delphi The connection with MySQL is relatively troublesome. In the end, I can only choose the combination of PHP Access, which is strange, but reasonable...

To connect to the access database in PHP, we must use ADO to connect, which is very similar to connecting to the database in ASP. A DEMO is given below for your reference.

/*
Create ADO connection
*/
$conn = @new COM("ADODB.Connection") or die ("ADO Connection failed.");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" . realpath("DATUM/cnbt.mdb");
$conn->Open($connstr);
/*
Create recordset query
*/
$rs = @new COM("ADODB.RecordSet");
$rs->Open("select * from dbo_dirs",$conn,1,3);
/*
Loop to read data
*/
while(!$rs->eof){
echo "$rs->Fields["title"]->Value;
echo "
";
$rs->Movenext(); //Move the record set pointer down
}
$rs->close();
?>

There will be no problem running this way...
The above is the entire content of this article, I hope you all like it.

http://www.bkjia.com/PHPjc/976023.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/976023.htmlTechArticlePHP connection operation access database instance, the access instance is because the PingSwitch made before is to be a front-end for WEB display, because a I started using the structure of Delphi and access, and the connection between Delphi and MySQL...