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);
?>

[harshmaul]

how many bytes worth of space are all the photos you will be uploading.

my personal preference is to store images in the DB, if the server can't handle it update the hardware, and software.

[mirianCalin]

how many bytes worth of space are all the photos you will be uploading.

my personal preference is to store images in the DB, if the server can't handle it update the hardware, and software.

would there be a problem if i export/import it from one pc to another?

[harshmaul]

How much space worth of images are you likely to save in the DB?

is it a commercial project, uni project?

[mirianCalin]

How much space worth of images are you likely to save in the DB?

is it a commercial project, uni project?

hi.. i've already solved this.. hehe.. i'll be continuing what i am doing.. but i'll be having a tutorial for server side coding...

[harshmaul]

cool. if you're pnly returning the images one at a time, and you becareful with your "select *" 's it won't slow anything down too much

[nse111]

OMG!! I'v bin lookin for this for sooooooooooo long! all of u r life savers!!!!! thaaaaaaaaaaaaa aaaaaaaanks!!! I'm a newbie myself :( thanks thanks... :)

[vinco83]

Hey everyone...

I've tried following this thread, and can't seem to get the code to work! I've been working on this for hours now, and i'm going crazy here lol

When I go to test2.php (which should show me the images), all it shows are image placeholders! It's pulling the images somewhat correctly, if I upload another image to the table...it'll show another placeholder, and viewing properties on the images shows the correct URL...the image just isn't showing up at all :( Can anyone help?

Here's my code:

test.php

 <?php 
    $errmsg = "";
    if (! @mysql_connect("localhost","root","welcome"))
    {
    $errmsg = "Cannot connect to database";
    }
    @mysql_select_db("emotion");
 
    if (IsSet($_GET['image_id'])){
   $gotten = @mysql_query("select image, type from whats_hot where image_id = ".$_GET['image_id']);
   list( $type,$data ) = mysql_fetch_row( $query );
   header("Content-type: {$type}");
   while ($row = mysql_fetch_array($gotten,MYSQL_ASSOC))
   {
   print $row['image'];
 
   }
   mysql_free_result($gotten);
   }
   ?>

test2.php

 
   <?php
   $errmsg = "";
   if (! @mysql_connect("localhost","root","welcome"))
   {
   $errmsg = "Cannot connect to database";
   }
   @mysql_select_db("emotion");
 
   $strSQL = "select * from whats_hot";
   $rsPix = mysql_query($strSQL);
   $numRows = mysql_numrows($rsPix);
   $i = 0;
 
   while($i < $numRows){
   ?>
   <img src="test.php?image_id=<?php echo mysql_result($rsPix,$i,"image_id"); ?>"/>
   <?php
   $i++;
   }
   ?>
 
 

my whats_hot table is set up like so:

image_id (int) auto_increment
image (MEDIUMBLOB)
type (varchar)

[tharden3]

@harshmaul
This page has a lot of great information, and I'm glad Bytes has such active and helpful members. I'm a bit confused though. I was wondering if you could help me out.

I'm trying to achieve basically the same thing that these two pages (pix.php and list.php) seek to create. I'd like to take the images from a database, and show those images to my website users in a nice neat little column. You don't need to show me any code, you've already done that. I just have a few questions.

So the first thing I need to do is set up my tables with a BLOB field labeled imgdata, and a pixID field labeled..... well, what exactly is the pixID field, and how should it be labeled? What are the signifigance of each of these pages? Which part of the code am I just referencing to, and which part actually shows the image? I'd just like a little clarification. I'm awfully new to this. Thanks Bytes.

-Tim

[naimlatifi]

Hi everyone,

I tried to make this to work but I am having the same problem as vinco83. The images seems to get retrived correctly but it only shows the placholder not image. when I debugged it says that "ID not found in Msyql result index 5"

Looking forward to hear from you soon !


Best regards,
Naim