how to display image from database?

[mirianCalin]

i am doing a site for appliance center..
i need to display all the products that the company offers, but my problem is that i cant display ALL the images in my database.. the first entry on the database is the only one that displays..
i am using mysql as database

here's the code.. tell me what's my error and pls. kindly edit it..

**imgdata = it is where i store the image.. longblob is the data type

<?php 
    $errmsg = "";
    if (! @mysql_connect("localhost","root",""))
        {
                $errmsg = "Cannot connect to database";
                            }
    @mysql_select_db("upload");
 
    $gotten = @mysql_query("select imgdata from pix");
    header("Content-type: image/jpeg");
    while ($row = mysql_fetch_array($gotten))
    {
        print $row['imgdata'];
 
    }
mysql_free_result($gotten);
?>

[mirianCalin]

okies, i never read that.

can you post some mark up this time.

Also your table definition would help

hi!!
what mark up?
my table name is "product"
the fields inside are:

pid (int) > product's id
title (text) > name of the product
imgdata (longlob) > the image
feature (text) > the product's feature.. this is also my problem when displaying.. like what i've mention above..

[harshmaul]

Hi again mate,

I think i know the problem...

replace the line that you have printing out the string with a piece of code that swaps carriage returns with <br/>'s

something like this.....

<?php echo nl2br(mysql_result($rsPix,$i,"feature")); ?>

BTW, markup is what you get when you view source in the browser after the PHP is run

[mirianCalin]

Hi again mate,

I think i know the problem...

replace the line that you have printing out the string with a piece of code that swaps carriage returns with <br/>'s

something like this.....

<?php echo nl2br(mysql_result($rsPix,$i,"feature")); ?>

BTW, markup is what you get when you view source in the browser after the PHP is run

hello.. thanks again for the reply..

this is the code for displaying the image's title, image & feature..
the only problem now is that i dont have a code for displaying the image..
the code only displays the title and feature..

<?php
$errmsg = "";
if (! @mysql_connect("localhost","root","")) {
        $errmsg = "Cannot connect to database";
        }
@mysql_select_db("upload");
 
$pid = $_GET['pid'];
$strSQL = "SELECT * FROM sharp where (pid = '$pid')";
 
$rsPIX = mysql_query($strSQL);
$num=mysql_numrows($rsPIX);
$i=0;
 
if ($num > 0){
$title = mysql_result($rsPIX,$i,"title");
$description = nl2br(mysql_result($rsPIX,$i,"feature"));
}
echo $title . "<br>";
 
echo $description . "<br>";
?>

[harshmaul]

<?php
$errmsg = "";
if (! @mysql_connect("localhost","root","")) {
        $errmsg = "Cannot connect to database";
        }
@mysql_select_db("upload");
 
$pid = $_GET['pid'];
$strSQL = "SELECT * FROM sharp where (pid = '$pid')";
 
$rsPIX = mysql_query($strSQL);
$num=mysql_numrows($rsPIX);
$i=0;
 
if ($num > 0){
$title = mysql_result($rsPIX,$i,"title");
$description = nl2br(mysql_result($rsPIX,$i,"feature"));
}
echo $title . "<br>";
 
echo $description . "<br>";
?>

Hi.

You've forgotton to put the image in....

Remember the page we made that displayed the imaged using an image tag?... we need to use that again on this page. This time we have the ID though. So it will be something like this....

<img src="pix.php?pixID=<?php echo mysql_result($rsPIX,$i,"PixID"); ?>"/>

Put that in the if statement and it should work!

[mirianCalin]

Hi.

You've forgotton to put the image in....

Remember the page we made that displayed the imaged using an image tag?... we need to use that again on this page. This time we have the ID though. So it will be something like this....

<img src="pix.php?pixID=<?php echo mysql_result($rsPIX,$i,"PixID"); ?>"/>

Put that in the if statement and it should work!

i've seen my mistake..
yeah, i've tried putting that code..
but i forgot to put this <? ?>
hehe.. thanks again..

this question is out of topic..
are you working?
how old are you friend?

[mirianCalin]

hey, got a problem again..
a 4th yr.student told me that i should not use 'longblob' for saving images because it's 'heavy' for the database and i will have a problem if i export/import the database from one computer to another..

do you have other suggestions for me?
i have only one week to finish this site.. *sighs*

[Markus]

hey, got a problem again..
a 4th yr.student told me that i should not use 'longblob' for saving images because it's 'heavy' for the database and i will have a problem if i export/import the database from one computer to another..

do you have other suggestions for me?
i have only one week to finish this site.. *sighs*

Are you not able to store images on the server?

[harshmaul]

I agree with markusn00bs and disagree to an extent....

Agree buecause it is heavy for the server, and you can use image file uploads.

And disagree as if you images are in a DB you can ensure security alot more, like put the image view page behid a log in page

[mirianCalin]

Are you not able to store images on the server?

the images are only stored in the DB..

[mirianCalin]

I agree with markusn00bs and disagree to an extent....

Agree buecause it is heavy for the server, and you can use image file uploads.

And disagree as if you images are in a DB you can ensure security alot more, like put the image view page behid a log in page

so, do you have any suggestions?
i am not doing the site now 'cause i might start all over again..