Upload Store Retrieve and Delete Images using PHP and MySQLi

To Upload Store Retrieve and Delete Images to and from the database by using procedural PHP and MySQLi is shown in this tutorial. To understand the code make sure you have gone through our previous tutorial basic image upload to the folder. Uploading images in MySQL database is not a good idea because you first need skills to convert that images into blob (Binary Large Object) and then you can upload it in MySQL and when you are going to retrieve it you need to again convert it in original form. So In this tutorial we are providing you efficient way to upload images on your server and save it’s with format in database when you want to retrieve the image just fetch the image name from database and link with your path.

1. Configure ‘php.ini’ File

Before moving to the coding part , You must have to configure your php.ini file (location of this file varies as per platform). In your php.ini  file, search for the ‘file_uploads’ directive, and check whether is it set to On. This control whether to allow HTTP file uploads.

2. Create Database

To store the image title and image name a table need to create in the database. So lets create the database by using following queries. The following SQL  create image table which consist of  id, title, imagename, time details.

3.Database Configuration

First of all, to make it convenient, we will create a new PHP file for database configuration named dbconfig.php  that holds all configured parameters:

 

4. Create User Interface

Create HTML Form to Upload Image

Now Its time to Create an HTML form index.html  to allow the user to choose a Image they want to upload

Ensure <form> contains the following attributes.

  • method=”post”
  • enctype=”multipart/form-data”
  • and input type=”file”

 

this file index.php will send data to uploading.php to upload the image data into the database.

CSS for the HTML Form

Add styling to the HTML form (index.html) by using CSS to make the content pretty and save the file by name index.css

Now place the two files in the same folder. Remember to save the files with the right extensions (respectively “.htm” and “.css”) . The combined view of the both HTML and CSS is illustrate in the following snapshot.

view of form

5. Upload Store Image into Server

Now its time to process the data uploaded by the user, this code is written in  uploading.php  It will store the uploaded file in a upload folder on permanent basis as well as implement some basic security check like file type and file size to ensure that users upload the correct file type and within the allowed limit.

You might be wondering what this code is all about, So here is the explanation of the code:

  • $_FILES[‘sfile’][‘size’]; checks whether the file is larger than 500KB, If it is, an error message is displayed.
  • pathinfo($cname, PATHINFO_EXTENSION); function is use to get the file extension and to validate the file format to check whether the user selects an image file.
  • pathinfo($name,PATHINFO_FILENAME); function is use to set filename.
  • move_uploaded_file() function is used to uploads the selected file to the selected location. In our code the image is uploading to upload folder.
  • date() function is concatenates with the name to set unique file name each time user uploads the image.

6. Retrieve And View Images From the Server

Now retrieve the uploaded images from the server based on the file names in the database and display images with its title in the web page.

 

User can able to delete the image entry from the database by clicking the delete button provided in an interface As shown in the snapshot below:

Upload Store Retrieve and Delete Images

7. Deleting image entries from the database

To delete the particular image entry from the database we use the id attribute,  $_GET method is used for the previous page input to identify which delete button is clicked by the user. After successfully deleting the data user got notified by pop-up and redirect to the show.php interface again

That’s it. Finally You Learn to Upload Store Retrieve and Delete Images to and from the database by using procedural PHP and MySQLi. If you have any doubts regarding to this tutorials feel free to ask in the comment section. To catch even more knowledgeble and easy understandable tutorials please subcribe to our email notification.

Download Source Code

4 thoughts on “Upload Store Retrieve and Delete Images using PHP and MySQLi

  1. J
    Johnny says:

    program does not even work the like button for facebook either
    error on check
    if (! empty ($ cname)) {
    if ($ size if (confirm (“File Uploaded Sucessfully !!!”))
    {document.location = ‘index.php’;
    }
    else

    Best regards
    Johnny

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.