PHP数据库链接类（PDO+Access）

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));