summaryrefslogtreecommitdiffstats
path: root/system/database
diff options
context:
space:
mode:
authorMancy <abdullah.mancy@gmail.com>2011-12-20 09:47:51 +0100
committerMancy <abdullah.mancy@gmail.com>2011-12-20 09:47:51 +0100
commitc4caf5a181344e48fc6740f1383dd302f5b604d2 (patch)
tree10f48ac5edef91f2b5284894c0ca2a3bfab72565 /system/database
parentd054e137917ef1131195679aa8abeb4dbf69e4e4 (diff)
taking care of LIKE when used in UPDATE statement #798
Diffstat (limited to 'system/database')
-rw-r--r--system/database/DB_active_rec.php2
-rw-r--r--system/database/drivers/mysql/mysql_driver.php11
2 files changed, 11 insertions, 2 deletions
diff --git a/system/database/DB_active_rec.php b/system/database/DB_active_rec.php
index 43920772a..7a608c4f0 100644
--- a/system/database/DB_active_rec.php
+++ b/system/database/DB_active_rec.php
@@ -1424,7 +1424,7 @@ class CI_DB_active_record extends CI_DB_driver {
$this->limit($limit);
}
- $sql = $this->_update($this->_protect_identifiers($this->ar_from[0], TRUE, NULL, FALSE), $this->ar_set, $this->ar_where, $this->ar_orderby, $this->ar_limit);
+ $sql = $this->_update($this->_protect_identifiers($this->ar_from[0], TRUE, NULL, FALSE), $this->ar_set, $this->ar_where, $this->ar_orderby, $this->ar_limit, , $this->ar_like);
$this->_reset_write();
return $this->query($sql);
diff --git a/system/database/drivers/mysql/mysql_driver.php b/system/database/drivers/mysql/mysql_driver.php
index 828ef006b..7952312ab 100644
--- a/system/database/drivers/mysql/mysql_driver.php
+++ b/system/database/drivers/mysql/mysql_driver.php
@@ -606,7 +606,7 @@ class CI_DB_mysql_driver extends CI_DB {
* @param array the limit clause
* @return string
*/
- function _update($table, $values, $where, $orderby = array(), $limit = FALSE)
+ function _update($table, $values, $where, $orderby = array(), $limit = FALSE, $like = array())
{
foreach ($values as $key => $val)
{
@@ -620,6 +620,15 @@ class CI_DB_mysql_driver extends CI_DB {
$sql = "UPDATE ".$table." SET ".implode(', ', $valstr);
$sql .= ($where != '' AND count($where) >=1) ? " WHERE ".implode(" ", $where) : '';
+
+ if (count($like) > 0) {
+ $sql .= ($where == '' AND count($where) <1) ? " WHERE " : ' AND ';
+ foreach ($like as $st_like) {
+
+ $sql .= " " . $st_like;
+
+ }
+ }
$sql .= $orderby.$limit;