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

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

Jun 13, 2016 am 10:17 AM
accessappdatapdophpdatabasekindLink

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

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

Video Face Swap

Video Face Swap

Swap faces in any video effortlessly with our completely free AI face swap tool!

Hot Tools

Atom editor mac version download

Atom editor mac version download

The most popular open source editor

VSCode Windows 64-bit Download

VSCode Windows 64-bit Download

A free and powerful IDE editor launched by Microsoft

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

SublimeText3 English version

SublimeText3 English version

Recommended: Win version, supports code prompts!

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor