Multiple Image Upload using PHP into MYSQL database
Today, We want to share with you Multiple Image Upload using PHP into MYSQL database.
In this post we will show you Multiple Image Upload using PHP into MYSQL database, hear for Multiple Image Upload using PHP into MYSQL database we will give you demo and example for implement.
In this post, we will learn about Multiple Image Upload using PHP into MYSQL database with an example.
i have This IMP POST explained about How to upload The multiple images or Files in the database(Like as a Mysql).
The Multiple all files or image can be uploaded using different name for HTML input.
enctype=”multipart/form-data”. type=” file”
upload multiple images in php example
Use
<form action="do_upload.php" method="post" enctype="multipart/form-data">
<input type="file" name="images[]" multiple="multiple" accept="image/*" />
<input type="submit" name="sub" value="Upload!" />
</form>
“Multiple Image Upload” using PHP into MYSQL database
File Structure
multiple_upload(Dir Name)
->upload(Dir Name)
->config.php
->index.php
->upload.php
DataBase Name : gallery_tbl
First of All Crate a Simple TABLE in Your DataBase.
Table Name : gallery
CREATE TABLE IF NOT EXISTS `gallery` ( `id` int(11) NOT NULL AUTO_INCREMENT, `image` varchar(250) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
File Name : Config.php
<?php
$db = new mysqli("localhost","root","mypass**","gallery_tbl");
// Check It My SQLi connection
if (mysqli_connect_errno())
{
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?>
File Name : index.php
<html>
<head><title>How to upload/store multiple images in mysql database in php</title></head>
<body>
<div style="margin:auto;width:900px;">
<div>
<form action="upload.php" method="post" enctype="multipart/form-data">
<input type="file" name="images[]" multiple="multiple" accept="image/*" />
<input type="submit" name="sub" value="Upload!" />
</form>
</div>
<?php
//include config.php where all configuration
include('config.php');
//execute select query for fetch database to images name
$sql = $db->query("SELECT * FROM gallery");
if(isset($sql) && count($sql)) : // check condition
foreach ($sql as $key => $row) : ?>
//print all display all images
<img class="circle" src="uploads/<?php echo $row['image']; ?>" />
<?php endforeach; endif; ?>
</div>
</body>
</html>
<style type="text/css">
.circle {
border: solid 1px #dedede;
width: 250px;
padding: 4px;
background-color: #fff;
border-radius: 70%;
-webkit-transition: -webkit-transform .8s ease-in-out;
transition: transform .8s ease-in-out;
}
.circle:hover {
-webkit-transform: rotate(360deg);
transform: rotate(360deg);
}
</style>
File Name : upload.php
<?php
include('config.php');
error_reporting(0);
//check condition for images upload or not
if(isset($_FILES['images']['name'])):
define ("MAX_SIZE","2000");
//all multiple images fetch using for loop
for($i=0; $i<count($_FILES['images']['name']); $i++) {
// check size for images
$size=filesize($_FILES['images']['tmp_name'][$i]);
//check condition for image size
if($size < (MAX_SIZE*1024)):
$path = "uploads/"; // upload directory file name
$name = $_FILES['images']['name'][$i]; // image name store
$size = $_FILES['images']['size'][$i]; // image size store
list($txt, $ext) = explode(".", $name);
date_default_timezone_set ("Asia/Calcutta");
$currentdate=date("d M Y");
$file= time().substr(str_replace(" ", "_", $txt), 0);
$info = pathinfo($file);
$filename = $file.".".$ext;// all images uploaded here
if(move_uploaded_file($_FILES['images']['tmp_name'][$i], $path.$filename)) :
$fetch=$db->query("INSERT INTO gallery(image) VALUES('$filename')");
if($fetch):
header('Location:index.php');
else :
$error ='your Data not inserting';
endif;
else :
$error = 'your File (All images) moving unsuccessful';
endif;
else:
$error = 'You have exceeded the File (some images or files)size limit!';
endif;
}
else:
$error = 'Your File not found!';
endif;
?>
We hope you get an idea about Multiple Image Upload using PHP into MYSQL database
We would like to have feedback on my Information blog .
Your valuable any feedback, Good question, Inspirational Quotes, or Motivational comments about this article are always welcome.
If you liked this post, Please don’t forget to share this as Well as Like FaceBook Page.
We hope This Post can help you…….Good Luck!.
I am Jaydeep Gondaliya , a software engineer, the founder and the person running Pakainfo. I’m a full-stack developer, entrepreneur and owner of Pakainfo.com. I live in India and I love to write tutorials and tips that can help to other artisan, a Passionate Blogger, who love to share the informative content on PHP, JavaScript, jQuery, Laravel, CodeIgniter, VueJS, AngularJS and Bootstrap from the early stage.