php mysql操作封装类_php封装mysql操作类

class mysql{

private $host;

private $name;

private $pass;

private $table;

private $ut;

function __construct($host,$name,$pass,$table,$ut){

$this->host=$host;

$this->name=$name;

$this->pass=$pass;

$this->table=$table;

$this->ut=$ut;

$this->connect();

}

function connect(){

$link=mysql_connect($this->host,$this->name,$this->pass) or die ($this->error());

mysql_select_db($this->table,$link) or die("没有数据库".$this->table);

mysql_query("SET NAMES '$this->ut'");

}

function query($sql, $type = '') {

if(!($query = mysql_query($sql))) $this->show('Say:', $sql);

return $query;

}

function show($message = '', $sql = '') {

if(!$sql) echo $message;

else echo $message.'
'.$sql;

}

function affected_rows() {

return mysql_affected_rows();

}

function result($query, $row) {

return mysql_result($query, $row);

}

function num_rows($query) {

return @mysql_num_rows($query);

}

function num_fields($query) {

return mysql_num_fields($query);

}

function free_result($query) {

return mysql_free_result($query);

}

function insert_id() {

return mysql_insert_id();

}

function fetch_row($query) {

return mysql_fetch_row($query);

}

function version() {

return mysql_get_server_info();

}

function close() {

return mysql_close();

}

//==============

function fn_insert($table,$name,$value){

$this->query("insert into $table ($name) value ($value)");

}

}

$db = new mysql('localhost','root','','data',"GBK");

?>