当前位置:Gxlcms > PHP教程 > PHP数据库链接类(PDO+Access)实例分享_PHP教程

PHP数据库链接类(PDO+Access)实例分享_PHP教程

时间:2021-07-01 10:21:17 帮助过:25人阅读

PHP PDO Access链接

代码如下:
class DbHelpClass
{
private $conn;
private $qxId;
private $ret;

function __construct()
{
$path="../../App_Data/sd#f#45G_!.mdb";
$constr="DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=".realpath($path);
$this->conn= new PDO("odbc:$constr") or die ("PDO Connection faild.");

}

/*读取*/
function Read($sql,$params=array())
{
$bind=$this->conn->prepare($sql);
$arrKeys=array_keys($params);
foreach($arrKeys as $row)
{
$bind->bindValue(":".$row,$params[$row]);
}
$bind->execute() or die('sql error:'.$sql);
$result=$bind->fetchAll();

return $result;
}

/*添加,修改需调用此方法*/
function Edit($sql,$params=array())
{
$bind=$this->conn->prepare($sql);
$arrKeys=array_keys($params);
foreach($arrKeys as $row)
{
$bind->bindValue(":".$row,$params[$row]);

}

$a=$bind->execute() or die('sql error');
return $a;
}
}
$dbh =new DbHelpClass();

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/621697.htmlTechArticlePHP PDO Access链接 代码如下:

class DbHelpClass { private $conn; private $qxId; private $ret; function __construct() { $path="../../App_Data/sd#f#45G_!.mdb"; $con...

人气教程排行