note 1672 deleted from OCIParse by ronabop
| From: | ronabop@php.net | Date: | Sun, 27 Aug 2000 11:53:25 +0000 |
| Subject: | note 1672 deleted from OCIParse by ronabop | ||
| Groups: | php.notes | ||
| Request: | Send a blank email to php-notes+get-3492@lists.php.net to get a copy of this message | ||
Anybody know of a way to pass in parameters to your sql statement, and then parse the statement with
it expecting the parameters. This ability will give a big boost on the oracle side if it can be
done. In perl (DBI interface to Ora) you just put a '?' where the value will be, and the
execute statement holds params.
<p>
example: <br>
(from memory, so flame somebody else)
<pre>
-----------8<------------------
$sql = "select blah from blip where blah = ? and blah2 = ?";
$st = $db->prepare($sql);
$st->execute($val1, $val2)
<pre>
-----------8<------------------
i hope php does this. i would much rather use it to talk the Oracle database than perl. (not that
perl is bad. again, no flames please.)
please email me if anybody knows how to do this. not sure if this is even the place for this.