86 lines
No EOL
2.1 KiB
PHP
86 lines
No EOL
2.1 KiB
PHP
<?php
|
|
|
|
class mysql extends mysqli{
|
|
private $querys = 0;
|
|
|
|
function insert($sql){
|
|
$this->query($sql);
|
|
return $this->insert_id;
|
|
}
|
|
|
|
function query($sql){
|
|
$return = parent::query($sql);
|
|
if(!$return){
|
|
trigger_error("Message: ".$this->error." (".$sql.")", E_USER_ERROR);
|
|
}else{
|
|
$this->querys++;
|
|
}
|
|
return $return;
|
|
}
|
|
|
|
function query_single($sql){
|
|
$out = $this->query($sql);
|
|
$return = $out->fetch_assoc();
|
|
$return['num_rows'] = $out->num_rows;
|
|
return $return;
|
|
}
|
|
|
|
function query_array($sql){
|
|
$out_db = $this->query($sql);
|
|
while($tmp = $out_db->fetch_assoc()){
|
|
$out[] = $tmp;
|
|
}
|
|
return $out;
|
|
}
|
|
|
|
function clean($sql){
|
|
$sql = stripslashes($sql);
|
|
$sql = $this->real_escape_string($sql);
|
|
return $sql;
|
|
}
|
|
|
|
function anzahl_querys(){
|
|
return $this->querys;
|
|
}
|
|
|
|
function get_last_id(){
|
|
return $this->insert_id;
|
|
}
|
|
|
|
function sql_backup(){
|
|
$tables = $this->query("SHOW TABLES;");
|
|
$backup = "Sicherung Datenbank \n\n";
|
|
while($table = $tables->fetch_assoc()){
|
|
$backup .= "INSERT INTO ".$table['Tables_in_'.CONFIG_MYSQL_DB]." () VALUES ";
|
|
$daten = $this->query("SELECT * FROM ".$table['Tables_in_'.CONFIG_MYSQL_DB].";");
|
|
$count_2 = 0;
|
|
while($data = $daten->fetch_assoc()){
|
|
if($count_2 == 1){
|
|
$backup .= ",";
|
|
}
|
|
$backup .= "(";
|
|
$count = 0;
|
|
foreach($data as $dat){
|
|
if($count == 1){
|
|
$backup .= ",";
|
|
}
|
|
if($dat == ""){
|
|
$backup .= "''";
|
|
}else{
|
|
$backup .= "'".$dat."'";
|
|
}
|
|
$count = 1;
|
|
}
|
|
$backup .= ")";
|
|
$count_2 = 1;
|
|
}
|
|
$backup .= ";\n";
|
|
}
|
|
$x = fopen("tmp/dumpl.sql","w");
|
|
fwrite($x,$backup);
|
|
fclose($x);
|
|
|
|
|
|
}
|
|
}
|
|
?>
|