当前位置:Gxlcms > PHP教程 > php封装mysql操作类

php封装mysql操作类

时间:2021-07-01 10:21:17 帮助过:16人阅读

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");?>

人气教程排行