03-Apr-2023
.
Admin
Hello Friends,
I am going to explain you example of How to Upload Multiple Files and Store in MySQL Database PHP 8?. I would like to share with you How to Upload multiple files into Database in PHP 8/MySQLi. step by step explain File Upload in PHP 8 MySQL database. we will help you to give example of PHP 8 Multiple Files Upload in MySQL Database. follow bellow step for Multiple File Upload with PHP 8 And MySQL.
This article will give you simple example of PHP 8 Upload & Store File in MySQL Tutorial.
So, let's see bellow solution:
index.php
<!DOCTYPE html>
<html>
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1">
<title>How to Upload Multiple Files and Store in MySQL Database PHP 8?</title>
<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.1.3/dist/css/bootstrap.min.css" rel="stylesheet">
</head>
<body>
<?php
if (isset($_FILES['file'])) {
$dontallowedFileType = array('image/jpg','image/png','image/jpeg');
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "db_php";
$conn = mysqli_connect($servername, $username, $password, $dbname);
if (!$conn) {
die("connection failed:" .mysqli_connect_error());
echo "connection successfull";
}
$count = count($_FILES['file']['name']);
for ($i=0; $i <$count ; $i++) {
$file_name = $_FILES['file']['name'][$i];
$file_size = $_FILES['file']['size'][$i];
$file_tmp = $_FILES['file']['tmp_name'][$i];
$file_type = $_FILES['file']['type'][$i];
if(!in_array($file_type, $dontallowedFileType)){
if(move_uploaded_file($file_tmp ,"pathname/".$file_name)){
$sql="INSERT INTO files(file,type,size) VALUES('$file_name','$file_type','$file_size')";
if ($conn->query($sql)===TRUE) {
$msg = "<p class='alert alert-primary mb-0 p-2'>File inserted Successfully!</p>";
}else{
$msg = "<p class='alert alert-danger mb-0 p-2'>Error :".$sql."<br>".$conn->error."</p>";
}
}else{
$msg = "<p class='alert alert-danger mb-0 p-2'>File Was Not inserted!</p>";
}
}else{
$msg = "<p class='alert alert-danger mb-0 p-2'>please select valid file !</p>";
}
}
}
?>
<div class="container mt-5">
<div class="card">
<div class="card-header text-center bg-primary text-white">
<h3>How to Upload Multiple Files and Store in MySQL Database PHP 8? - Nicesnippets.com</h3>
</div>
<div class="card-body" style="height: 200px;">
<?php echo $msg; ?>
<form action="" method="post" enctype="multipart/form-data" >
<input type="file" name="file[]" multiple class="form-control mt-3">
<div class="d-flex justify-content-center">
<input type="submit" name="upload" class="btn btn-primary mt-5"></input>
</div>
</form>
</div>
</div>
</div>
</body>
</html>
Output:
It will help you...
#PHP 8