Changeset 153 for www/database.php

Timestamp:

Feb 16, 2009, 6:16:00 PM (15 years ago)

Author:

george

Message:

• Přidáno: Zobrazování chyb v SQL povelech. Nastavení v konfigureaci.
• Upraveno: Zpřístupnění stavu financí dle ip i dle přihlášení.

File:

• www/database.php (modified) (5 diffs)

www/database.php

@@ -2 +2 @@
 
 // Extended database class
-// Date: 2007-07-19
+// Date: 2009-02-16
 
 class Database extends mysqli
 {
   var $Prefix = '';
-  var $LastQuery = '';
   
   function query($Query)
   {
-    $this->LastQuery = $Query; 
-    return(parent::query($Query));  
+        global $Config;
+        
+        if($Config['Web']['ShowSQLQuery'] == true) 
+          echo('<div style="border-bottom-width: 1px; border-bottom-style: solid; padding-bottom: 3px; padding-top: 3px; font-size: 12px; font-family: Arial;">'.$Query.'</div>');
+        $Result = parent::query($Query);
+    if(($this->error != '') and ($Config['Web']['ShowSQLError'] == true)) 
+          echo('<div><strong>SQL Error: </strong>'.$this->error.'<br>'.$Query.'</div>');
+
+    return($Result);  
   }
 
   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);  
   }
   
@@ -41 +45 @@
     $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.')'); 
   }
   
@@ -55 +58 @@
     }
     $Values = substr($Values, 2);  
-    $this->LastQuery = 'UPDATE `'.$this->Prefix.$Table.'` SET '.$Values.' WHERE ('.$Condition.')';
-    $this->query($this->LastQuery);
+    $this->query('UPDATE `'.$this->Prefix.$Table.'` SET '.$Values.' WHERE ('.$Condition.')');
   }
   
@@ -73 +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);
+    $this->query('REPLACE INTO `'.$this->Prefix.$Table.'` ('.$Name.') VALUES('.$Values.')');
     //echo($this->error().'<br>');
   }
@@ -80 +81 @@
   function charset($Charset)
   {
-    $this->LastQuery = "SET NAMES '".$Charset."'";
-    $this->query($this->LastQuery);
+    $this->query('SET NAMES "'.$Charset.'"');
   }