PHP PDO Access链接
<span class</span><span DbHelpClass
{
</span><span private</span> <span $conn</span><span ;
</span><span private</span> <span $qxId</span><span ;
</span><span private</span> <span $ret</span><span ;
</span><span function</span><span __construct()
{
</span><span $path</span>="../../App_Data/sd#f#45G_!.mdb"<span ;
</span><span $constr</span>="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".<span realpath</span>(<span $path</span><span );
</span><span $this</span>->conn= <span new</span> PDO("odbc:<span $constr</span>") or <span die</span> ("PDO Connection faild."<span );
}
</span><span /*</span><span 读取</span><span */</span>
<span function</span> Read(<span $sql</span>,<span $params</span>=<span array</span><span ())
{
</span><span $bind</span>=<span $this</span>->conn->prepare(<span $sql</span><span );
</span><span $arrKeys</span>=<span array_keys</span>(<span $params</span><span );
</span><span foreach</span>(<span $arrKeys</span> <span as</span> <span $row</span><span )
{
</span><span $bind</span>->bindValue(":".<span $row</span>,<span $params</span>[<span $row</span><span ]);
}
</span><span $bind</span>->execute() or <span die</span>('sql error:'.<span $sql</span><span );
</span><span $result</span>=<span $bind</span>-><span fetchAll();
</span><span return</span> <span $result</span><span ;
}
</span><span /*</span><span 添加,修改需调用此方法</span><span */</span>
<span function</span> Edit(<span $sql</span>,<span $params</span>=<span array</span><span ())
{
</span><span $bind</span>=<span $this</span>->conn->prepare(<span $sql</span><span );
</span><span $arrKeys</span>=<span array_keys</span>(<span $params</span><span );
</span><span foreach</span>(<span $arrKeys</span> <span as</span> <span $row</span><span )
{
</span><span $bind</span>->bindValue(":".<span $row</span>,<span $params</span>[<span $row</span><span ]);
}
</span><span $a</span>=<span $bind</span>->execute() or <span die</span>('sql error'<span );
</span><span return</span> <span $a</span><span ;
}
}
</span><span $dbh</span> =<span new</span> DbHelpClass();
调用：
<span $dbh</span>->Read('select title from pro where id=:id',<span array</span>(id=>1));
