How to display 5 pictures stored in mysql using while loop.

[inexploration]

Hello Sirs/madam
i have 5 picture store in mysql , and now i want to display these picture on the page ,using while loop ., in php.
please let me know through very very simple code.
thanking you.
best regards.
ikram

[pbmods]

Heya, ikram. Welcome to TSDN!

You posted this in the PHP Articles section. I'll go ahead and move it to the PHP Forum where an Expert will be more likely to find it.

Changed thread title to better describe the problem.

[kovik]

Is the binary data actually saved in the database, or just the filenames?

[inexploration]

Is the binary data actually saved in the database, or just the filenames?

Hello sir.
these pictures stores as blob in mysql. and i wnt to display these all pictures through while loop. i will understand very very simple code.

thanks.
ikram

[Tarantulus]

Hello sir.
these pictures stores as blob in mysql. and i wnt to display these all pictures through while loop. i will understand very very simple code.

thanks.
ikram

Ikram,

by the sound of it you'll just need to loop through the mysql_result array

try:

$sql="SELECT imagename FROM yourtable";
$runsql=mysql_query($sql);
$i=0;
$len=mysql_numrows($runsql);
 
while($i<$len){
$image=mysql_result($runsql,$i);
echo("<IMG SRC=\"$image\"></IMG>
}

obviously you need to replace "imagename" with the name of your SQL field and "yourtable" with the name of the table

my coding is a bit sloppy so maybe someone else may give you a cleaner answer, but as far as I can gather that is what you want

[gauravgmbhr]

Ikram,

by the sound of it you'll just need to loop through the mysql_result array

try:

$sql="SELECT imagename FROM yourtable";
$runsql=mysql_query($sql);
$i=0;
$len=mysql_numrows($runsql);
 
while($i<$len){
$image=mysql_result($runsql,$i);
echo("<IMG SRC=\"$image\"></IMG>
}

obviously you need to replace "imagename" with the name of your SQL field and "yourtable" with the name of the table

my coding is a bit sloppy so maybe someone else may give you a cleaner answer, but as far as I can gather that is what you want

try this link and see how the while loop is used with mysql_fetch_row()
http://in2.php.net/mysql_fetch_row

[kovik]

$sql="SELECT imagename FROM yourtable";
$runsql=mysql_query($sql);
$i=0;
$len=mysql_numrows($runsql);
 
while($i<$len){
$image=mysql_result($runsql,$i);
echo("<IMG SRC=\"$image\"></IMG>
}

The images are sored in the database, so the <img> tag wouldn't work that way. Also, FYI, you don't need a counter variable ($i), or the number of rows.

[kovik]

In order to display data from your database as an image, you'll need to create a file dedicated to retrieving the images and use it to display.

i.e.

[php]// image.php
header('Content-Type: image/jpeg');

// Check if it's been given an image to load
if(!isset($_GET['id']))
{
echo file_get_contents('someDefaultImage.jpg');
}
else
{
// Get the data
$result = mysql_query('SELECT `imageData` FROM `imageTable` WHERE `id` = " . (int)$_GET['id'] . ";");
$data = mysql_fetch_object($result);

// Echo the data
echo $data->imageData;
}[/php]

And then, call it in your other files like this:

[html]<img src="path/to/image.php?id=1" />[/html]

You could easily turn that into a while loop where you increment the id to use.

[Tarantulus]

Wow, I try to help and I get schooled! wasn't expecting that :)

[kovik]

Wow, I try to help and I get schooled! wasn't expecting that :)

Hehe. Well, it's a good thing that you did. If you were to continue retrieving results in that manner, you'd be wasting valuable memory.

[inexploration]

Ikram,

by the sound of it you'll just need to loop through the mysql_result array

try:

$sql="SELECT imagename FROM yourtable";
$runsql=mysql_query($sql);
$i=0;
$len=mysql_numrows($runsql);
 
while($i<$len){
$image=mysql_result($runsql,$i);
echo("<IMG SRC=\"$image\"></IMG>
}

obviously you need to replace "imagename" with the name of your SQL field and "yourtable" with the name of the table

my coding is a bit sloppy so maybe someone else may give you a cleaner answer, but as far as I can gather that is what you want

Hello sir.
i see your code became very happ because of very smple code. but sir try this , it doesn't work. i write the whole code is.

<?php
 
 
mysql_connect('localhost','root','')
or die ("connection can't be established");
mysql_select_db("test")
or die("Data Base Can't be selected");
 
$sql="SELECT imagename FROM pix";
$runsql=mysql_query($sql);
$i=0;
$len=mysql_numrows($runsql);
 echo $len;
while($i<$len)
{
 
$image=mysql_result($runsql,$i);
 
echo "(<IMG SRC=\"$image\"></IMG>;
 
}
 
?>

please you try this byself and then inform from the correct one.
thanking you.
best regards .
ikram

[inexploration]

Hello sir.thank you very much.
sir can you write me the complet programing code so that i display the 5 pictures saved in mysql. sir for this you also write the following codes.

1 - code for table where my pictures are stores.
2- retrive the pictures through loop from mysql (sir write complete program)
3- display this on the other page (pleae write complete program)
sir you write these codes for me, and also try by you rself to test this.

i mean you write the whole program so i copy this from here and paste in my note pade and this should work . i will set the database connection no proble.
thanking you.
ikram


thanking you sir.

In order to display data from your database as an image, you'll need to create a file dedicated to retrieving the images and use it to display.

i.e.

[php]// image.php
header('Content-Type: image/jpeg');

// Check if it's been given an image to load
if(!isset($_GET['id']))
{
echo file_get_contents('someDefaultImage.jpg');
}
else
{
// Get the data
$result = mysql_query('SELECT `imageData` FROM `imageTable` WHERE `id` = " . (int)$_GET['id'] . ";");
$data = mysql_fetch_object($result);

// Echo the data
echo $data->imageData;
}[/php]

And then, call it in your other files like this:

[html]<img src="path/to/image.php?id=1" />[/html]

You could easily turn that into a while loop where you increment the id to use.

[pbmods]

Heya, ikram.

TSDN members are expected to write their own code. We're happy to help you out if you have specific questions, but you can't realistically expect someone to do your coding for you on a free forum.

[kovik]

sir can you write me the complet programing code so that i display the 5 pictures saved in mysql. sir for this you also write the following codes.

1 - code for table where my pictures are stores.
2- retrive the pictures through loop from mysql (sir write complete program)
3- display this on the other page (pleae write complete program)
sir you write these codes for me, and also try by you rself to test this.

i mean you write the whole program so i copy this from here and paste in my note pade and this should work . i will set the database connection no proble.

How much are you going to pay me for it? I don't work for free.