Grouping WHERE clauses in Codeigniter

by

In Codeigniter 3.0.3 you can do it simple like this :

$this->db->select()
  ->from('users')
  ->where('name !=', 'Joe')
  ->group_start() // Open bracket
  ->where('age <', 69)
  ->or_where('id <', $id)
  ->group_end(); // Close bracket

Perhaps it can help

More Related Contents:

  1. How to select rows where column value IS NOT NULL using CodeIgniter’s ActiveRecord?
  2. Escaping SQL queries in Codeigniter
  3. how to select only one value sql
  4. How to create codeigniter dynamic menu from single table
  5. Comma separated numeric values – PHP CodeIgniter
  6. CodeIgniter – foreach loop
  7. PHP – Change value y,n in database [closed]
  8. How to insert multiple rows from array using CodeIgniter framework?
  9. strange character encoding of stored data , old script is showing them fine new one doesn’t
  10. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  11. Find total number of results in mySQL query with offset+limit
  12. How to create Codeigniter batch insert array
  13. How to add an ORDER BY clause using CodeIgniter’s Active Record methods?
  14. How can I Use Prepared Statements in CodeIgniter
  15. What are the differences between backtick and single quote? Can I use IF statement in a query as above?
  16. How to create Codeigniter language files from database?
  17. Trying to get property of non-object – CodeIgniter
  18. Codeigniter Transactions
  19. Inserting NOW() into Database with CodeIgniter’s Active Record
  20. mysqli or die, does it have to die?
  21. PHP file cannot enter some part of code
  22. Laravel: PDOException: could not find driver
  23. CodeIgniter htaccess and URL rewrite issues
  24. Doing a while / loop to get 10 random results
  25. php file upload, how to restrict file upload type
  26. CodeIgniter activerecord, retrieve last insert id?
  27. MySQL error when inserting data containing apostrophes (single quotes)?
  28. Using MySQL’s TIMESTAMP vs storing timestamps directly
  29. SQLSTATE[HY000] [1698] Access denied for user ‘root’@’localhost’
  30. Which MySQL datatype to use for an IP address? [duplicate]

Leave a Comment