Home  >  Article  >  Backend Development  >  A MYSQL operation class_PHP tutorial

A MYSQL operation class_PHP tutorial

WBOY
WBOYOriginal
2016-07-21 16:01:19940browse

复制代码 代码如下:

class DB{    
var $host_addr = "localhost";
var $host_user = "root";
var $host_psw  = "123";
var $db_name   = "test";

var $link_id;
var $query_id;
var $numRow;

function DB(){
     $this->link_id = @mysql_connect($this->host_addr,$this->host_user,$this->host_psw);
  if($this->link_id){
      @mysql_select_db($this->db_name,$this->link_id) or $this->halt("数据库连接失败!");
  }else{
      $this->halt("连接服务器失败!");
   return false;
  }
  return $this->link_id;
}
function query($sql){
     $this->query_id = @mysql_query($sql,$this->link_id);
  if($this->query_id){
      return $this->query_id;
  }else{
      $this->halt("SQL Error::");
   return false;
  }
}
function numRow(){
     return $this->numRow = @mysql_num_rows($this->query_id);
}
function close(){
     return @mysql_close($this->link_id);
}
function halt($msg){
     echo "".$msg."";
}

}
?>

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/316920.htmlTechArticle复制代码 代码如下: ?php classDB{ var$host_addr="localhost"; var$host_user="root"; var$host_psw="123"; var$db_name="test"; var$link_id; var$query_id; var$numRow; functionDB(...
Statement:
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