Image Displaying

NICKKKKK

Hello,

I have a problem as i cannot view the images saved on the database table.

I can view the last one inserted but not all of them.

<?php
$id = $_REQUEST['id'];

MYSQL_CONNECT("localhost","root","pass");
mysql_select_db("test");

$query = "select id, description, bin_data,filetype from binary_data";
$result = MYSQL_QUERY($query);
for($i=0; $i < 10; $i++)
{
echo $data = MYSQL_RESULT($result,$i,"bin_data")."<br>";
}
/$type = MYSQL_RESULT($result,0,"filetype");
$desc = MYSQL_RESULT($result,0,"description");/

Header( "Content-type: $type");
Header( "Content-type: $desc");
Header( "Content-type: image/pjpeg");

//echo $data;

The for loop should display all the images stored on the table. I have also tried with mysql_num_rows but still nothing.

any ideas?

bradgrafelman

NICKKKKK wrote:
The for loop should display all the images stored on the table.

No it shouldn't.

First of all, it wouldn't work because you're simply overwriting the contents of $data after each iteration of the loop.

Second of all, you can't simply cram all of the binary image data together and expect it to make sense. If you want to display all images, loop through the DB and echo out HTML IMG elements that pass the ID of the current image onto a script (such as this one) that retrieves the binary data for that image only.

EDIT: Also, when posting PHP code, please use the board's [PHP][/PHP] bbcode tags - they make the code much, much easier to read (as well as aiding the diagnosis of syntax errors). You should edit your post now and add these bbcode tags to help others in reading/analyzing your code.

Maggan

Having a little hard time seeing what's what from your code, or why you're calling $id then... later looking it up again. If I read correctly, filename, the imagename is stored in field bin_data?

If so the following might work out. Just change the echo statement and style it up the way you'd like it.

<?php

mysql_connect("localhost","root","pass");
mysql_select_db("test");
echo "<table>";
$result = mysql_query("SELECT id, description, bin_data, filetype FROM binary_data");
$num = mysql_num_rows($result); 
$i =0;
while ($i < $num){
		//$variable_for_future_use=mysql_result($result,$the_row_we're_on,"field_name");
		$id=mysql_result($result,$i,"id");
		$description=mysql_result($result,$i,"description");
		$bin_data=mysql_result($result,$i,"bin_data");
		$filetype=mysql_result($result,$i,"filetype");
		echo "<tr><td>$id</td><td>$description<td><img src=\"$bin_data.$filetype\"></td></tr>";
}
echo "</table>";

?>

Which error did you get when trying to num row it? Your sql statement is also.. hm. Check that you're actually calling the table columnnames that exist and that you're doing them in order.