[PHP-DB] R: [PHP-DB] Image + Database + Html + HELP From: Roberto Sartor (roberto <email protected>)
Date: 08/31/00

try header ("Content-Type: image/jpg"),
and then print what is in your long raw field.

P.S.: I see you use OCIPLogon, OCI Permanent Logon: how do you pass Logon
between pages?
Do you pass variable $conn?

Ciao
Roberto

> -----Messaggio originale-----
> Da: Serkan AKCIN [mailto:serkan <email protected>]
> Inviato: giovedì 31 agosto 2000 14.38
> A: php-db <email protected>
> Oggetto: [PHP-DB] Image + Database + Html + HELP
>
>
> 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.
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-db-unsubscribe <email protected>
> For additional commands, e-mail: php-db-help <email protected>
> To contact the list administrators, e-mail:
> php-list-admin <email protected>
> 

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-db-unsubscribe <email protected>
For additional commands, e-mail: php-db-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>