複製內容到剪貼板
代碼:
<?
class DB
{
// 設定連線資料
var $host = '';
var $user = '';
var $password = '';
var $database = '';
var $persistent = false;
// 資料庫連線名稱
var $conn = NULL;
// 查詢結果
var $result = array();
var $insert_id = array();
function DB($host, $user, $password, $database, $persistent = false)
{
$this->host = $host;
$this->user = $user;
$this->password = $password;
$this->database = $database;
$this->persistent = $persistent;
}
function open()
{
// 選擇適當的連線函數
if ($this->persistent)
{
$func = 'mysql_pconnect';
}
else
{
$func = 'mysql_connect';
}
// 連線到 MySQL 伺服器
$this->conn = $func($this->host, $this->user, $this->password);
if (!$this->conn)
{
return false;
}
// 選擇需要使用的資料庫
if (!@mysql_select_db($this->database, $this->conn))
{
return false;
}
return true;
}
function close()
{
return (@mysql_close($this->conn));
}
function error()
{
return (mysql_error());
}
function query($sql = '', $rs_id = 'RESULT_ID')
{
$this->result[$rs_id] = @mysql_query($sql, $this->conn);
$this->insert_id[$rs_id] = @mysql_insert_id();
return ($this->result[$rs_id] != false);
}
function affectedRows()
{
return (@mysql_affected_rows($this->conn));
}
function numRows($rs_id='RESULT_ID')
{
return (@mysql_num_rows($this->result[$rs_id]));
}
function fetchObject($rs_id='RESULT_ID')
{
return (@mysql_fetch_object($this->result[$rs_id]));
}
function fetchArray($rs_id='RESULT_ID')
{
return (@mysql_fetch_array($this->result[$rs_id], MYSQL_NUM));
}
function fetchAssoc($rs_id='RESULT_ID')
{
return (@mysql_fetch_assoc($this->result[$rs_id]));
}
function freeResult($rs_id='RESULT_ID')
{
return (@mysql_free_result($this->result[$rs_id]));
}
// Modified By Jace Ju
function resetResult($rs_id='RESULT_ID')
{
return (@mysql_data_seek($this->result[$rs_id], 0));
}
function getInsertID($rs_id='RESULT_ID')
{
return $this->insert_id[$rs_id];
}
}
?>