A simple example of PHP using ADODB through COM_PHP tutorial

To implement the following functionality, make sure the com.allow_dcom option in php.ini is set to true.

1. Preparation

Create a new ACCESS database and name it db.mdb, and then create a new table comtest in this database, including id and title fields, and finally insert some data.

2. Implementation code

// It is the newly built database
$db = 'd:\wwwroot\db. mdb';

// Establish a connection and open
$conn = new COM('ADODB.Connection') or die('can not start Active X Data Objects');
// $conn->Open("Provider=Microsoft.Jet.OLEDB.4.0; Data Source=$db");
$conn->Open("DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=$db");

//Execute query and output data
$rs = $conn->Execute('SELECT * FROM comtest');
?>

while (!$rs->EOF) {
echo '';
echo '';
echo '';
echo ' ';
$rs->MoveNext();
}
?>

ID	Title
'. $rs->Fields['id']-> Value .'	'. $rs->Fields['title']->Value .'

// Release Resources
$rs->Close();
$conn->Close();
$rs = null;
$conn = null;
?>

http://www.bkjia.com/PHPjc/317525.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/317525.htmlTechArticleTo achieve the following functions, please ensure that the com.allow_dcom option in php.ini is set to true. 1. Preparation Create a new ACCESS database and name it db.mdb, and then create a new...