欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  后端开发

一个MYSQL操作类_PHP教程

程序员文章站 2022-05-19 20:49:10
...
复制代码 代码如下:

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(...