How to retrieve images from MySQL database | PHP Examples
×


How to retrieve images from MySQL database

36023

In the article, we will provide a direct code for retrieving images from the database through a select statement. To retrieve the image from the database, you need the path of the image folder where you have moved/saved the image when you uploaded it. Now the code is given below to retrieve the image:-

<?php 

global $image_path;
$image_path ='image_upload/';

$query = "SELECT * FROM users WHERE id=2";
$sql=mysqli_query($GLOBALS['db'],$query);
$row=mysqli_fetch_array($sql);
 
?>

<img src="<?php echo $GLOBALS['image_path'].$row['profile_image'];?>" class="img-responsive">

global is used to get the value of that variable which is used with it at all over pages. You can put it in your functions file.

Read Also:

  1. Select Data from MySQL
  2. MySQL Update Data
  3. MySQL Insert Multiple

Retrieving images from the database plays an important role in certain conditions that are illustrated below:

a) When someone accidentally deleted the image from one location
b) Forgotten to save the image
c) When there is a requirement of using the particular image for some another purpose.
d) For maintaining security

For maintaining security, companies store the entire project images in a database linked with metadata image and apply various restriction controls to access particular image restricted to a different individual, which makes image retrieval more challenging.




Best WordPress Hosting


Share:


Discount Coupons

Get a .COM for just $6.98

Secure Domain for a Mini Price



Leave a Reply


Comments
    Waiting for your comments