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! If you don't have a Git account, you can't do anything here.
If you reported this bug, you can edit this bug over here.
(description)
Block user comment
Status: Assign to:
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-2024 The PHP Group
All rights reserved. 		Last updated: Thu Dec 26 15:01:32 2024 UTC