欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

php封装mysql操作类

程序员文章站 2024-01-31 09:00:46
...
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");?>