Home >Backend Development >PHP Tutorial >PHP database link class (PDO+Access)_PHP tutorial

PHP database link class (PDO+Access)_PHP tutorial

WBOY
WBOYOriginal
2016-07-13 17:16:55897browse

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

 

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/626675.htmlTechArticlePHP PDO Access链接 ="../../App_Data/sd#f#45G_!.mdb" ="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=". ( -conn= PDO("odbc: ") or ("PDO Connection faild." Read( , = = -conn-prepar...
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