What are the best practices for storing images in a database using PHP?

Storing images in a database using PHP can be inefficient and slow down the database performance. It is recommended to store images in a file system and only store the file path in the database. This way, the database remains lightweight and the images can be easily accessed when needed. 

// Example code to store image in file system and save file path in database

// Upload image file to server
$target_dir = "uploads/";
$target_file = $target_dir . basename($_FILES["fileToUpload"]["name"]);
move_uploaded_file($_FILES["fileToUpload"]["tmp_name"], $target_file);

// Save file path in database
$image_path = $target_file;
$query = "INSERT INTO images (image_path) VALUES ('$image_path')";
$result = mysqli_query($connection, $query);

Keywords

file upload image processing database storage blob data type SQL injection

Related Questions