Not able to retrieve images from database

ankitneedshelp · #1 (**permalink**) 11-02-09, 02:02

I have created a mysql database from which i need to call images in the front end.
database description:-

databsae:-my sql
dbname:-dw_bookstore table:-images, field:- type{varchar} size{30}
field name:image and stored path is(C:\wamp\www\images\Bluehills.jpg after that i'll try ..\images\Bluehills.jpg ) but its not working.

PHP code:

<?php
$con = mysql_connect("localhost","root","");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("dw_bookstore", $con);

$result = mysql_query("SELECT * FROM images");

mysql_close($con);
?>
<html>
<body>
<img src="<?php echo $row['image']; ?> " alt="<?php echo $row['image']; ?>" />
</body>
</html>

and error is:
some time look blank image or with
 Notice: Undefined variable: row in C:\wamp\www\view.php on line 17

plz help me....................... i am too confused.

healdem · #2 (**permalink**) 11-02-09, 02:22

where did you set the value of the variable $row?

i'd expect to see something similar to:-

PHP Code:


			
$result = mysql_query("SELECT * FROM images");
if (Mysql_ErrorNo() != 0)
{ //insert any error handling here
} else //we found an image
  $row=mysql_fetch_array($result);
}

mysql_close($con);
?> 
<html>
<body>
<img src="<?php echo $row['image']; ?> " alt="<?php echo $row['image']; ?>" />
</body>
</html>

Internet Services

Web Development

Digital Marketing

Consumer Tech