php 与access 数据库连接实例

  echo "

";
  echo "";
  echo "";
  echo "";
  echo "";
  echo "";
  echo "";
  $connstr="DRIVER=Microsoft Access Driver (*.mdb);DBQ=".realpath("SpiderResult.mdb");
  $conn=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC );
  $query=odbc_do($conn,"select top 10 * from content");
  while(odbc_fetch_row($query)) {
  
   echo "";
   $personID = odbc_result($query,1);
  
   $FirstName = odbc_result($query,2);
   $LastName = odbc_result($query,3);
   $Age = odbc_result($query,4);
   echo "";
   echo "";
   echo "";
   echo "";
   echo "";
  }
  echo "

personID	FirstName	LastName	Age
" . $personID . "	" . $FirstName . "	" . $LastName . "	" . $Age . "

";
  odbc_close($conn);
  //本站原创www.111com.net