Uploading and storing image

PHP
21

If you add var_dump($imageResult), what do you get as the output (may need to comment out the header() call)

22

this is the output i had
Notice: Undefined variable: imageResult in /Users/mgltd/Sites/reacheasy/affiliatestore.php on line 6 NULL

23

Using

$id =  mysql_real_escape_string($_REQUEST['id']); 
//echo $id; 
$imageQuery = mysql_query("SELECT * FROM store WHERE id=$id"); 
$imageResult = mysql_fetch_assoc($imageQuery); 
$image = $imageResult['image']; 
$nimage = $imageResult['name']; 
//echo $nimage; 
//header("content-type:image/jpeg"); 
var_dump($imageResult);
echo $image; 
?>

Produced Undefined variable: imageResult and the value of NULL?
That means it couldn’t find the data in your table for the $id given. So it never returned an entry for the image.

24

but the database is showing that an image has been uploaded

25

What is the ID of that record?

26

id is 56

27

Okay, so try this and go to this page directly

$id =  56; //mysql_real_escape_string($_REQUEST['id']);
//echo $id;
$imageQuery = mysql_query("SELECT * FROM store WHERE id=$id");
$imageResult = mysql_fetch_assoc($imageQuery);
$image = $imageResult['image'];
$nimage = $imageResult['name'];
//echo $nimage;
//header("content-type:image/jpeg");
var_dump($imageResult);
echo $image;
?>

Then paste the output here so I can see what it returned

28

i tried http://localhost/~mgltd/reacheasy/getaffiliatestore.php?id=57

it says the image http://localhost/~mgltd/reacheasy/getaffiliatestore.php?id=57 cannot be dispaled because it contains error