首頁 >後端開發 >php教程 >php封装mysql操作类

php封装mysql操作类

WBOY
WBOY原創
2016-06-23 13:44:01836瀏覽

<?php 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.'<br>'.$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");?>

陳述:
本文內容由網友自願投稿,版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容,請聯絡admin@php.cn