PHP写ACCESS数据库得函数是那些？

Question

用 adodbhttp://www.phpe.net/articles/262.shtml

Answer 1

odbc系列函数可以
但是功能有限制比如odbc_num_rows就没用建议还是用adodb

Answer 2

<?php
$save_file='dic.php';
$conn=new COM("ADODB.Connection"); 
$dsn="DRIVER={Microsoft Access Driver (*.mdb)};DBQ=".realpath("data.mdb").";Uid=Admin;Pwd=BDC2002Data;";  
$conn->open($dsn);  
$sql="select * from dict";  
$rs=$conn->Execute($sql);
$row="0";
while(!$rs->EOF)
{
for ($i=0;$i<$rs->Fields->count;$i++)
{
if ($i==0)
{
$string.=$rs->Fields($i)->Value;
continue;
}
$string.='|'.$rs->Fields($i)->Value;
}
$string.="\n";
if ($row==300)
{
//break;
}
$row++;
$rs->MoveNext();
}
$h=fopen($save_file,"wb");
fwrite($h,$string);
fclose($h);
?>