diff options
| author | clawoo <alin.claudiu.radut@gmail.com> | 2014-10-22 18:10:55 +0200 |
|---|---|---|
| committer | clawoo <alin.claudiu.radut@gmail.com> | 2014-10-22 18:10:55 +0200 |
| commit | 1db369f77a158d72fcb7fe44f84efcfe9ac2f0d7 (patch) | |
| tree | e5040e01c91218aa838fcc0fd04d2c2ec4c9861c | |
| parent | ff8bff16c9857540f47a9ed093c6c4fb7348e1ad (diff) | |
Reword change log and add the resulting query in the manual.
| -rw-r--r-- | user_guide_src/source/changelog.rst | 2 | ||||
| -rw-r--r-- | user_guide_src/source/database/queries.rst | 5 |
2 files changed, 5 insertions, 2 deletions
diff --git a/user_guide_src/source/changelog.rst b/user_guide_src/source/changelog.rst index adb8d88ce..99cdf4d4e 100644 --- a/user_guide_src/source/changelog.rst +++ b/user_guide_src/source/changelog.rst @@ -173,7 +173,7 @@ Release Date: Not Released - Added Interbase/Firebird database support via the *ibase* driver. - Added ODBC support for ``create_database()``, ``drop_database()`` and ``drop_table()`` in :doc:`Database Forge <database/forge>`. - Added **save_queries** configuration setting to *application/config/database.php* (defaults to ``TRUE``). - - Added support for escaping arrays sent as binding values to ``query()`` + - Added support to binding arrays as ``IN()`` sets in ``query()``. - :doc:`Query Builder <database/query_builder>` changes include: diff --git a/user_guide_src/source/database/queries.rst b/user_guide_src/source/database/queries.rst index b9152aac7..76ff1083f 100644 --- a/user_guide_src/source/database/queries.rst +++ b/user_guide_src/source/database/queries.rst @@ -132,11 +132,14 @@ put the queries together for you. Consider the following example:: The question marks in the query are automatically replaced with the values in the array in the second parameter of the query function. -Bindings also work with array values, useful for queries involving the IN operator:: +Binding also work with arrays, which will be transformed to IN sets:: $sql = "SELECT * FROM some_table WHERE id IN ? AND status = ? AND author = ?"; $this->db->query($sql, array(array(3, 6), 'live', 'Rick')); +The resulting query will be:: + + SELECT * FROM some_table WHERE id IN (3,6) AND status = 'live' AND author = 'Rick' The secondary benefit of using binds is that the values are automatically escaped, producing safer queries. You don't have to |