03-Apr-2023
.
Admin
Hello Friends,
Now, let's see post of PHP 8 File Upload in MySQL Database Example. I would like to share with you How to Upload File in Database using PHP 8?. This article will give you simple example of Upload and Store File in Database using PHP 8 and MySQL. In this article, we will implement a How to insert File in MySQL database using PHP 8?. Let's get started with How To Upload And Insert File Into Mysql Database Using PHP And Html.
I will give you simple example of How to upload Files into MySQL database using PHP 8.
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>PHP 8 File Upload in MySQL Database Example</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'])) {
$file_name = $_FILES['file']['name'];
$file_size = $_FILES['file']['size'];
$file_tmp = $_FILES['file']['tmp_name'];
$file_type = $_FILES['file']['type'];
$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";
}
$sql="INSERT INTO files(file,type,size) VALUES('$file_name','$file_type','$file_size')";
if ($conn->query($sql)===TRUE) {
echo " ";
}else{
$msg = "<h5 class='alert alert-primary'>Error :".$sql."<br>".$conn->error."</h5>";
}
if (move_uploaded_file($file_tmp ,"pathname/".$file_name)) {
$msg = "<h5 class='alert alert-primary'>File inserted Successfully!</h5>";
}else{
$msg = "<h5 class='alert alert-primary'>File Was Not inserted!</h5>";
}
}
?>
<div class="container mt-5">
<div class="card">
<div class="card-header text-center bg-primary text-white">
<h3>PHP 8 File Upload in MySQL Database Example -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" class="form-control" class="custom-input-file">
</div>
<div class="d-flex justify-content-center pb-5">
<input type="submit" name="upload" class="btn btn-primary"></input>
</form>
</div>
</div>
</div>
</body>
</html>
Output:
It will help you...
#PHP 8
