_error("Please fill in a host!"));
} elseif(empty($database)) { // Empty Database
die($this->_error("Please fill in a database!"));
} else {
if(mysql_connect($host, $username, $password)) { // Connection DB
$this->connectie = "Geconnecteerd met ".$host; //
} else { // False
$this->connectie = "Connectie mislukt met ".$host;
die($this->_error(mysql_error()));
}
if(mysql_select_db($database)) { // Select DB
$this->connectie = "Geconnecteerd met ".$host;
} else { // False
$this->connectie = "Connectie mislukt met ".$host;
die($this->_error(mysql_error()));
}
}
$microtime_end = microtime_float(); // End Time
$microtime = $microtime_end - $microtime_start; // Time
$this->tijd += $microtime; // Total Time
}
//**Function Mysql_query**\\
function query($query) {
$microtime_start = microtime_float(); // Start Time
$this->querys ++; // Counter
return mysql_query($query); // Return Query
$microtime_end = microtime_float(); // End Time
$microtime = $microtime_end - $microtime_start; // Time
$this->tijd += $microtime; // Totel Time
}
//**Function Mysql_num_rows**\\
function num_rows($query) {
$microtime_start = microtime_float(); // Start Time
$this->numrows ++; // Counter
return mysql_num_rows($query); // Return Num Rows
$microtime_end = microtime_float(); // End Time
$microtime = $microtime_end - $microtime_start; // Time
$this->tijd += $microtime; // Total Time
}
//**Function Fetch_Assoc**\\
function fetch_assoc($query) {
$microtime_start = microtime_float(); // Start Time
return mysql_fetch_assoc($query); // Return Fatch_assoc
$microtime_end = microtime_float(); // End Time
$microtime = $microtime_end - $microtime_start; // Total Time
$this->tijd += $microtime; // Total Time
$this->assocs ++; // Counter
}
//**Function Fetch_Object**\\
function fetch_object($query) {
$microtime_start = microtime_float(); // Start Time
return mysql_fetch_object($query); // Return Fatch_assoc
$microtime_end = microtime_float(); // End Time
$microtime = $microtime_end - $microtime_start; // Total Time
$this->tijd += $microtime; // Total Time
$this->objects ++; // Counter
}
//**Function Fetch_Array**\\
function fetch_array($query) {
$microtime_start = microtime_float(); // Start Time
return mysql_fetch_array($query); // Return Fatch_assoc
$microtime_end = microtime_float(); // End Time
$microtime = $microtime_end - $microtime_start; // Total Time
$this->tijd += $microtime; // Total Time
$this->arrays ++; // Counter
}
//**Function Set Increment**\\
function setIncrement($veld, $tabel) {
$sql = mysql_query("SELECT ".$veld." FROM ".$tabel) or die(mysql_error());
while ($object = mysql_fetch_object($sql)) {
$array[] = $object->{$veld};
}
for ($i = 0; $i < count($array); $i++) {
mysql_query("UPDATE ".$tabel." SET ".$veld." = ".($i + 1)." WHERE ".$veld." = ".$array[$i]);
}
}
//**Function Error**\\
function _error ($error="") {
echo "Error: ".$error; // Echo: Var Error
}
// Acties: Logboek/Statistieken
function getInfo() {
$return = "Statistics:
";
$return .= "Connectie: ".$this->connectie."
";
$return .= "Count Querys: ".$this->querys."
";
$return .= "Count Fetch: ".($this->assocs + $this->arrays + $this->objects)."
";
$return .= "Count Fetch Assocs: ".$this->assocs."
";
$return .= "Count Fetch Arrays: ".$this->arrays."
";
$return .= "Count Fetch Objects: ".$this->objects."
";
$return .= "Count Num Rows: ".$this->numrows."
";
$return .= "Time: ".round($this->tijd,6);
return $return;
}
}
//*Gebruik*\\
$sql = new SQL();
$sql->connect("localhost", "user", "pass", "db");
$query = $sql->query("SELECT * BLA WHERE BLA='BLA'");
while($assoc = $sql->fetch_assoc($query)) {
echo $assoc['WOOT'];
}
?>