首页  >  文章  >  后端开发  >  php封装mysql操作类

php封装mysql操作类

WBOY
WBOY原创
2016-06-23 13:44:01795浏览

<?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