How to retrieve images from MySQL database
0 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:
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
Waiting for your comments