philxyz0316

複製內容到剪貼板

代碼:

<?
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];
}
}
?>