<?php <?php header("Content-type:text/html;charset=utf-8"); //用来操作mysql数据 class Mysql{ private $host; private $port; private $user; private $password; private $dbname; private $charset; //构造方法:初始化 public function __construct($info = array()){ $this -> host = isset($info['host']) ? $info['host'] : "localhost"; $this -> port = isset($info['port']) ? $info['port'] : "3306"; $this -> user = isset($info['user']) ? $info['user'] : "root"; $this -> password = isset($info['password']) ? $info['password'] : "root"; $this -> dbname = isset($info['dbname']) ? $info['dbname'] : "haoyigou"; $this -> charset = isset($info['charset']) ? $info['charset'] : "utf8"; $this -> db_connect(); $this -> db_charset(); $this -> db_name(); } // 数据库连接 private function db_connect(){ $res = @mysql_connect($this->host.":".$this->port,$this->user,$this->password); if(!$res){ echo "数据库连接失败!"; echo "错误编号是:".mysql_errno().""; echo "错误信息是:".iconv('gbk','utf-8',mysql_error()).""; exit; } } //封装验证方法 public function db_query($sql){ $res = @mysql_query($sql); if(!$res){ echo "sql语句语法错误!"; echo "错误编号是:".mysql_errno().""; echo "错误信息是:".iconv('gbk','utf-8',mysql_error()).""; exit; } return $res; } //设置字符集 private function db_charset(){ $sql = "set names {$this->charset}"; $this->db_query($sql); } //使用数据库 private function db_name(){ $sql = "use {$this->dbname}"; $this->db_query($sql); } //增删改 public function db_add($sql){ //执行语句 $this->db_query($sql); $id = mysql_insert_id(); return $id ? $id : mysql_affected_rows(); } //查:输出单条数据 public function db_getone($sql){ $res = $this->db_query($sql); //看不懂私聊我 $row = mysql_fetch_assoc($res); return $row; }
PHP操控mysql
最新推荐文章于 2021-03-09 16:01:46 发布