note 90884 deleted from function.oci-bind-by-name by sixd

From: 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); // ... ?>

« previous php.notes (#162896) next »