展开全部
header("Content-type:text/html;charset=utf-8");
//用来操作mysql数据
class Mysql{
private $host;
private $port;
private $user;
private $password;
private $dbname;
private $charset;
//构造e5a48de588b662616964757a686964616f31333337616635方法:初始化
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;
}