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
AI-powered app for creating realistic nude photos

AI Clothes Remover
Online AI tool for removing clothes from photos.

Undress AI Tool
Undress images for free

Clothoff.io
AI clothes remover

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

Hot Article
What's New in Windows 11 KB5054979 & How to Fix Update Issues
3 weeks agoByDDD
How to fix KB5055523 fails to install in Windows 11?
2 weeks agoByDDD
InZoi: How To Apply To School And University
4 weeks agoByDDD
How to fix KB5055518 fails to install in Windows 10?
2 weeks agoByDDD
Roblox: Dead Rails – How To Summon And Defeat Nikola Tesla
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Atom editor mac version download
The most popular open source editor

VSCode Windows 64-bit Download
A free and powerful IDE editor launched by Microsoft

Zend Studio 13.0.1
Powerful PHP integrated development environment

SublimeText3 English version
Recommended: Win version, supports code prompts!

Notepad++7.3.1
Easy-to-use and free code editor
