What is the best practice for uploading images and storing their links in a database using PHP?

When uploading images and storing their links in a database using PHP, it is best practice to first move the uploaded image to a designated folder on your server and then store the file path or URL in the database. This ensures that the images are properly organized and easily accessible when needed. 

<?php
// Check if the form was submitted
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    // Define the folder where the images will be stored
    $target_dir = "uploads/";
    
    // Get the file name and create a unique name for it
    $target_file = $target_dir . uniqid() . '_' . basename($_FILES["image"]["name"]);
    
    // Move the uploaded file to the designated folder
    if (move_uploaded_file($_FILES["image"]["tmp_name"], $target_file)) {
        // Store the file path or URL in the database
        $image_url = $target_file;
        
        // Insert $image_url into your database table using SQL query
        // Example: $sql = "INSERT INTO images (image_url) VALUES ('$image_url')";
    } else {
        echo "Sorry, there was an error uploading your file.";
    }
}
?>

Keywords

file upload image storage database PHP link retrieval

Related Questions