scvmm 发表于 2017-3-4 13:47:24

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