Image + Database + Html + HELP
| From: | Serkan AKCIN | Date: | Thu, 31 Aug 2000 12:38:17 +0000 |
| Subject: | Image + Database + Html + HELP | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-2521@lists.php.net to get a copy of this message | ||
We store JPG files in a LONG RAW column of Oracle.
Above code query the jpg table. But How can I show it on the browser?
I need help! help! help!
Ex:
<html>
<head><title>Image&Database&HTML</title></head>
<body>
<?php
$conn= OCIPLogon("user","pass","host");
$sql = "select jpgimage from tbljpg where jpgid=1";
$stmt = OCIParse($conn,$sql);
if (!OCIExecute($stmt)) { print "execution failed"; exit(); }
OCIFetchInto($stmt, &$arr,OCI_RETURN_LOBS);
$arr["JPGIMAGE"]->load();
?>
<!-- <img src="??????????.???"> How can display the below jpg field data?-->
</body>
</html>
P.S.: The below code gives an error like...
Fatal Error: Call to a member function on a non-object in jpg.php line XX.