php封装mysql类_php实现mysql封装类示例

php封装mysql类

class Mysql { private $host; private $user; private $pwd; private $dbName; private $charset;

private $conn = null;

public function __construct() {

$this->host = 'localhost';  $this->user = 'root';  $this->pwd = 'root';  $this->dbName = 'test';

$this->connect($this->host,$this->user,$this->pwd);

$this->switchDb($this->dbName);

$this->setChar($this->charset); }

//负责链接 private function connect($h,$u,$p) {  $conn = mysql_connect($h,$u,$p);  $this->conn = $conn; }

//负责切换数据库 public function switchDb($db) {  $sql = 'use' . $db;  $this->query($sql); }

//负责设置字符集 public function setChar($char) {  $sql = 'set names' . $char;  $this->query($sql); }

//负责发送sql查询 public function query($sql) {  return mysql_query($sql,$this->conn); }

//负责获取多行多列的select结果 public function getAll($sql) {  $list = array();

$rs = $this->query($sql);  if (!$rs) {   return false;  }

while ($row = mysql_fetch_assoc($rs)) {   $list[] = $row;  }

return $list; }

public function getRow($sql) {  $rs = $this->query($sql);

if(!$rs) {   return false;  }

return mysql_fetch_assoc($rs); }

public function getOne($sql) {  $rs = $this->query($sql);  if (!$rs) {   return false;  }  return mysql_fetch_assoc($rs);

return $row[0]; }

public function close() {  mysql_close($this->conn); }}

echo '

';$mysql = new Mysql();print_r($mysql);

$sql = "insert into stu values (4,'wangwu','99998')";

if($mysql->query($sql)){ echo "query成功";}else { echo "失败";}

echo "
";

$sql = "select * from stu";$arr = $mysql->getAll($sql);

print_r($arr);?>