Home >php教程 >php手册 >PHP数据库链接类(PDO+Access)

PHP数据库链接类(PDO+Access)

WBOY
WBOYOriginal
2016-06-13 10:17:291282browse

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

 

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:php生成uuid格式字符串Next article:PHP实体层基础类