From 80dd702d4c46552a3d1f94c5083c83eeff333b45 Mon Sep 17 00:00:00 2001 From: Derek Allard Date: Tue, 18 Dec 2007 23:55:06 +0000 Subject: Added where_in() to Active Record. --- user_guide/database/active_record.html | 26 +++++++++++++++++++++++--- 1 file changed, 23 insertions(+), 3 deletions(-) (limited to 'user_guide/database') diff --git a/user_guide/database/active_record.html b/user_guide/database/active_record.html index 739d56a15..aafef33b5 100644 --- a/user_guide/database/active_record.html +++ b/user_guide/database/active_record.html @@ -263,11 +263,31 @@ $this->db->where('name !=', $name);
$this->db->or_where('id >', $id);

// Produces: WHERE name != 'Joe' OR id > 50 - - -

Note: or_where() was formerly known as orwhere(), which has been deprecated.

+ + +

$this->db->where_in();

+

This function is used to write WHERE clauses that contain the IN keyword.

+ +

+ $names = array('frank', 'Todd', 'James');
+ $this->db->where_in('username', $names);
+ // Produces: AND WHERE username IN ('frank', 'Todd', 'James')

+

An optional third parameter can be used to specify if the WHERE statement should be separated with "OR" or "AND" in the event of multiple WHERE calls. The default is "AND".

+

$names = array('frank', 'Todd', 'James');
+
+ $this->db->where('usergroup', '5')
+$this->db->where_in('username', $names);
+// Produces: WHERE usergroup = '5' AND WHERE username IN ('frank', 'Todd', 'James')
+
+$this->db->where('usergroup', '5')
+$this->db->where_in('username', $names, 'and');
+// Produces: WHERE usergroup = '5' AND WHERE username IN ('frank', 'Todd', 'James')
+
+$this->db->where('usergroup', '5')
+$this->db->where_in('username', $names, 'or');
+// Produces: WHERE usergroup = '5' OR WHERE username IN ('frank', 'Todd', 'James')

$this->db->like();

This function enables you to generate LIKE clauses, useful for doing searches.

-- cgit v1.2.3-24-g4f1b