- <?php
- class DAO{
- private $dbh;
- public function __construct(){
- $dsn = 'mysql:dbname=zrobot;host=127.0.0.1';
- $user = 'root';
- $password = 'zhudechao1877917';
- try {
- $this->dbh = new PDO($dsn, $user, $password,array(PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES 'utf8';"));
- } catch (PDOException $e) {
- echo 'Connection failed: ' . $e->getMessage();
- }
- }
- public function sRow($sql){
- $sth = $this->dbh->prepare($sql);
- $sth->execute();
- $ret = $sth->fetchAll(PDO::FETCH_ASSOC);
- return $ret[0];
- }
- public function sRows($sql){
- $sth = $this->dbh->prepare($sql);
- $sth->execute();
- return $sth->fetchAll(PDO::FETCH_ASSOC);
- }
- public function dbInsert($sql){
- $sth = $this->dbh;
- $count = $sth->exec($sql);
- if($count){
- return true;
- }else {
- return false;
- }
- }
- //insert update
- public function dbIUD($sql){
- $sth = $this->dbh;
- $count = $sth->exec($sql);
- if($count){
- return true;
- }else {
- return false;
- }
- }
- }
- //该片段来自于http://www.codesnippet.cn/detail/1602201614536.html
来源: http://www.codesnippet.cn/detail/1602201614536.html