您的位置 >>> 星想互联 >>> 编程技术 >>> PHP基础
学习笔记:PDO封装的数据库操作类
点击数:1862  发布时间2017-09-27 20:29:20

<?php
header("Content-type: text/html; charset=gb2312");
class dosql{
 private $arr=array(
  'host'=>'localhost',
  'user'=>'root',
  'pwd'=>'',
  'dbname'=>'news',
  'ci'=>'set names gb2312',
  );

 private $links;
    public $stmt;

 public function __construct(){
  $this->connect();
 }

    public function connect(){
     $host=$this->arr['host'];
     $user=$this->arr['user'];
     $pwd=$this->arr['pwd'];
     $dbname=$this->arr['dbname'];
     $ci=$this->arr['ci'];
     $this->links=new pdo("mysql:host=$host;dbname=$dbname","$user","$pwd");
     $this->links->query($ci);
    }

    public function query($sql){
     if(!$sm=$this->links->query($sql)){
      echo "error";
  }
  return $sm;
    }

    public function getRow($sql){
     $rk=$this->links->query($sql)->fetch();
        return $rk; 
    }

    public function getAll($sql){
        $rk=$this->links->query($sql)->fetchAll();
        return $rk;
    }

}

$stmt=new dosql();
$rs=$stmt->getAll("selectS * from news");
var_dump($rs);
 ?>

来源:咸宁网站建设