Jump to content

(help) retrieving database information to print image on page


ra2833

Recommended Posts

well, i have made tremendous progress on this small project thanks to all of you who have helped.....

Information:
1. i am able to upload a file as binary data to a database
2. i am able to retrieve all relevent information from the database
2.a like the name i gave the file
2.b like the size of the file
2.c like the unique identifer of the file
2.d like the type of file

But, when i pull out the binary data from the database, i get stream of information on my screen instead of the image!!!!!!

can someone help me out here:



<?php
//same connection structure to database as previous post (above)

//$faq_unique_id_r = intval( $_GET['faq_unique_id_s'] );
$image_unique_id_r = 92;


mysql_select_db($database_faqSQLconn, $faqSQLconn);
$query = "SELECT * FROM faq_image WHERE faq_image.image_unique_id  = '".$image_unique_id_r."'";


$faq_image_result = mysql_query($query, $faqSQLconn) or die("Query failed: " . mysql_error() . " Actual query: " . $query);


?>
<!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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Untitled Document</title>
</head>

<body>


<?php
$row = mysql_fetch_array($faq_image_result);
echo $row['image_unique_id'];
echo $row['name'];
echo $row['file_type'];
echo $row['image'];          <----- this does not print image
?>
</body>

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.