php mysql数据库操作类

php mysql数据库操作类

<?php 
/*
 * class mysql
 * 2011/8/25
 * kcj
 */ 
 
   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','','phpjob_db',"GBK"); 
 
  //$db->fn_insert('test','id,title,dates',"'','我插入的信息',now()");  
 
 
 
?> 

摘自 chaojie2009的专栏