Display Multiple Images from MySQL

NICKKKKK

Hello all,

I am having a problem of displaying all the images in one page although they exist on the database table. Only the first image is showing up....

this is the code i am using to display them....

$sql = "SELECT * FROM image";
$result = mysql_query ($sql, $conn);
if (mysql_num_rows ($result) > 0) {
$row = @mysql_fetch_array ($result);
$image_type = $row["image_type"];
$image = $row["image"];
Header ("Content-type: $image_type");
print $image;
}

I have also tried with the while loop but only the first one shows up....

any idea why?

thanks

leatherback

You can only display one image stream, as an image is just one file.

You need to create a page like the current that displays 1 image. And another which calls the image.php file for each image you want to display on the page.

An easier way would be to just store the images as files on yor server, and store the filename and/or path in the database, which would allow you to use one file to display your images.

SuPerNoVi

I personally think storing images in the database is really bad practice and I've read a few articles to support this.

Like Leatherback says store them on the server and put the path and image names into the database. You can then query the database and obtain an array which you can then foreach loop through to display the images.

NICKKKKK

Hello both of you,

First, I am sorry to post that thread again as I was trying to find it today and I couldn't. I thought it was not posted or i did something wrong.

I use to upload the images and use the move_uploaded_file function to store the images in a folder in the server and then just display them by img scr tags...How lovely!

however, my hosting company does not allow me to do that as due to permissions so although it works fine locally, i cannot do it on their server 🙁

Thanks

SuPerNoVi

That's very odd, what use is hosting you can't upload to?

I'm sure you have FTP access but that's very restricting.

I'd have words with them and if they wont budge then I'd be tempted to move hosting. Plenty of cheap options that do allow uploads.

NICKKKKK

the way i am using the code locally...

move_uploaded_file($FILES['image1']['tmp_name'], $object->set_absolute_path.$FILES['image1']['name']);
chmod($object->set_absolute_path.$_FILES['image1']['name'],0777);

and it works fine. In the server, however, it does not "upload" the images in the directory specified. They ve told me to change the permissions to 777 which I did but still nothing happens....🙁

NICKKKKK

This is what I get

move_uploaded_file(/imagescaribbean.....jpg): failed to open stream: Permission denied in /home/www/myarticl/addArticle.php on line 278

The image properties shows that the image source is:
http://mydomain.com/images/caribbean.....jpg

the images folder exists on my server with 777 permission.