如何将PHP PDO连接数据库的代码改写成长尾词?
- 内容介绍
- 文章标签
- 相关推荐
本文共计180个文字,预计阅读时间需要1分钟。
phpclass DAO { private $dbh;
public function __construct() { $dsn='mysql:host=127.0.0.1;dbname=zrobot'; $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(); } }}
<?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; } } }
本文共计180个文字,预计阅读时间需要1分钟。
phpclass DAO { private $dbh;
public function __construct() { $dsn='mysql:host=127.0.0.1;dbname=zrobot'; $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(); } }}
<?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; } } }

