php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Request #65980 Allow «IN» statement binding
Submitted: 2013-10-28 05:27 UTC Modified: 2014-08-14 16:02 UTC
From: m dot a dot ogarkov at gmail dot com Assigned:
Status: Not a bug Package: OCI8 related
PHP Version: 5.5.5 OS: all supported
Private report: No CVE-ID: None
View Add Comment Developer Edit
Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know!
Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem:
49 - 32 = ?
Subscribe to this entry?

 
 [2013-10-28 05:27 UTC] m dot a dot ogarkov at gmail dot com
Description:
------------
When dealing with «IN» clause within sql statements it will be convinient to be able to bind php array to expression within brackets in such way:

SELECT ID
FROM TABLE
WHERE ID IN (:host_variable);

$ids = [1,2,3,5,6];
oci_bind_by_name($statement, ":host_variable", $ids);






Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2014-08-14 16:02 UTC] sixd@php.net
-Status: Open +Status: Not a bug
 [2014-08-14 16:02 UTC] sixd@php.net
This is an Oracle limitation, not an OCI8 problem.  Changing it would require Oracle to parse the bound data to identify the delimiters.  This is extremely unlikely to happen.  If you want to pursue it, please log a request with Oracle Corp.
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sun May 19 00:01:33 2024 UTC