$values[] = ':' . $k;
}
- $sql = sprintf("INSERT INTO %s (%s)\n VALUES (%s)",
+ $sql = sprintf("INSERT INTO %s (%s) VALUES (%s)",
$table,
implode(',', $columns),
implode(',', $values));
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);
+ }
+
}
?>