Add delete methods

diff --git a/class/database.class.php b/class/database.class.php
index ac55d08..7b9a88e 100644 (file)
--- a/class/database.class.php
+++ b/class/database.class.php
@@ -196,7 +196,7 @@ class Database {
       $values[] = ':' . $k;
     }
 
-    $sql = sprintf("INSERT INTO %s (%s)\n    VALUES (%s)",
+    $sql = sprintf("INSERT INTO %s (%s) VALUES (%s)",
                   $table,
                   implode(',', $columns),
                   implode(',', $values));
@@ -212,13 +212,20 @@ class Database {
     foreach ($data as $k => $v)
       $set[] = $k.'=:'.$k;
 
-    $sql = sprintf("UPDATE %s SET %s\n    WHERE %s",
+    $sql = sprintf("UPDATE %s SET %s WHERE %s",
                   $table,
                   implode(',', $set),
                   $condition);
     return $this->executeBind($sql, $data);
   }
 
+  public function delete($table, $idcolumn, $id)
+  {
+    $sql = sprintf("DELETE FROM %s WHERE %s = %d",
+                  $table, $idcolumn, $id);
+    return $this->execute($sql);
+  }
+
 }
 
 ?>

diff --git a/class/databasetable.class.php b/class/databasetable.class.php
index d640bfd..d4eb7c0 100644 (file)
--- a/class/databasetable.class.php
+++ b/class/databasetable.class.php
@@ -76,6 +76,11 @@ abstract class DatabaseTable {
       return false;
   }
 
+  public function delete($id=false)
+  {
+    $this->db->delete($this->table, $this->idcolumn, $id === false ? $this->id : $id);
+  }
+
 }
 
 ?>
\ No newline at end of file