写一个mysql类PHP_php编写mysql操作类

文件：mysql.class.php<?phperror_reporting (E_ALL ^E_DEPRECATED);/*mysql操作类

* 1.连接数据库

* 2.选择需要操作的库

* 3.设置操作的编码

* 4.增删改查

* 查询分两种情况：

* 1.查询一条数据：执行一次mysql_fetch_assoc

* 2.查询多跳数据：执行多次mysql_fetch_assoc

* 5.关闭数据库*/

class mysql{public $hostname; //mysql主机

public $username; //mysql用户名

public $password; //mysql密码

public $conn; //连接标识符

public $dbname; //操作的数据库名

public $charset; //操作编码

//初始化

function __construct($hostname,$username,$password,$dbname,$charset) {$this->hostname = $hostname;$this->username = $username;$this->password = $password;$this->dbname = $dbname;$this->charset = $charset;//曾经的方式

//连接数据库

$this->conn = mysql_connect($this->hostname,$this->username,$this->password);//选择操作的数据库

mysql_select_db($this->dbname,$this->conn);//现在的方式，连接数据库并选择操作的数据库

//$this->conn = mysqli_connect($this->hostname,$this->username,$this->password,$this->dbname)

//or die(mysql_error());

//3.设置操作的编码

$this->query("set names '".$this->charset."'");

}//执行SQL语句的方法

function query($sql){return mysql_query($sql,$this->conn);

}//添加

function add($table,$set){$sql = "insert into {$table} set {$set}";$result=$this->query($sql);return $result;

}//修改

function edit($table,$set,$where){$sql = "update {$table} set {$set} where {$where}";$result = $this->query($sql);return $result;

}//删除

function del($table,$where){$sql = "delete from {$table} where {$where}";$result = $this->query($sql);return $result;

}//查询一条数据

function find($table,$where="",$fields="*",$order=""){$where = empty($where) ? "": " where ".$where;$order = empty($order) ? "": " order by ".$order;//$limit = empty($limit) ? "": " limit ".$limit;

$sql = "select {$fields} from {$table} {$where} {$order} limit 1 ";$query = $this->query($sql);$row = mysql_fetch_assoc($query);return $row;

}//查询多条数据

function select($table,$where="",$fields="*",$order="",$limit=""){$where = empty($where) ? "": " where ".$where;$order = empty($order) ? "": " order by ".$order;$limit = empty($limit) ? "": " limit ".$limit;$sql = "select {$fields} from {$table} {$where} {$order} {$limit} ";$query = $this->query($sql);$result = array();while($row = mysql_fetch_assoc($query)){//将$row的值添加到$result的数组中去

$result[] = $row;

}return $result;

}//回收资源

function__destruct(){mysql_close($this->conn);

}

}?>文件2： ceshi.php<?phpinclude "mysql.class.php";$db= new mysql("localhost","root","","test","GBK");//执行添加

//$db->add("test","id='',uid='sky',regdate=now(),remark='student1'");

//执行修改

//$db->edit("test","id='23',uid='nono',regdate=now(),remark='程序员'","id='22'");

//执行删除

//$db->del("test","id='23'");

//执行查找

//$rs= $db->find("test","id=3","uid,remark","desc");

//print_r($rs);

//执行多条查找

$rs = $db->select("test");print_r($rs);?>