Skip to content

All topics  /  MySQL

PHP 8 File Upload in MySQL Database Example

MySQL ·

Teams applying “PHP 8 File Upload in MySQL Database Example” in a production project can use the product team's article to record implementation, review and debugging time, then compare that effort with tests and shipped functionality instead of treating activity as performance by itself.

Before copying the example into a live application, confirm version-specific behaviour with the official MySQL website and test it against the project’s actual database and runtime.

PHP 8 File Upload in MySQL Database Example

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/[email protected]/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...

More on this topic