Changeset 542 for trunk/includes/Database.php

Timestamp:

Jun 17, 2013, 10:42:13 AM (12 years ago)

Author:

chronos

Message:

• Přidáno: Možnost zaznamenávat všechny SQL povely do souboru.

File:

• trunk/includes/Database.php (modified) (2 diffs)

trunk/includes/Database.php

@@ -28 +28 @@
 class Database
 {
-  var $Prefix = '';
-  var $Functions = array('NOW()', 'CURDATE()', 'CURTIME()', 'UUID()');
-  var $Type = 'mysql';  // mysql, pgsql
+  var $Prefix;
+  var $Functions;
+  var $Type;  
   var $PDO;
-  var $Error = '';
+  var $Error;
   var $insert_id;
-  var $LastQuery = '';
-  var $ShowSQLError = false;
-  var $ShowSQLQuery = false;
+  var $LastQuery;
+  var $ShowSQLError;
+  var $ShowSQLQuery;
+  var $LogFile;
   
   function __construct()
   {    
+        $this->Functions = array('NOW()', 'CURDATE()', 'CURTIME()', 'UUID()');
+        $this->Type = 'mysql'; // mysql, pgsql
+        $this->ShowSQLError = false;
+        $this->ShowSQLQuery = false;
+        $this->LogSQLQuery = false;
+        $this->LogFile = 'Query.log';
   }
   
@@ -60 +67 @@
     if($this->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>'."\n");
+    if($this->LogSQLQuery == true)
+      file_put_contents($this->LogFile, $Query."\n", FILE_APPEND);
     $Result = new DatabaseResult();
     $Result->PDOStatement = $this->PDO->query($Query);