Displaying an Image from MySQL with PHP

kchrisc

Hello,

Thanks in advance.

I have a small DB that has a BLOB field for a jpeg image.

I have tryed everything that I know and then some to get the images out and displayed.

Each time I get garbage.

Here is my test code:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">

<head>
	<meta http-equiv="content-type" content="text/html; charset=iso-8859-1" />
	<meta name="author" content="Connected Computer Services, Inc." />

<title>Untitled 2</title>
</head>

<body>
<?php  include("carinvdbconnect.php");
header("Content-type: image/jpeg");
 echo "Connected";

// Retrieve all the data from the "example" table
$result = mysqli_query($cxn, "SELECT * FROM carinvtbl");
// store the record of the "example" table into $row
$row = mysqli_fetch_array( $result );
// Print out the contents of the entry 
echo $row['price'];
echo $row['image'];


 ?>
</body>
</html>

Price will display--it's text--but not the image.

What do I need to do?

Thanks again.

bradgrafelman

You can't output binary data (in this case, an image) in the middle of an HTML document. Include an <img> element in the HTML document that points to a PHP script that does nothing but retrieve and output the binary image data.

EDIT: Also, welcome to PHPBuilder! When posting PHP code, please use the board's [noparse]

..

[/noparse] bbcode tags as they make your code much easier to read and analyze.