<?php
require_once(LIB_PATH.DS."config.php");
class Database {
var $data;
var $sql_string = '';
var $error_no = 0;
var $error_msg = '';
private $conn;
public $last_query;
private $magic_quotes_active;
private $real_escape_string_exists;
function __construct() {
$this->open_connection();
$this->real_escape_string_exists = function_exists("mysql_real_escape_string"); }
public function open_connection() {
if(!$this->conn){
echo "Problem in database connection! Contact administrator!";
}else{
if (!$db_select) {
echo "Problem in selecting database! Contact administrator!";
}
}
}
function setQuery($sql='') {
$this->sql_string=$sql;
}
function executeQuery() {
$this->confirm_query($result);
return $result;
}
private function confirm_query($result) {
if(!$result){
return false;
}
return $result;
}
function loadResultList( $key='' ) {
$cur = $this->executeQuery();
if ($key) {
$array[$row->$key] = $row;
} else {
$array[] = $row;
}
}
return $array;
}
function loadSingleResult() {
$cur = $this->executeQuery();
return $data = $row;
}
}
function getFieldsOnOneTable( $tbl_name ) {
$this->setQuery("DESC ".$tbl_name);
$rows = $this->loadResultList();
for ( $x=0; $x<count( $rows ); $x++ ) { $f[] = $rows[$x]->Field;
}
return $f;
}
public function fetch_array($result) {
}
public function num_rows($result_set) {
}
public function insert_id() {
}
public function affected_rows() {
}
public function escape_value( $value ) {
if( $this->real_escape_string_exists ) {
if( $this->magic_quotes_active ) { $value = stripslashes( $value ); } } else {
if( !$this->magic_quotes_active ) { $value = addslashes( $value ); } }
return $value;
}
public function close_connection() {
}
}
}
$mydb = new Database();
?>