Displaying images from MySQL table
We will not store the image in MySQL table ( plus2_db_images) but store the image name in table record. While displaying the image we will show other details of the record like ID, Price and Name of the image. You can download the script with all images at the end of this tutorial .
Connecting database and executing QueryTo manage data we have to connect to MySQL database and execute query to get our date. Here there are two ways to use PHP drivers to connect to MySQL and execute the functions for getting records.
One is using Portable Data Object ( PDO )
Second one is MySQLI ( MysQL Improved )
We used both types and you can download both the scripts inside the same Zip file.
How the images are stored .Images are stored inside image directory. The name of the image is stored in the record. We are not storing the path of the image in our record as we can change the path in our PHP script easily than using SQL to update the records if any changes in path is required.
BLob : Binary Large Object columns can be used to store images.
PDO Blob column adding , updating & displaying records
Style and LayoutWe used bootstrap 4 for our layout and images styles ( making it rounded ) , you can use your own style as the basic script remain same.
Downloading Zip fileDownload the zip file and use this instructions to run the file.
How to Install and test
This script is kept simple for easy understanding. To this program we can add deleting of image ( along with the record ) and adding of the image to database table. This we will learn in next part.
This article is written by plus2net.com team.