Odysseus_110 发表于 2013-1-29 23:34:18

php连接access

 
php 连接 access 的 demo:
 
 
<?
   $conn = new COM("ADODB.Connection") or die("Cannot start ADO");
   // Microsoft Access connection string.
   $conn->Open("DRIVER={Microsoft Access Driver(*.mdb)};DBQ=C:\\inetpub\\wwwroot\\php\\mydb.mdb");
 
   //SQL statement to build recordset.
   $rs = $conn->Execute("SELECT myfield FROM mytable");
   echo "<p>Below is a list of values in the MYDB.MDB database, MYABLE table, MYFIELD field.</p>";
 
   //Display all the valus in the records set
   while(!$rs->EOF){
       $fv = $rs->Fields("myfield");
       echo "Value:".$fv->value."<br>\n";
       $rs->MoveNext();
   }
   $rs->Close();
?>
 
 
转自:http://aspn.activestate.com/ASPN/Cookbook/PHP/Recipe/123709
页: [1]
查看完整版本: php连接access