Changeset 3 for database.php

Timestamp:

Oct 13, 2007, 5:41:26 PM (17 years ago)

Author:

george

Message:

Přepracováno: Nově použití objektové třídy mysqli pro přístup k mysql databázi.

File:

• database.php (modified) (4 diffs)

database.php

@@ -10 +10 @@
   function select($Table, $What = '*', $Condition = 1)
   {
-    return($this->query("SELECT ".$What." FROM ".$this->Prefix.$Table." WHERE ".$Condition));  
+    $Query = "SELECT ".$What." FROM `".$this->Prefix.$Table."` WHERE ".$Condition;
+    return($this->query($Query));  
   }
 
   function delete($Table, $Condition)
   {
-    $this->query("DELETE FROM ".$this->Prefix.$Table." WHERE ".$Condition);  
+    $this->query("DELETE FROM `".$this->Prefix.$Table."` WHERE ".$Condition);  
   }
   
@@ -31 +32 @@
     $Name = substr($Name, 1);
     $Values = substr($Values, 1);
-    $this->query('INSERT INTO '.$this->Prefix.$Table-' ('.$Name.') VALUES('.$Values.')');  
+    $this->query('INSERT INTO `'.$this->Prefix.$Table.'` ('.$Name.') VALUES('.$Values.')');  
+    //echo('INSERT INTO `'.$this->Prefix.$Table.'` ('.$Name.') VALUES('.$Values.')');
   }
   
   function update($Table, $Condition, $Data)
   {
+    $Values = '';
     foreach($Data as $Key => $Value)
     {
@@ -43 +46 @@
     }
     $Values = substr($Values, 2);  
-    $this->query('UPDATE '.$this->Prefix.$Table.' SET '.$Values.' WHERE ('.$Condition.')');
+    $this->query('UPDATE `'.$this->Prefix.$Table.'` SET '.$Values.' WHERE ('.$Condition.')');
   }
   
@@ -59 +62 @@
     $Name = substr($Name, 1);
     $Values = substr($Values, 1);
-    $this->query('REPLACE INTO '.$this->Prefix.$Table.' ('.$Name.') VALUES('.$values.')');
+    $this->query('REPLACE INTO `'.$this->Prefix.$Table.'` (`'.$Name.'`) VALUES('.$values.')');
   }