How can PHP be used to store file uploads in a database?

When storing file uploads in a database using PHP, you can follow these steps: 1. Receive the file upload using a form with enctype="multipart/form-data". 2. Process the uploaded file in PHP using $_FILES superglobal. 3. Store the file content in a database table with a BLOB (Binary Large Object) column. 

<?php
// Check if the form was submitted
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Get the file content
    $fileContent = file_get_contents($_FILES["file"]["tmp_name"]);

    // Connect to the database
    $conn = new mysqli("localhost", "username", "password", "database");

    // Prepare the SQL query
    $stmt = $conn->prepare("INSERT INTO files (file_content) VALUES (?)");
    $stmt->bind_param("s", $fileContent);

    // Execute the query
    $stmt->execute();

    // Close the statement and connection
    $stmt->close();
    $conn->close();

    echo "File uploaded successfully!";
}
?>

Keywords

PHP file uploads database storing functions

Related Questions