Changeset 2060

Timestamp:

02/15/2008 10:33:49 AM (11 months ago)

Author:

zombor

Message:

Adding NOT IN support too.

Files:

• trunk/system/libraries/Database.php (modified) (2 diffs)

trunk/system/libraries/Database.php

@@ -789 +789 @@
 
         /**
-         * Adds an "in" condition to the where clause
+         * Adds an "IN" condition to the where clause
          * 
          * @param   string  Name of the column being examined
          * @param   mixed   An array or string to match against
+         * @param   bool    Generate a NOT IN clause instead
          * @return  object  This Database object.
          */
-        public function in($field, $values) 
+        public function in($field, $values, $not = FALSE) 
         {
                 if (is_array($values))
@@ -813 +814 @@
                         $values = implode(",", $escaped_values);
                 }
-                $this->where($this->driver->escape_column($field).' IN('.$values.')');
-                
-                return $this;
+                $this->where($this->driver->escape_column($field).' '.(!$not) ? 'NOT ' : ''.'IN ('.$values.')');
+
+                return $this;
+        }
+
+        /**
+         * Adds a "NOT IN" condition to the where clause
+         * 
+         * @param   string  Name of the column being examined
+         * @param   mixed   An array or string to match against
+         * @return  object  This Database object.
+         */
+        public function notin($field, $values) 
+        {
+                return $this->in($field, $values, TRUE);
         }