PHP Display image out of DB

**nightcat** · March 13th, 2007, 12:45 PM

hi guys

I've hit another problem

Got a db which holds the images I need for the site. There is a number of reasons for doing that and other options were checked out.

I also got a script which supposed to show those images, unfortunately it only shows the first image in db unless specificaly told display another image, but I need it to desplay all the images stored or multiple entries.

Here's the table settings:
CREATE TABLE upload (
id INT NOT NULL AUTO_INCREMENT,
name VARCHAR(30) NOT NULL,
type VARCHAR(30) NOT NULL,
size INT NOT NULL,
content MEDIUMBLOB NOT NULL,
PRIMARY KEY(id)
);

and here is the last variation of the code

<?php
$host = "localhost";
$user = "";
$password = "";
$database = "";

$connection = mysql_connect($host,$user,$password)
or die ("Couldn't connect to a server");

$database = mysql_select_db($database, $connection);

$query = "SELECT id, type, content FROM upload";

$result = mysql_query($query) or die('Error, query failed');

if(mysql_num_rows($result) == 0)
{
echo "Database is empty <br>";
}

else
{
while($results = mysql_fetch_array($result))
{
$content = $results["content"];
$type = $results["type"];
$id = $results["id"];

$image= imagecreatefromstring($content);

switch ($type){

case "image/jpeg":
header("Content-type: image/jpeg");
$display = imagejpeg ($image);
imagedestroy($image);
break;

case "image/png":
header("Content-type: image/png");
$display = imagepng($image);
imagedestroy($image);
break;

case "image/gif":
header ("Content-type: image/gif");
$display = imagegif($image);
imagedestroy($image);
break;

}
}
}

?>

<html>
<head>
<title>Download File From MySQL</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<?
for ($i=0; i<count($display); $i++){
echo $id;
echo' <img src="' . $display . '" /><br />';
}

?>

</body>
</html>

So far there are definately 3 images in db, they are all jpegs. Any help welcome

**Aardpsymon** · March 13th, 2007, 02:47 PM

wellll.....sending multiple headers is not good. I think that is your problem right there. You need to be putting these images into a html page not just sending them over and over. Your browser will ignore the second header, or error.

**nightcat** · March 13th, 2007, 02:52 PM

OK. Thanks for that

Although it also poses a bit of a problem, how should I display images of different formats?

Will they all display as jpegs?

**Aardpsymon** · March 13th, 2007, 03:04 PM

well, I would embed the images in html. Unfortunately I can't think how to do that off the top of my head, never had to do that from a db before.

certainly if you are wanting to display these images in the same window you will have to.

**nightcat** · March 13th, 2007, 03:29 PM

Yeah, most people prefer to do it from file system and then put the reference to the physical file location in db. That's the way I did it before.

At the moment I am trying to create a set of images independent of file system.

***oofki*** · March 13th, 2007, 06:07 PM

Ive setup something like that for a graph would that help?

**nightcat** · March 13th, 2007, 06:10 PM

Yeah that would be greate, any samples could give me the solution

***phishphreek*** · March 13th, 2007, 06:24 PM

I think this is more of what you'd want?
http://codewalkers.com/tutorialpdfs/tutorial35.pdf

***oofki*** · March 13th, 2007, 08:20 PM

I used jpgraph http://www.aditus.nu/jpgraph

**nightcat** · April 13th, 2007, 12:41 PM

Thanks alot for all the replyes.

Got the way the script should work now and got the basic system up. Now just working on creating my own image library

Thread: PHP Display image out of DB

Thread Tools

Display

PHP Display image out of DB

Similar Threads

Apache, PHP, MySQL with basic security settings.

Tutorial: Apache 2.0.49 and PHP 4.3.7!

The history of the Mac line of Operating systems

Installing Apache and PHP on Linux

Protecting Yourself From Image Theft

Posting Permissions