Main image ko database me store karna chahta hun mujhe bataiye ki yeh kaise hoga
Image ko database mein store karne ke liye aapko nimnalikhit charanon ka palan karna hoga:
1. Image ko upload karne ke liye form banayein: Aapko ek HTML form banana hoga jismein image upload karne ke liye input field ho.
2. Image ko server par upload karein: Aapko image ko server par upload karne ke liye PHP ya kisi aur programming language ka upyog karna hoga.
3. Image ko database mein store karein: Aapko image ko database mein store karne ke liye SQL query ka upyog karna hoga.
Yeh ek udaharan hai PHP aur MySQL ka upyog karke image ko database mein store karne ka:
HTML Form
<form action="upload.php" method="post" enctype="multipart/form-data">
<input type="file" name="image">
<button type="submit">Upload</button>
</form>
PHP Code (upload.php)
<?php
$conn = mysqli_connect("localhost", "username", "password", "database_name");
if (!$conn) {
die("Connection failed: " . mysqli_connect_error());
}
$image = $_FILES['image']['tmp_name'];
$image_name = $_FILES['image']['name'];
$image_type = $_FILES['image']['type'];
$allowed_types = array('image/jpeg', 'image/png', 'image/gif');
if (in_array($image_type, $allowed_types)) {
$image_data = file_get_contents($image);
$image_data = base64_encode($image_data);
$sql = "INSERT INTO images (image_name, image_data) VALUES ('$image_name', '$image_data')";
mysqli_query($conn, $sql);
echo "Image uploaded successfully!";
} else {
echo "Invalid image type!";
}
mysqli_close($conn);
?>
MySQL Table
CREATE TABLE images (
id INT PRIMARY KEY AUTO_INCREMENT,
image_name VARCHAR(255),
image_data LONGBLOB
);
Yeh code image ko database mein store karta hai, lekin yeh dhyan rakhein ki yeh code sirf ek udaharan hai aur aapko apne project ke hisab se ismein badlaav karna pad sakta hai.
Adik jankari ke liye related post dekhen.
If you still have a question about this, submit it in our Q&A community - Ask Question