Browse Images data to table

[dungnm]

Dear all,

I have a problem with browsing the image (which I called from database) into the table.

When I browsed the image without the table, it worked well, but when I insert the Image data to the <td></td> it did not work.

This is my code, including Store and Get Image data parts

Any help are highly appreciated
Thanks

[sdjensen]

Hi

In the file getdata.php you have sent the header in this line

Header( "Content-type: $type");

So if you want to have the picture inside a <td></td>

you need to do it like this....where id is the id number for the picture

print "<table><tr>";
print "<td><img src=\"getdata.php?id=111\" alt=\"image 111\"></td>";
print "</tr></table>";

[dungnm]

Dear sdjensen,
I tried you way, but I got binary code instead of the photo,
Did it work on your side?

Any helps are highly apprecited

THank you
NMDung

[dungnm]

Dear sdjensen,

I tried your way, but It did not work, I still can not browse image in a <td></td>. When I do like that, I got the Binary code instead of the photos.

Any help are highly appreciated.
Thank you
MNDung

[sdjensen]

Make sure that you are not echo'ing anything out except the $data in getdata.php.

Could you please show me the code for broswing the pictures?

[dungnm]

Dear sdjensen,

This is the code I tried. The comment following the code
Thanks a lot

Happy New Year !

<?php

// getdata.php3 - by Florian Dittmer <[e-mail]>
// Example php script to demonstrate the direct passing of binary data
// to the user. More infos at http://www.phpbuilder.com
// Syntax: getdata.php3?id=<id>

if($id) {

// you may have to modify login information for your database server:
@MYSQL_CONNECT("localhost","root","");

@mysql_select_db("binary_data");

$query = "select bin_data,filetype, filename from binary_data where id=$id";
$result = @MYSQL_QUERY($query);

$data = @MYSQL_RESULT($result,0,"bin_data");
$type = @MYSQL_RESULT($result,0,"filetype");
$filename = @MYSQL_RESULT($result,0,"filename");

Header( "Content-type: $type");
//echo $type; echo '<br>';
//echo $data;

echo '<table border="1">';
	echo '<tr>';
	//In this case it returns empty image
	echo "<td><img src=\"getdata.php?id=11\" alt=\"image 11\" align=center width=115 height=150></td>"; 
	// In this case it return Binary code
	//echo "<td> $data</td> ";
	echo '</tr>';
echo '</table>';

};
?>

[sdjensen]

change this line

//echo $data; 

to

echo $data; 

this part MUST be in another file. Put this code in a file ex.php
and then it should work.

 
echo '<table border="1">'; 
echo '<tr>'; 
//In this case it returns empty image 
echo "<td><img src=\"getdata.php?id=11\" alt=\"image 11\" align=center width=115 height=150></td>"; 
// In this case it return Binary code 
//echo "<td> $data</td> "; 
echo '</tr>'; 
echo '</table>';