Fetch Image from Database

Balen

Hi
I have a database which stores images, from this database I was able to to fetch that images according to image_id like
<img src="image.php?id=1">
I have been trying to pass varibles through form.htm to image.php so that I can call different images according to id at IMAGE.If I post id=2 from form.htm, image.php shows the image whose id=2, when I post.But if I close the browser and open image.php there will be no image and show undefined variable value.
form.htm:
<FORM method="post" action="image.php">
IMAGE<INPUT TYPE="text" Name="value">
<INPUT TYPE="submit" VALUE="Submit Form1!">
</FORM>

image.php:
IMAGE<img src="image.php?id=<? echo $value; ?>" width="60" height="40">

my problem is:
HOW COULD I MAKE THE SCRIPT SO THAT I COULD WRITE IN image.php id=1 or 2 or 3 WHATVER I WANT TO CALL AND WOULD DISPLAY ME IMAGE FROM IT'S ID.

please help me on this matter.

jeremuck

I'm not sure I understand.
You might need to send apropriate headers.
What is in your database? the binary information composing the image or a path to the image on the hard disk?

If you are calling:
image.php?id=3

image.php should do the following

Look up id 3 in your database.
Send apropriate headers.
Print what it finds to the browser.

Balen

form.htm:
<FORM method="post" action="image.php">
IMAGE FOR SUNDAY<INPUT TYPE="text" Name="Image_Id">
<INPUT TYPE="submit" VALUE="Submit Form1!">

</FORM>

image.php:
<?php

if(isset($id)) {

$db = mysql_connect("localhost", "username", "password");
mysql_select_db("database",$db);
$query = "select image,filetype from image_data where id='$id'";
$result = @($query);

$data = @MYSQL_RESULT($result,0,"image");
$type = @MYSQL_RESULT($result,0,"filetype");

Header( "Content-type: $type");
echo $data;

};

?>
<html>
<head></head>
<body>
IMAGE FOR SUNDAY<img src="image.php?id=<? echo $Image_Id; ?>" width="60" height="40">
</body>
</html>

Here from form.htm I enter 1 (Image_Id) IMAGE FOR SUNDAY, and image.php reads the variable and shows the image according to it's id.BUT IF I BROWSE http://localhost/image.php IT SAYS THAT undefined variable Image_Id in line.
THAT MEANS THE Image_Id which I HAD POSTED FROM form.htm WORKS ONLY FOR THE POSTED SESSION.
MY QUESTION IS HOW COULD I MAKE SO THAT IT WOULD WRITE in image.php Image_Id(IMAGE FOR SUNDAY<img src="image.php?id=1" >).
HOPE I HAD MAKE CLEAR MY PROBLEM.

jeremuck

ok I see your problem.

You know that if you use POST or GET, the variable is supposed to be created in the page.
This is correct. You know it's working for POST and you want it to likewise work for GET.

Moreover, you can't figure out why it's not working for GET, when you seemingly have the syntax correctly.
Out of curiosity, what OS are you working on?

it says undefined? But you did pass it in... so you know it must be there somewhere.

try doing this:

it might enlighten you

You should be able to see if the variable indeed exists or not, and if it does, how you can access it.
And you may need to detect in your script whether you are recieving it from GET method or from the POST method.
Good Luck

Balen

THANKS