What is the recommended method for uploading images to a SQL database in PHP?

When uploading images to a SQL database in PHP, it is recommended to first store the image file on the server and then save the file path in the database. This approach helps in maintaining database performance and efficiency. To achieve this, you can use PHP's move_uploaded_file() function to save the image file on the server and then insert the file path into the database using SQL queries. 

<?php
// Check if the form was submitted
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Check if file was uploaded without errors
    if (isset($_FILES["image"]) && $_FILES["image"]["error"] == 0) {
        $target_dir = "uploads/";
        $target_file = $target_dir . basename($_FILES["image"]["name"]);
        
        // Move the uploaded file to the server
        if (move_uploaded_file($_FILES["image"]["tmp_name"], $target_file)) {
            // Insert the file path into the database
            $image_path = $target_file;
            $sql = "INSERT INTO images (image_path) VALUES ('$image_path')";
            // Execute the SQL query
            // $conn is the database connection object
            $conn->query($sql);
            echo "Image uploaded successfully.";
        } else {
            echo "Error uploading image.";
        }
    } else {
        echo "No image uploaded.";
    }
}
?>

Keywords

PHP image upload SQL database BLOB file handling

Related Questions