diff options
author | Filipp Lepalaan <filipp@mekanisti.fi> | 2009-11-09 14:24:41 +0200 |
---|---|---|
committer | Filipp Lepalaan <filipp@mekanisti.fi> | 2009-11-09 14:24:41 +0200 |
commit | 7034b50d0d50612ca52273aacabd2b3189c968d8 (patch) | |
tree | 85442aae9f9a1e124c262f1c33242a2b58433db6 | |
parent | 71eebcefb57763451d3cc2749d2ed9e181887157 (diff) | |
download | main-7034b50d0d50612ca52273aacabd2b3189c968d8.tar.gz main-7034b50d0d50612ca52273aacabd2b3189c968d8.tar.bz2 main-7034b50d0d50612ca52273aacabd2b3189c968d8.zip |
Limit on controller->delete
-rw-r--r-- | Controller.php | 8 |
1 files changed, 6 insertions, 2 deletions
diff --git a/Controller.php b/Controller.php index 5432673..458d3a3 100644 --- a/Controller.php +++ b/Controller.php @@ -254,7 +254,7 @@ class Controller /** * Delete this thing */ - protected function delete($where) + protected function delete($where, $limit = "") { if (empty($where)) { return App::error("Delete without arguments"); @@ -262,8 +262,12 @@ class Controller list($key, $value) = each($where); + if ($limit) { + $limit = " LIMIT $limit"; + } + $data = array(":{$key}" => $value); - $sql = "DELETE FROM `{$this->table}` WHERE `{$key}` = :{$key}"; + $sql = "DELETE FROM `{$this->table}` WHERE `{$key}` = :{$key} $limit"; return Db::query($sql, $data); |