<?php
class DB
{
var $host = '';
var $user = '';
var $password = '';
var $database = '';
var $persistent = false;
var $conn = NULL;
var $result = false;
function DB($host, $user, $password, $database, $persistent = false)
{
$this->host = $host;
$this->user = $user;
$this->password = $password;
$this->database = $database;
$this->persistent = $persistent;
return $this;
}
function open()
{
if ($this->persistent) {
$func = 'mysql_pconnect';
} else {
$func = 'mysql_connect';
}
//print "host=" . $this->host . "<br>";
//print "user=" . $this->user . "<br>";
//print "password=" . $this->password . "<br>";
$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 = '')
{
$this->result = @mysql_query($sql, $this->conn);
return ($this->result != false);
}
function listFields($sql = '')
{
$this->result = @mysql_list_fields($this->database, $sql, $this->conn);
return ($this->result != false);
}
function affectedRows()
{
return (@mysql_affected_rows($this->conn));
}
function numRows()
{
return (@mysql_num_rows($this->result));
}
function numFields()
{
return (@mysql_num_fields($this->result));
}
function freeResult()
{
return (@mysql_free_result($this->result));
}
function fetchObject()
{
return (@mysql_fetch_object($this->result, MYSQL_ASSOC));
}
function fetchArray()
{
return (@mysql_fetch_array($this->result, MYSQL_NUM));
}
function fetchAssoc()
{
return (@mysql_fetch_assoc($this->result));
}
function dataSeek($page)
{
return (@mysql_data_seek($this->result, $page));
}
function getResult($num)
{
return (@mysql_result($this->result, $num));
}
function fieldName($num)
{
return (@mysql_field_name($this->result, $num));
}
}