(DB) Class

<?
class db {

function db () {
$dbhost= "localhost"; //Plaats waar datebase staat 99% localhost
$dbuser= ""; //Username van datebase
$dbpass = ""; //Password van datebase
$dbnaam = ""; //Datebasenaam
if (!@mysql_select_db($dbnaam, @mysql_connect($dbhost, $dbuser, $dbpass))) {
$error = true;
exit();
}
}

function dbexec ($sql) {
$res = mysql_query($sql) or die(mysql_error());
return $res;
}

function dbselect ($fields, $table, $where, $order, $group, $limit) {
$sql = 'SELECT ';
if($fields) { $sql .= $fields; } else { $sql .= '*'; }
$sql .= ' FROM ';
$sql .= $table;

if($where) {
$sql .= ' WHERE ';
$sql .= $where;
}

if($order) {
$sql .= ' ORDER BY ';
$sql .= $order;
}

if($group) {
$sql .= ' GROUP BY ';
$sql .= $group;
}

if($limit) {
$sql .= ' LIMIT ';
$sql .= $limit;
}

$res = $this->dbexec($sql);
return $res;
}

}
?>

<?
class db {
 
function db () {
$dbhost= "localhost"; //Plaats waar datebase staat 99% localhost
$dbuser= ""; //Username van datebase
$dbpass = ""; //Password van datebase
$dbnaam = ""; //Datebasenaam
if (!@mysql_select_db($dbnaam, @mysql_connect($dbhost, $dbuser, $dbpass))) {
$error = true;
exit();
}
}
 
function dbexec ($sql) {
$res = mysql_query($sql) or die(mysql_error());
return $res;
}
 
function dbselect ($fields, $table, $where, $order, $group, $limit) {
$sql = 'SELECT ';
if($fields) { $sql .= $fields; } else { $sql .= '*'; }
$sql .= ' FROM ';
$sql .= $table;
 
if($where) {
$sql .= ' WHERE ';
$sql .= $where;
}
 
if($order) {
$sql .= ' ORDER BY ';
$sql .= $order;
}
 
if($group) {
$sql .= ' GROUP BY ';
$sql .= $group;
}
 
if($limit) {
$sql .= ' LIMIT ';
$sql .= $limit;
}
 
$res = $this->dbexec($sql);
return $res;
}
 
}
?>

<?
include_once 'include/ubb.inc.php';
$db = new db;

$list_query = $db->dbselect('field', 'table', 'where', 'order', 'group', 'limit');
$list = mysql_fetch_assoc($list_query);
?>

<?
include_once 'include/ubb.inc.php';
$db = new db;
 
$list_query = $db->dbselect('field', 'table', 'where', 'order', 'group', 'limit');
$list = mysql_fetch_assoc($list_query);
?>

<?
include_once 'include/ubb.inc.php';
$db = new db;

$list_query = $db->dbselect('id, name', 'leden', 'name="jan"', 'name DESC', '', '0,5');
$list = mysql_fetch_assoc($list_query);
?>

<?
include_once 'include/ubb.inc.php';
$db = new db;
 
$list_query = $db->dbselect('id, name', 'leden', 'name="jan"', 'name DESC', '', '0,5');
$list = mysql_fetch_assoc($list_query);
?>