高清国产av一区二区三区_亚洲欧美日韩在线_无码熟妇人妻av在线影片免费_在线无码一级伊伊_爽好舒服高H自慰软件_亚洲熟女区偷拍区高清区_午夜福利影院啪啪_亚洲国产黄片在线播放_中文字幕日韩精品乐乐影院_久久国产亚洲日韩欧美精品

view sourceprint?01.<!--? class mysql
{
  
private $host;
   
private $user;
  
private $pass;
  
private $database;
   
private $charset;
   
function __construct($host,$user,$pass,$database,$charset)
    {
      
$this--->host=$host;
      
$this->user=$user;
     
$this->pass=$pass;
      
$this->database=$database;
     
$this->charset=$charset;
      
$this->connect();
   }
  
private function connect()//連接函數(shù)
   {
       
mysql_connect($this->host,$this->user,$this->pass) or die ("連接數(shù)據(jù)庫(kù)服務(wù)器失敗!");
      
mysql_select_db($this->database) or die ("連接數(shù)據(jù)庫(kù)失敗!");
       
mysql_query("set names $this->charset");        
    }   
function select($sql,$tab,$col,$value)//選擇函數(shù)
   {        
$select=mysql_query("select $sql from $tab where $col=$value");
       
$row=mysql_fetch_array($select);       
    return $row;
    }    
function insert($tab,$col,$value)//插入數(shù)據(jù)函數(shù)
    {        
mysql_query("INSERT INTO $tab($col)values($value)");
    }   
function update($tab,$col,$new_value,$colm,$value)//更新數(shù)據(jù)函數(shù)
    {        
mysql_query("UPDATE $tab SET $col=$new_value where $colm=$value");    
    }   
function delete($tab,$col,$value)//刪除數(shù)據(jù)函數(shù)
   {        
mysql_query("DELETE FROM $tab where $col=$value");
     }   
function close()//關(guān)閉連接函數(shù)    
   {    
     mysql_close();
      
    }
}
//$mysql=new mysql("127.0.0.1","root","120360150","test","gbk");連接數(shù)據(jù)庫(kù)
//$sql=$mysql->select("*","admin","id","3");//選擇數(shù)據(jù)
//print_r($sql);//打印返回的數(shù)組
//$mysql->insert("admin","user_name,user_pass","'123','123'");插入數(shù)據(jù)
//$mysql->update("admin","user_pass","22","id","3");更新數(shù)據(jù)
//$mysql->delete("admin","id","4");刪除數(shù)據(jù)
//$mysql->close();關(guān)閉連接
?>