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/changelog.html | 1 + user_guide/database/active_record.html | 26 +++++++++++++++++++++++--- 2 files changed, 24 insertions(+), 3 deletions(-) (limited to 'user_guide') diff --git a/user_guide/changelog.html b/user_guide/changelog.html index 612c4db62..8853969c4 100644 --- a/user_guide/changelog.html +++ b/user_guide/changelog.html @@ -68,6 +68,7 @@ Change Log
  • Javascript Calendar plugin now uses the months and days from the calendar language file, instead of hard-coded values, internationalizing it.
  • Removed "rand()" as a listed option from orderby in the Active Record, as it was MySQL only.
  • Added 'random' as an order_by() option in Active Record.
    • +
  • Added where_in() to Active Record.
  • Added titles to all user manual pages.
  • Added a check for NULL fields in the MySQL database backup utility.
  • Documented the timezones() function in the Date Helper.
    • 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