debug = $debug;
$this->db = mysqli_connect("localhost", "u_psistrihy", "ziyzHzT!DD79") or die ("Unable to connect DB!!");
mysqli_select_db($this->db, "db_psistrihy");
if ($this->debug)
echo ("Connected successfully to DB
\n");
// register_shutdown_function("close_db");
}
function close(){
$query = "unlock tables";
$this->query($query);
mysqli_close($this->db);
}
function query_i($query){
if ($this->db){
if ($result = mysqli_query($this->db, $query)){
if ($this->debug)
printf (" Success : %s
\n", $query);
return mysqli_insert_id($this->db);
}else{
printf (" Error : %s in %s
\n", mysqli_error($this->db), $query);
}
}
return false;
}
function query($query, $t = MYSQLI_ASSOC){
global $mysql_num_rows;
if ($this->db){
if ($result = mysqli_query($this->db, $query)){
if ($this->debug)
printf (" Success : %s
\n", $query);
$r = array();
$i = 0;
while($row = mysqli_fetch_array($result, $t)) $r[] = $row;
// while($row = mysql_fetch_array($result, MYSQL_BOTH))
// while($row = mysql_fetch_array($result, MYSQL_ASSOC))
$mysql_num_rows = mysqli_num_rows($result);
return $r;
}else{
printf (" Error : %s in %s
\n", mysqli_error($this->db), $query);
}
}
return false;
}
}
function close_db(){
if ($db)
$db->close();
}
$db = new db(0);
?>
Psí střihy Hanka
