Age | Commit message (Collapse) | Author | |
---|---|---|---|
2014-05-18 | where_id_in() for selecting multiple records by primary key | Luis Ramón López | |
2014-05-18 | Multiple OR'ed conditions support | Luis Ramón López | |
Multiple OR'ed conditions ------------------------- You can add simple ORed conditions to the same WHERE clause using ``where_any_is``. You should specify multiple conditions using an array of items. Each item will be an associative array that contains a multiple conditions. ```php <?php $people = ORM::for_table('person') ->where_any_is(array( array('name' => 'Joe', 'age' => 10), array('name' => 'Fred', 'age' => 20))) ->find_many(); // Creates SQL: SELECT * FROM `widget` WHERE (( `name` = 'Joe' AND `age` = '10' ) OR ( `name` = 'Fred' AND `age` = '20' )); ``` By default, it uses the equal operator for every column, but it can be overriden for any column using a second parameter: ```php <?php $people = ORM::for_table('person') ->where_any_is(array( array('name' => 'Joe', 'age' => 10), array('name' => 'Fred', 'age' => 20)), array('age' => '>')) ->find_many(); // Creates SQL: SELECT * FROM `widget` WHERE (( `name` = 'Joe' AND `age` > '10' ) OR ( `name` = 'Fred' AND `age` > '20' )); ``` If you want to set the default operator for all the columns, just pass it as the second parameter: ```php <?php $people = ORM::for_table('person') ->where_any_is(array( array('score' => '5', 'age' => 10), array('score' => '15', 'age' => 20)), '>') ->find_many(); // Creates SQL: SELECT * FROM `widget` WHERE (( `score` > '5' AND `age` > '10' ) OR ( `score` > '15' AND `age` > '20' )); ``` | |||
2014-04-26 | Docs on raw_join implementation | Igor Moiseev | |
2014-04-26 | Document the new compound primary keys behaviour and features | Luis Ramón López | |
2014-04-26 | Note about precedence | Thomas Dybdahl Ahle | |
2014-04-20 | Update the docs to reflect logger changes@ | Simon Holywell | |
2014-01-21 | Remove Durham and increment copyright year | Simon Holywell | |
2013-09-02 | Merge branch 'patch-1' of https://github.com/fridde/idiorm into develop | Simon Holywell | |
2013-09-01 | Minor confusion | fridde | |
2013-08-28 | Add MS SQL `TOP` style syntax support | Simon Holywell | |
2013-08-28 | Test and document the query logger callback | Simon Holywell | |
2013-08-28 | Document and test PSR-1 compliant method access | Simon Holywell | |
2013-08-16 | Add static method `get_config` | Mike Estes | |
2013-04-02 | docs: querying: minor typo | Benjamin Ruston | |
2013-02-28 | Prepend PHP tag in docs | Simon Holywell | |
2013-02-28 | Merge branch 'master' of https://github.com/j4mie/idiorm | Simon Holywell | |
2013-02-28 | Attempt to get syntax highlighting working | Simon Holywell | |
2013-02-28 | Document array config to use connection_string | Simon Holywell | |
2013-02-20 | Remove version numbers and bump year | Simon Holywell | |
2013-02-20 | Fix typo in select_many() example | sjparsons | |
2013-01-24 | Multi-connections: Code style and docs | Simon Holywell | |
2013-01-22 | Apparently not all files were included in previous commit. | Tom Gregory | |
2013-01-22 | Merge remote-tracking branch 'upstream/develop' into dev-multi. Updated ↵ | Tom Gregory | |
documentation to rat format, and tests to use phpunit. (Resolved)Conflicts: README.markdown idiorm.php test/test_queries.php | |||
2013-01-15 | Add ResultSet functionality to Idiorm | Simon Holywell | |
2013-01-04 | Add HAVING clause support to query builder | Simon Holywell | |
2013-01-03 | Remove additional semicolon from set_expr() | Simon Holywell | |
2013-01-03 | Add access to PDOStatement via get_last_statement | tag | |
2013-01-03 | Issue #81 Move documentation out of one massive readme file | Simon Holywell | |
2012-12-14 | Move config, installation & philosophy into Sphinx | Simon Holywell | |
2012-11-28 | Begin sphinx based documentation | Simon Holywell | |