I made a db class to take care of my querys, but when i try to use it, the page just doesn't show, it just keeps loading...🙁. What is wrong with my script?
<?
class DBLayer {
var $counter = 0;
function DBLayer($db_host,$db_username,$db_password,$db_name) {
$this->connect = @mysql_connect($db_host,$db_username,$db_password);
if($this->connect) {
if(@mysql_select_db($db_name,$this->connect)) {
return $this->connect;
} else {
die("<b>MySQL Error:</b> " . mysql_error() . "<br>");
}
} else {
die("<b>MySQL Error:</b> " . mysql_error() . "<br>");
}
}
function query($query) {
$this->result = mysql_query($query);
if(!$this->result) {
$this->error = mysql_error();
echo "<b>MySQL Error:</b> " . $this->error . "";
}
$detect1 = substr_count("$query", "DELETE");
$detect2 = substr_count("$query", "UPDATE");
$detect3 = substr_count("$query", "INSERT");
if($detect1 || $detect2 || $detect2) {
$this->affected_rows = mysql_affected_rows();
$this->affected_rows_total += $this->affected_rows;
}
$this->counter++;
return $this->result;
}
function fetch_array($query) {
$this->result = mysql_query($query);
$this->array = mysql_fetch_array($this->result);
$this->counter++;
return $this->array;
}
function result($query,$query2,$query3) {
$this->result = mysql_query($query);
$this->row = mysql_result($this->result,$query2,$query3);
$this->counter++;
return $this->row;
}
function num_rows($query) {
$this->result = mysql_query($query);
$this->num_rows = mysql_num_rows($this->result);
$this->counter++;
return $this->num_rows;
}
function count_queries() {
return $this->counter;
}
function affected_rows() {
if($this->affected_rows_total == "0") {
$this->affected_rows_total = "0";
}
return $this->affected_rows_total;
}
function close() {
register_shutdown_function("mysql_close");
}
}
?>