function, because it is so important
for websites with heavy traffic. Oracle has a cache that can be re-used for quicker and more
efficient queries. If you bind a variable to your SQL query, you can make use of this great
feature. Here is a basic example of how this would work:
$my_bind = "VARIABLE"; /* hopefully you can get this value from an HTTP POST */
PutEnv("ORACLE_HOME=/path/to/ORACLE");
PutEnv("ORACLE_SID=YOUR_ORACLE_SID");
$dbh = ocilogon("username","password","SID");
$sql = "SELECT SOMETHING FROM TABLE WHERE SOME_ID = :media_id ";
$sth = ociparse($dbh,$sql);
ocibindbyname($sth,":some_id",&$my_bind,6);
ociexecute($sth,OCI_DEFAULT);
while (ocifetch($sth)) {
$my_output = ociresult($sth,1);
}
?>
By the way... I prefer to leave the '@' symbol off all of my functions. Supressing errors is not
necessarily a good thing. 8)