php中mysql模块部分功能的简单封装

作者: diao大宅
来源: 51数据库
2021-11-22

复制代码代码如下:

 
class mysql 
{ 
private $db; // datebase connect 
private $result; // mysql result 
static private $mysql; // mysql object 
private function __construct() 
{ // the work before create an object 
$this->db = mysql_connect('localhost','root',''); 
mysql_select_db('hello', $this->db ); 
} 
public static function getobject() 
{ //if have a object,return that object,not create 
if(! self::$mysql instanceof self) 
self::$mysql = new self; 
return self::$mysql; 
} 
public function query($sql) 
{ 
$this->result = mysql_query($sql, $this->db); 
return $this->result; 
} 
public function fetch() 
{ 
if( isset($this->result ) ) 
return mysql_fetch_assoc( $this->result ); 
} 
public function error() 
{ 
return 'error:'.mysql_error(); 
} 
public function num() // for sql select result 
{ 
return mysql_num_rows( $this->result ); 
} 
public function close() 
{ // return true or false 
return mysql_close( $this->db ); 
} 
} 