How to Insert Multiple Image in PHP MySQL

How to Insert Multiple Image in PHP MySQL

Good day! Today, I will tackle How to Insert Multiple Image in PHP MySQL. I hope that this topic would help you especially those newbie programmers who find it difficulty in inserting image MySQL Database using PHP.

This PHP Tutorial with source code is the best answer to solve the problem raised in other sites.

If you are looking for more complete BEST PHP PROJECTS WITH SOURCE, you can jump in here. For sure you will learn so much from these materials.

How to Insert Multiple Images in PHP MySQL

Step 1. Database Setup

In this step, we are going to execute a query that will create a table that will serve as storage for our images. This table named “tbl_images”.

CREATE TABLE `tbl_images` (
	`id` INT(11) NOT NULL AUTO_INCREMENT,
	`location` VARCHAR(100) NOT NULL,
	PRIMARY KEY (`id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
AUTO_INCREMENT=12;

Step 2. Setting Up Connection

In this step, we will create a connection between PHP and MySQL.

Here’s the following code.

<?php
$host = "localhost";
$user = "root";
$password = "";
$database = "db_name";
	$conn = new mysqli($host, $user, $password, $database);
        if($conn->connect_error){
            die("FAILED:" . $conn->connect_error);
        }  
?>

Step 3. Create index.php file

In index.php file, it will allow the user to select the image. Here’s the following code.

 <form method="POST" action="insert.php" enctype="multipart/form-data">
        <input type="file" name="files[]" multiple>
        <input type="submit" name="submit" value="ADD">
    </form>

Step 4. Create insert.php file

In this file, it will insert your image location to your database.

<?php 
 $output = '';  
 if(is_array($_FILES))   
 {  
      foreach ($_FILES['files']['name'] as $name => $value)  
      {  
           $file_name = explode(".", $_FILES['files']['name'][$name]);  
           $allowed_ext = array("jpg", "jpeg", "png", "gif");  
           if(in_array($file_name[1], $allowed_ext))  
           {  
                $new_name = md5(rand()) . '.' . $file_name[1];  
                $sourcePath = $_FILES['files']['tmp_name'][$name];  
                $targetPath = "filelocation/".$new_name;  
                $sql = "INSERT INTO tbl_images (id, location) VALUES (null, '{$targetPath}')";
                $image = mysqli_query($conn,$sql);
                if(move_uploaded_file($sourcePath, $targetPath))  
                {  
                }                 
           }            
      }  

 }  
 ?>
 
            alert ("Successfully added.");
            window.location = "index.php";

Step. 5 Finally, create a folder named filelocation for the destination of the image.
End.

If you desire to create a Database design for your project, you may be like the list of database design projects with complete documentation below.

For More Database Design Examples

• ER Diagram for Sales and Inventory System Database Design
• Ordering System Database Design with ERD
• ER Diagram for Water Refilling Station System Database Design
• Database Design for High School Enrollment System

Technology stack and requirements

To run this PHP project, you need these tools on your development machine:

• XAMPP or WAMP server. Bundles Apache, MySQL, and PHP so you can run PHP on Windows without individual installs. Free from apachefriends.org.
• PHP 8.0 or higher. Included with XAMPP. Older versions (5.x, 7.x) may work but modern PHP features improve security and performance.
• MySQL or MariaDB. Comes with XAMPP. phpMyAdmin manages the database through a browser UI.
• VS Code or PhpStorm. Free code editor with PHP syntax highlighting, IntelliSense, and debugging support.
• Web browser. Chrome, Firefox, or Edge for testing the running app.

Installing the source code

1. Download the archive. Get the ZIP file from the download link on this page and extract it.
2. Move to htdocs. Place the extracted folder inside C:\xampp\htdocs\ so Apache can serve it.
3. Import the database. Open http://localhost/phpmyadmin, click Import, and select the .sql file included in the archive.
4. Update database credentials. Open the config.php or connection.php file and set the correct database name, username, and password (default XAMPP: root / empty password).
5. Run the project. Start Apache + MySQL in XAMPP, then visit http://localhost/your-project-folder/ in a browser.

Using this project for your BSIT capstone

This PHP project maps cleanly to standard BSIT capstone documentation. Suggested chapter alignment:

• Chapter 1 (Introduction). Discuss the problem the system solves in real-world context. Cite Philippine business or academic use cases where a manual process could be replaced.
• Chapter 2 (Review of Related Literature). Compare this system’s features against 5-10 similar published projects. Cite journals like IJERT or IEEE Access for academic-standard sources.
• Chapter 3 (Methodology). Include Use Case Diagram, Data Flow Diagram, Entity Relationship Diagram, and Activity Diagram covering all major workflows.
• Chapter 4 (Results and Discussion). Screenshot each module of the running system with a caption explaining what data it processes and which user role interacts with it.
• Chapter 5 (Conclusion and Recommendations). Identify features that could be added in a Version 2, such as mobile app, REST API export, or AI-powered analytics.

Modules typical of How to Insert Multiple Image

• Master data. CRUD forms for the primary entities with search and filter.
• Transaction processing. Data entry forms for day-to-day operations the system automates.
• Reports. Formatted printable output summarizing activity per day, user, or category.
• User management. Login with role-based permissions (Admin, Encoder, Viewer).
• Backup and restore. Export database to a .sql file and restore when needed.

Common enhancements for capstone review

• Modernize the UI. Add Bootstrap 5 or Tailwind CSS for a polished appearance.
• Add printable receipts. Use TCPDF or FPDF to generate PDF reports.
• Multi-user concurrency. Ensure database handles simultaneous writes without lost-update errors.
• Rewrite in Laravel. Migrate to Laravel for maintainability and modern development patterns.

Related PHP Projects

• Image Editor In PHP With Source Code
• PHP Insert Multiple Records Into MySQL
• User Profile Update Profile Info Using Phpmysql
• Upload Show Image Using PHP MySQL
• Resize Upload Image PHP
• MySQL Insert Query

Inquiries

If you have any questions or suggestions about inserting multiple images in PHP MySQL. please feel free to contact me on our contact page.