<?php
class dbo{
private $conn;
private $host;
private $username;
private $password;
private $dbname;
function __construct($host,$username,$password,$dbname)
{
$this->host=$host;
$this->username=$username;
$this->password=$password;
$this->conn=mysql_connect($host,$username,$password) or die ('Not connected : ' . mysql_error());
$this->select_db($dbname);
mysql_query('set names UTF-8');
}
function __get($name)
{
return $this->$name;
}
function __set($name,$value)
{
$this->$name = $value;
}
function connectDb($host,$username,$password)
{
$this->conn = mysql_connect($host,$username,$password) or die('Not connected : ' . mysql_error());
}
function select_db($dbname)
{
mysql_select_db($dbname,$this->conn) or die('选择数据库失败:'.mysql_errno());
}
//执行select语句,批量查询
function queryAll($sql)
{
$result = mysql_query($sql,$this->conn);
if(!$result)
{
return false;
}
return $this->result2Array($result);
}
function result2Array($result)
{
if(!$result)
{
die('结果集不正确');
}
$resultArray = array();
while ($row = mysql_fetch_array($result)) {
array_push($resultArray,$row);
}
mysql_free_result($result);
return $resultArray;
}
function queryOne($sql)
{
$result=mysql_query($sql,$this->conn);
if(!$result)
{
return array();
}
return mysql_fetch_assoc($result);
}
function query($sql)
{
try {
$result = mysql_query($sql,$this->conn);
}
catch (Exception $e)
{
die($e);
}
if(!$result)
{
return false;
}
return mysql_affected_rows();
}
//关闭数据库连接
function closeDb()
{
mysql_close($this->conn);
}
function __destruct()
{
$this->closeDb();
}
}
class dbo{
private $conn;
private $host;
private $username;
private $password;
private $dbname;
function __construct($host,$username,$password,$dbname)
{
$this->host=$host;
$this->username=$username;
$this->password=$password;
$this->conn=mysql_connect($host,$username,$password) or die ('Not connected : ' . mysql_error());
$this->select_db($dbname);
mysql_query('set names UTF-8');
}
function __get($name)
{
return $this->$name;
}
function __set($name,$value)
{
$this->$name = $value;
}
function connectDb($host,$username,$password)
{
$this->conn = mysql_connect($host,$username,$password) or die('Not connected : ' . mysql_error());
}
function select_db($dbname)
{
mysql_select_db($dbname,$this->conn) or die('选择数据库失败:'.mysql_errno());
}
//执行select语句,批量查询
function queryAll($sql)
{
$result = mysql_query($sql,$this->conn);
if(!$result)
{
return false;
}
return $this->result2Array($result);
}
function result2Array($result)
{
if(!$result)
{
die('结果集不正确');
}
$resultArray = array();
while ($row = mysql_fetch_array($result)) {
array_push($resultArray,$row);
}
mysql_free_result($result);
return $resultArray;
}
function queryOne($sql)
{
$result=mysql_query($sql,$this->conn);
if(!$result)
{
return array();
}
return mysql_fetch_assoc($result);
}
function query($sql)
{
try {
$result = mysql_query($sql,$this->conn);
}
catch (Exception $e)
{
die($e);
}
if(!$result)
{
return false;
}
return mysql_affected_rows();
}
//关闭数据库连接
function closeDb()
{
mysql_close($this->conn);
}
function __destruct()
{
$this->closeDb();
}
}
忘了,在mysql中,字符编码是utf8