How to display/ retrieve all images from the database

Question

I want to display all Images from the database but my code here displays only one. How can I get them all and display in my webpage. I know I need to put a loop but I wonder where it should be.

Here's my php code so far (without loop)

include('../include/connect.php');
$query=ibase_query("SELECT FILEDATA FROM ARCHIVE WHERE FILE_TYPE='Image'");
$data=ibase_fetch_object($query);
if($data){
  header("Content-type:image/jpeg || image/gif || image/png || image/pjpeg");
  ibase_blob_echo($data->FILEDATA);
}

In sql libraries there'll be a function on the return value that'll return the next row while there are rows left. Call that in the loop while it still has rows remaining (will be another function) — Patashu, Mar 13 '13 at 01:05

score 1 · Answer 1 · edited May 23 '17 at 11:50

1

Each time you use ibase_fetch_object it gets the next object

so you could uset it in a while loop (php example) :

 header("Content-type:image/jpeg || image/gif || image/png || image/pjpeg");
    while ($data=ibase_fetch_object($query){


  ibase_blob_echo($data->FILEDATA);

}

EDIT : following this answer you should have 2 separate files

edited May 23 '17 at 11:50

Community

1
1

answered Mar 13 '13 at 01:09

Jeffrey Nicholson Carré

2,950
1
26
44

it still loads only one image :( – anastasia Mar 13 '13 at 01:43
i changed the post i was resending the header – Jeffrey Nicholson Carré Mar 13 '13 at 01:54
i really appreciate your help bleuscyther, but it still gives the same result. :( – anastasia Mar 13 '13 at 02:09
try to output the result of the query SELECT Count(*) FROM ARCHIVE WHERE FILE_TYPE='Image' to see if the query is ok – Jeffrey Nicholson Carré Mar 13 '13 at 02:14
also i don think you will be able to display all of them that way: http://stackoverflow.com/questions/5753928/how-to-display-multiple-images-blob-from-mysql-using-php – Jeffrey Nicholson Carré Mar 13 '13 at 02:20
now it's giving me goosebumps. when i try to count all image files it only counts 1 but when i checked my database values, i have stored 3 image files there. anyway thanks a lot for this bleuscyther, it kinda gives me an idea now that the problem is not in the code. – anastasia Mar 13 '13 at 02:27

score 0 · Answer 2 · answered Mar 13 '13 at 01:10

0

Well, dunno if this works but, you might as well consider use foreach loop.

foreach ($data as $value) {
if ($value) {
    ibase_blob_echo($value->FILEDATA);
}
}

answered Mar 13 '13 at 01:10

Wesley Brian Lachenal

4,381
9
48
81

i still get the same output considering that i replaced $value in the $value->FILEDATA line with $data because it does not work. :( – anastasia Mar 13 '13 at 01:52

How to display/ retrieve all images from the database

2 Answers2