summaryrefslogtreecommitdiffstats
path: root/user_guide_src/source/database
diff options
context:
space:
mode:
authorclawoo <alin.claudiu.radut@gmail.com>2014-10-21 09:41:02 +0200
committerclawoo <alin.claudiu.radut@gmail.com>2014-10-21 09:41:02 +0200
commitff8bff16c9857540f47a9ed093c6c4fb7348e1ad (patch)
treeed42dbc2896f5754bae38e20e313aa66f3748a8e /user_guide_src/source/database
parent4a4f5509832412aff3a6fb571d8be2454733e98b (diff)
Update the change log and the documentation with the array values binding feature.
Diffstat (limited to 'user_guide_src/source/database')
-rw-r--r--user_guide_src/source/database/queries.rst6
1 files changed, 6 insertions, 0 deletions
diff --git a/user_guide_src/source/database/queries.rst b/user_guide_src/source/database/queries.rst
index 90f49afb1..b9152aac7 100644
--- a/user_guide_src/source/database/queries.rst
+++ b/user_guide_src/source/database/queries.rst
@@ -132,6 +132,12 @@ 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::
+
+ $sql = "SELECT * FROM some_table WHERE id IN ? AND status = ? AND author = ?";
+ $this->db->query($sql, array(array(3, 6), 'live', 'Rick'));
+
+
The secondary benefit of using binds is that the values are
automatically escaped, producing safer queries. You don't have to
remember to manually escape data; the engine does it automatically for