From ff8bff16c9857540f47a9ed093c6c4fb7348e1ad Mon Sep 17 00:00:00 2001 From: clawoo Date: Tue, 21 Oct 2014 10:41:02 +0300 Subject: Update the change log and the documentation with the array values binding feature. --- user_guide_src/source/database/queries.rst | 6 ++++++ 1 file changed, 6 insertions(+) (limited to 'user_guide_src/source/database/queries.rst') 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 -- cgit v1.2.3-24-g4f1b