php mysql 连接 类_一个php与mysql连接类

本文介绍下，一个不错的php与mysql连接类，php5实现的，有需要的朋友参考下吧。

代码：

Connect();

}

function __destruct()

{

$this->Close();

}

private function Connect()

{

//数据库连接

$this->link=mysql_connect($this->Host,$this->UserName,$this->Password) or die("Error Connect to DB");

$this->SetError(mysql_error());

//select db ...

mysql_select_db($this->DbName) ;//or die("Error Select DB");

$this->SetError(mysql_error());

}

public function query($query)

{

//mysql查询

$this->query=mysql_query($query,$this->link);

$this->SetError(mysql_error());

}

public function assoc()

{

//mysql_fetch_assoc :

return mysql_fetch_assoc($this->query);

$this->SetError(mysql_error());

}

public function num()

{

//mysql_num_rows:

return mysql_num_rows($this->query);

$this->SetError(mysql_error());

}

public function result($index=0)

{

//mysql_result :

return mysql_result($this->query,$index);

$this->SetError(mysql_error());

}

private function SetError($error)

{

$this->last_error=$error;

}

public function ShowError()

{

return $this->last_error;

}

private function Close()

{

mysql_close($this->link);

}

}

?>

调用示例：

query("select * from table ");

//get number of result

echo $con->num() . PHP_EOL;

//get result

echo $con->result(/* $index */) . PHP_EOL;

//get all result

while($row=$con->assoc()) var_dump($row);