php封装mysql操作类

WBOY
Release: 2016-06-23 13:44:01
Original
797 people have browsed it

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

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template