php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

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 Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: m dot a dot ogarkov at gmail dot com
New email:
PHP Version: OS:

 

 [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

Pull Requests

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-2025 The PHP Group
All rights reserved. 		Last updated: Tue Feb 18 18:01:29 2025 UTC