Viewing file:  database.php (2.99 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//****************************************************************************
// phpDatabase 2.1
//****************************************************************************
// Author: Maxim Poltarak <maxx at e dash taller dot net>
// Category: Databases
//****************************************************************************
// The lib is FREEWARE. This means you may use it anywhere you want, you may
// do anything with it. The Author mentioned above is NOT responsible for any
// consequences of using this library.
// If you don't agree with this, you MAY NOT use the lib!
//****************************************************************************
// All improvings, feature requests, bug reports, etc. are gladly accepted.
//****************************************************************************
// Note: For best viewing of the code Tab size 4 is recommended
//****************************************************************************
class CDatabase {
var $link;
var $db;
var $host, $user, $pass;
function CDatabase($db, $host="localhost", $user="", $pass="") {
$this->db = $db; $this->host = $host; $this->user = $user; $this->pass = $pass;
if($this->link = mysql_connect($host,$user,$pass))
return mysql_select_db($db, $this->link);
else return 0;
}
function query($sql) {
if(!$this->link) return 0;
return mysql_query($sql, $this->link);
}
function affected_rows() {
return mysql_affected_rows($this->link);
}
function num_rows($q) {
return mysql_num_rows($q);
}
function fetch_array($q, $result_type=MYSQL_ASSOC) {
return mysql_fetch_array($q, $result_type);
}
function fetch_object($q) {
return mysql_fetch_object($q);
}
function data_seek($q, $n) {
return mysql_data_seek($q, $n);
}
function free_result($q) {
return mysql_free_result($q);
}
function insert_id() {
return mysql_insert_id($this->link);
}
function error() {
return mysql_error($this->link);
}
function error_die($msg='') {
die(((empty($msg))?'':$msg.': ').$this->error());
}
function sql2var($sql) {
if((empty($sql)) || (!($query = $this->query($sql)))) return false;
if($this->num_rows($query) < 1) return false;
return $this->result2var($query);
}
function result2var($q) {
if(!($Data = $this->fetch_array($q))) return false;
$this->free_result($q);
foreach($Data as $k=>$v) $GLOBALS[$k] = $v;
return true;
}
function sql2array($sql, $keyField='') {
if((empty($sql)) || (!($query = $this->query($sql)))) return false;
if($this->num_rows($query) < 1) return false;
return $this->result2array($query, $keyField);
}
function result2array($q, $keyField='') {
$Result = array();
while($Data = $this->fetch_array($q))
if(empty($keyField)) $Result[] = $Data;
else $Result[$Data[$keyField]] = $Data;
$this->free_result($q);
return $Result;
}
function list_tables() {
return mysql_list_tables($this->db, $this->link);
}
function list_fields($table_name) {
return mysql_list_fields($this->db, $table_name, $this->link);
}
};
?>
|