<?php
/**
Created by PhpStorm.
User: Administrator
Date: 2017/7/24
Time: 14:03
*/
/*
数据库 PDO 操作
*/
class DAO {
private function Link(){
$config=Yaf_Application::app()->getConfig();
try{
$PDO=new PDO($config['mysql']['dsn'],$config['mysql']['user'],
$config['mysql']['pass']);
$PDO->query("set names utf8"); //数据库 utf8
//关闭自动提交
$PDO->setAttribute(PDO::ATTR_AUTOCOMMIT,0);
return $PDO;
}
catch (Exception $e){
echo $e->getMessage();
}
}
//查询单条数据
public function quOne($sql,$term=''){
$PDO=$this->Link();
try{
$stmt = $PDO->prepare($sql);
if(!empty($term)){
foreach ($term as $key=>$value){
$stmt->bindParam($key, $term[$key], PDO::PARAM_STR);
}
}
$stmt->execute();
// $PDO->commit();
return $stmt->fetch(PDO::FETCH_ASSOC);
} // if there is a problem we can handle it here
catch (Exception $e) {
echo $e->getMessage();
}
}
//查询所有数据
public function quAll($sql,$term=''){
$PDO=$this->Link();
try{
$stmt = $PDO->prepare($sql);