: How to retrieve an image from MySQL database and display the image as background on body? How do I retrieve an image from MySQL database (I know how to display image by retrieving from database

@Shakeerah822

body
{
background-image:url('http://www.example.com/background/get.php');
}


Edit:

To create a page that returns the image properly, you would do something like this (in PHP):

You stated you can already retrieve the image from the database, so assuming you have the appropriate SQL in $sql, that the image data is stored in a field named 'image', and you can connect to the database and everything:

$result = mysql_query($sql);

if ($row = mysql_fetch_array($result)){
header('content-type: image/jpeg');
imagejpeg(imagecreatefromstring($row['image']));
exit();
}


That's assuming the image is a jpeg. If it's not, you'll need to change the header and call the appropriate image function (like imagegif, imagepng, etc).

Now, put that page somewhere, say www.example.com/background/get.php, and use that as the background-image url.

Vote Up Vote Down