Changeset 13 for database.php

Timestamp:

Oct 13, 2008, 1:56:05 PM (16 years ago)

Author:

george

Message:

• Přidáno: Automatické zaznamenávání historie operací nad seznamy do tabulky SystemLog.
• Upraveno: Nová třída pro databázovou obsluhu seznamů oddělená od souboru obstarávajícího komunikaci pomocí webu.
• Opraveno: Chybná podmínka zobrazování skrytých políček formulářů.
• Přidáno: Zobrazování chyb databázových povelů.

File:

• database.php (modified) (5 diffs)

database.php

@@ -2 +2 @@
 
 // Extended database class
-// Date: 2007-07-19
+// Date: 2008-10-13
 
 class Database extends mysqli
@@ -8 +8 @@
   var $Prefix = '';
   var $LastQuery = '';
-  
+  var $ShowError = 0;
+
   function query($Query)
   {
     $this->LastQuery = $Query;
-    return(parent::query($Query));
+    $DbResult = parent::query($Query);
+    if(($this->ShowError == TRUE) and ($this->error != ''))
+    {
+      echo('<strong>Database error:</strong> '.$this->error.'<br /><strong>Query:</strong> '.$Query.'<br />');
+      //echo('<pre>'); print_r(debug_backtrace()); echo('</pre>');
+    }
+    return($DbResult);
   }
 
   function select($Table, $What = '*', $Condition = 1)
   {
-    $this->LastQuery = "SELECT ".$What." FROM `".$this->Prefix.$Table."` WHERE ".$Condition; 
-    return($this->query($this->LastQuery));
+    return($this->query("SELECT ".$What." FROM `".$this->Prefix.$Table."` WHERE ".$Condition));
   }
 
   function delete($Table, $Condition)
   {
-    $this->LastQuery = "DELETE FROM `".$this->Prefix.$Table."` WHERE ".$Condition;
-    $this->query($this->LastQuery);
+    $this->query("DELETE FROM `".$this->Prefix.$Table."` WHERE ".$Condition);
   }
-  
+
   function insert($Table, $Data)
   {
@@ -35 +40 @@
       $Value = strtr($Value, '"', '\"');
       $Name .= ',`'.$Key.'`';
-            if($Value == 'NOW()') $Values .= ",".$Value;
-              else $Values .= ",'".$Value."'";
+      if($Value == 'NOW()') $Values .= ",".$Value;
+        else $Values .= ",'".$Value."'";
     }
     $Name = substr($Name, 1);
     $Values = substr($Values, 1);
-    $this->LastQuery = 'INSERT INTO `'.$this->Prefix.$Table.'` ('.$Name.') VALUES('.$Values.')';
-    $this->query($this->LastQuery);
+    $this->query('INSERT INTO `'.$this->Prefix.$Table.'` ('.$Name.') VALUES('.$Values.')');
   }
-  
+
   function update($Table, $Condition, $Data)
   {
@@ -49 +53 @@
     foreach($Data as $Key => $Value)
     {
-            $Value = strtr($Value, '"', '\"');
+      $Value = strtr($Value, '"', '\"');
       if($Value != 'NOW()') $Value = "'".$Value."'";
       $Values .= ", ".$Key."=".$Value;
     }
-    $Values = substr($Values, 2);  
-    $this->LastQuery = 'UPDATE `'.$this->Prefix.$Table.'` SET '.$Values.' WHERE ('.$Condition.')';
-    $this->query($this->LastQuery);
+    $Values = substr($Values, 2);
+    $this->query('UPDATE `'.$this->Prefix.$Table.'` SET '.$Values.' WHERE ('.$Condition.')');
   }
-  
+
   function replace($Table, $Data)
   {
@@ -72 +75 @@
     $Values = substr($Values, 1);
     //echo('REPLACE INTO `'.$this->Prefix.$Table.'` ('.$Name.') VALUES ('.$Values.')<br>');
-    $this->LastQuery = 'REPLACE INTO `'.$this->Prefix.$Table.'` ('.$Name.') VALUES('.$Values.')';
-    $this->query($this->LastQuery);
-    //echo($this->error().'<br>');
+    $this->query('REPLACE INTO `'.$this->Prefix.$Table.'` ('.$Name.') VALUES('.$Values.')');
   }
-  
+
   function charset($Charset)
   {
-    $this->LastQuery = 'SET CHARACTER SET '.$Charset;
-    $this->query($this->LastQuery);
+    $this->query('SET CHARACTER SET '.$Charset);
   }