时时商务社区

标题: php实现mysql封装类示例 [打印本页]

作者: 新格网络 时间: 2018-2-14 05:58

         php封装mysql类
[U]复制代码[/U] 代码如下:
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);
?>


您可能感兴趣的文章:

PHP访问MYSQL数据库封装类(附函数说明)

php中mysql模块部分功能的简单封装

全新的PDO数据库操作类php版（仅适用Mysql）

PHP数据库链接类(PDO+Access)实例分享

php基于单例模式封装mysql类完整实例

php基于PDO实现功能强大的MYSQL封装类实例

欢迎光临时时商务社区 (http://bbs.4435.cn/)