note 90884 deleted from function.oci-bind-by-name by sixd
| From: | sixd@php.net | Date: | Sat, 14 Nov 2009 01:00:20 +0000 |
| Subject: | note 90884 deleted from function.oci-bind-by-name by sixd | ||
| References: | 1 | Groups: | php.notes |
| Request: | Send a blank email to php-notes+get-162896@lists.php.net to get a copy of this message | ||
Note Submitter: dawid some sign krysiak dotty net dot pl
----
It looks like you don't have to put colon (':') in the beginning of the placeholder
name in the second parameter of ocibindbyname(). Of course colon is still needed in sql content.
The following example works just fine under php 4.4.7:
<?php
$sql = "SELECT * FROM schema.table WHERE id = :id";
$stmt = ociparse($conn, $sql);
ocibindbyname($stmt, 'id', $id, -1); // <-- note 'id' as a 2nd param -
without ':' in the beggining!!!
ociexecute($stmt,OCI_DEFAULT);
// ...
?>