php 完美db类,phpDB类分享

最近在用php做项目，用到php的封装类：特分享如下：

class mysql{

private $conn;

public function connect(){

$this->conn = mysql_connect("localhost","quant","qndbadmin");

mysql_select_db("finance", $this->conn);

}

public function query($sql){

if( !$conn) $this->connect();

return mysql_query($sql,$this->conn);

}

public function insert($sql){

if( !$conn) $this->connect();

$res=mysql_query($sql);

return $res?mysql_insert_id():$res;

}

public function getRow($sql){

$result=$this->query($sql);

return mysql_fetch_array($result);

}

public function getAll($sql){

return $this->select( $this->query($sql));

}

public function inserted(){

return mysql_insert_id();

}

function select($rs)

{

if(!isset($rs)) return false;

while($info = $this->fetch($rs))

{

$result[] = $info;

}

return $result;

}

//返回结果集

function fetch( $p_rs, $p_type = "array" )

{

if( $p_type == "array" )

{

return mysql_fetch_array( $p_rs , MYSQL_ASSOC);

}

else if( $p_type == "object" )

{

return mysql_fetch_object( $p_rs );

}

else

{

return mysql_fetch_row( $p_rs );

}

}

}