Codeigniter s where and or where

Question

I m trying to specify a query in my model   this- gt db         - gt select              - gt from  library           - gt where  library rating  gt      form  slider            - gt where  library votes  gt      1000           - gt where  library language       German           - gt where  library available until  gt     date  Y-m-d H i s            - gt or where  library available until      00-00-00 00 00 00           - gt where  library release year  gt      year start          - gt where  library release year  lt      year end          - gt join  rating repo    library id   rating repo id     So  the trouble i m having is with my or where  I want the or to be restricted to only the available until field  Currently  however  i m getting results which have a language of German which isn t what i want  How do i restrict my or where filter to the available until field only

User · Accepted Answer

You can modify just the two lines   - gt where   library available until  gt     date  Y-m-d H i s    FALSE  - gt or where  library available until    00-00-00 00 00 00     NULL  FALSE    EDIT   Omitting the FALSE parameter would have placed the backticks before the brackets and make them a part of the table name value  making the query unusable   The NULL parameter is there just because the function requires the second parameter to be a value  and since we don t have one  we send NULL

User · Answer

You may group your library available until wheres area by grouping method of Codeigniter for without disable escaping where clauses    this- gt db     - gt select          - gt from  library       - gt where  library rating  gt      form  slider        - gt where  library votes  gt      1000       - gt where  library language       German       - gt group start     this will start grouping     - gt where  library available until  gt     date  Y-m-d H i s        - gt or where  library available until      00-00-00 00 00 00       - gt group end     this will end grouping     - gt where  library release year  gt      year start      - gt where  library release year  lt      year end      - gt join  rating repo    library id   rating repo id     Reference  https   www codeigniter com userguide3 database query builder html query-grouping

User · Answer

this- gt db- gt where   a   1 or a   2

User · Answer

You can use   Query grouping allows you to create groups of WHERE clauses by enclosing them in parentheses  This will allow you to create queries with complex WHERE clauses  Nested groups are supported  Example    this- gt db- gt select     - gt from  my table           - gt group start                   - gt where  a    a                   - gt or group start                           - gt where  b    b                           - gt where  c    c                   - gt group end           - gt group end           - gt where  d    d   - gt get      https   www codeigniter com userguide3 database query builder html query-grouping

User · Answer

You can change your code to this    where au     library available until  gt     date  Y-m-d H i s    OR library available until    00-00-00 00 00 00      this- gt db     - gt select          - gt from  library       - gt where  library rating  gt      form  slider        - gt where  library votes  gt      1000       - gt where  library language       German       - gt where  where au      - gt where  library release year  gt      year start      - gt where  library release year  lt      year end      - gt join  rating repo    library id   rating repo id      Tip  to watch the generated query you can use   echo  this- gt db- gt last query    die

[php] Codeigniter's `where` and `or_where`

Examples related to php

Examples related to mysql

Examples related to codeigniter

Examples related to activerecord