I have successfully uploaded images into mysql database, but now I want to display the images alongside other row data in html page.

Thanks for your previous help.


something along these lines...you'll need to tweak it to fit your script, but you should get the idea...

//connect to mysql with your variables here...
//execute your sql query(s), store result in $result
//make a table to hold images and data
$output = "<table width=\"300\">";

//fetch each row of data
while($row = mysql_fetch_array($result))
	//do something with each row of data
	//refer to columns holding data as $row['columnName'];
	//for example...
	//fill table with data...be sure to refer to the column/field names in your database table!
	$output .= ("
		<td><img src =\" ". $row['imageURL'] . "\"></td>
		<td>". $row['imageTitle'] . "</td>

//close table tag
$output .= "</table>";

//display output
echo $output;

Thanks Johnsquibb for the reply,

Please see my code that I used to insert the image and other data. The image is inserted directly into the database.

$errmsg = "";
if (! @mysql_connect("localhost","root","")) {
        $errmsg = "Cannot connect to database";



        if($imgtype=="image/jpeg" || $imgtype=="image/jpg" || $imgtype=="image/pjpeg" || $imgtype=="image/gif" || $imgtype=="image/x-png" || $imgtype=="image/bmp")

            $fp = fopen($image, 'r');
            $content = fread($fp, filesize($image));
            $content = addslashes($content);
            $sql="insert into img_tab1 (name,image,address,dateofbirth) values ('$name','$content','$address','$dateofbirth')";
            $res=mysql_query($sql) or die (mysql_error());

Please further suggestions to display the whole row data including the image will be appreciated.


Edited 3 Years Ago by mike_2000_17: Fixed formatting

You can insert in the image table the path where you have saved your picture.Then display it like:

<img src =\" ". $row['imageURL'] . "\">
//where the value of $row['imageURL'] is the path of the image like "www.domain.com/pics/pic1.jpg"

Its not a good idea to store images in the database. As Ryan_vietnow has mentioned, it will add on to the server load, slows down the execution of the script and takes a lot of time to display it if you have more (say 100 images ) per page!

This article has been dead for over six months. Start a new discussion instead.