php封装mysql操作类

来源:互联网 发布:淘宝标题重复关键字 编辑:程序博客网 时间:2024/05/13 12:57
<?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");?>

0 0
原创粉丝点击