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

复制代码 代码如下:

class mysql

{

private $db; // dateba 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_lect_db(‘hello’, $this->db );

}

public static function geto立体画教程bject()

{ //if have a object,return that object,not create

if(! lf::$mysql instanceof lf)

lf::$mysql = new lf;

return lf::$mysql;

}

pu宜良一中blic function query($sql)

{

$this->result = mysql_query($sql, $this->db);

return $this->result;

}

public function fetch()

{

if( ist($this->result千里共婵娟什么意思 ) )

return mysql_fetch_assoc( $this->result );

}

public function error()

{

return ‘error:’.mysql_error();

}

public function num() // for sql lect result

{

return mysql_num_rows( $this->result );

}

public function clo()

{ // return true or fal

鬼节习俗return mysql_clo( $this->db );

}

}

这样做看起来就只对可移植有用，其它的作用还体会不到