How to diplay images from memory.

sonny-bob

I am using ODBC with PHP5 and SQL Server 2000, on Windows 2003.
I have just retrieved an image field with the following php expression:
...
...
$photo = odbc_result($stmt,"Photo");
...
...

where:
$photo contains the bytes for the image.
What php expression should I use, to display the picture on a web page?

I tried using echo "<td>$photo</td>";
but this only diplays the raw bytes.

Thanks.

😕

bpat1434

You'll probably have to create a temp PHP file, set the header to the image type, and then call the file.

THis tutorial is based on mySQL, but it should help you.
http://www.onlamp.com/pub/a/php/2000/09/15/php_mysql.html?page=1

~Brett

sonny-bob

Originally posted by bpat1434
You'll probably have to create a temp PHP file, set the header to the image type, and then call the file.

THis tutorial is based on mySQL, but it should help you.
http://www.onlamp.com/pub/a/php/2000/09/15/php_mysql.html?page=1

~Brett

I just want to know if you can read image data from a database table and display it on a web page directly from memory. If so, how. I ma new to PHP, and the example you refer me to, is confusing.

Thanks.

😕

bpat1434

If you're inserting an image into the database directly (not storing the image path, but the image itself), then you have to create an intermittent file which will display the image.

Display image from MS ODBC BLOB column, using ASP Pages

PHP Builder: How to Store Images Directly in the Sql Database

Those work. But basically all you do is send the Content-Type: header, and print the image information:

<?php
// Database connect & retrieve info

header("Content-type: image/jpg");
print($image_info_pulled_from_db);
?>

Then, to link to that db, you call the script from the <img> tag.

<img src="somescript.php?pid=XX">

Hope that helps.

~Brett