原生PHP连接access数据库及操作

1、数据写入方法：

$conn = new com("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=" . realpath("hydb/#db#.mdb");
$connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC );					//连接数据源
$sql="insert into openid (nam,gsid) values('$fromUsername',’$gsid’)"; 
$result=odbc_exec($connid,$sql);										//执行语句
if($result) echo "successful";
else echo "failed";
odbc_close($connid);  													//关闭 ODBC 连接

2、数据读取方法：

$conn=new COM("ADODB.Connection");
$connstr = "DRIVER={Microsoft Access Driver (*.mdb, *.accdb)}; DBQ=" . realpath("hydb/#db#.mdb");
$connid=odbc_connect($connstr,"","",SQL_CUR_USE_ODBC );					//连接数据源
$sql ="select * from config";  
$query = odbc_exec($connid, $sql); 
if($query){