php数据库连接管理,你如何管理PHP中的数据库连接？

类的使用是增加自定义可重用性的方法.

将所有通用实现都引入到类中.你在正确的轨道上.

class connection {

// Possible Modules are as follows:

// DBX_MYSQL, DBX_ODBC, DBX_PGSQL, DBX_MSSQL, DBX_FBSQL, DBX_SYBASECT, DBX_OCI8, DBX_SQLITE

private $module = DBX_MYSQL;

private $host = "localhost";

private $database = "test";

private $username = "testuser";

private $password = "testpass";

private $link;

private $result;

public $sql;

function __construct($database=""){

if (!empty($database)){ $this->database = $database; }

$this->link = dbx_connect($this->module,$this->host,$this->database,$this->username,$this->password);

return $this->link; // returns false if connection could not be made.

}

function query($sql){

if (!empty($sql)){

$this->sql = $sql;

$this->result = dbx_query($this->link,$sql,DBX_RESULT_UNBUFFERED);

return $this->result;

}else{

return false;

}

}

function fetch($result=""){

if (empty($result)){ $result = $this->result; }

return dbx_fetch_row($result);

}

function __destruct(){

dbx_close($this->link);

}

}