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 Add Comment Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If this is not your bug, you can add a comment by following this link.
If this is your bug, but 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

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: Sat May 18 23:01:31 2024 UTC