How to retrieve images from MySQL database

by Yogesh Khanna 31-May-18

0 732


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.



Share:

Comments

    No Comments Yet.

Leave a Reply