Tutorials
Uploading and Downloading Images to from MySQL database-php
Last modified: April 06, 2022You need to be able to run PHP Script on your computer and have MySQL database running. If you do not have them, you can view this tutorial.
Run the following SQL script on phpMyAdmin or MySQL Workbench to create a database and table.
if you do not have MySQL Workbennch, you can download if from
1. SQL
create DATABASE demo;
CREATE TABLE `Product` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`file` BLOB NOT NULL,
`filename` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
2. Jquery
For easier writing JavaScript, we use JQuery library, hence we import it on head section
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.min.js" integrity="sha512-894YE6QWD5I59HgZOGReFYm4dnWc1Qt5NtvYSaNcOP+u1T9qYdvdihz0PPSiiqn/+/3e7Jo4EaG7TubfWGUrMQ==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>
3. Upload HTML form
we need enctype="multipart/form-data" if we want to upload file
<form action="" method="post" enctype="multipart/form-data">
<input type="file" id="image" name="image">
<input type="submit" name = 'submitImage'>
</form>
4. dbconfig.php
Create a PHP called dbconfig.php and save it with following content.4
<?php
$dbHost = "localhost";
$dbUsername = "root";
$dbPassword = "";
$dbName = "demo";
$db = new mysqli($dbHost, $dbUsername, $dbPassword, $dbName);
if ($db->connect_error) {
die("Connection failed: " . $db->connect_error);
}
5. Upload PHP Code
<?php
include_once 'include/dbconfig.php';
// If form is submitted
if(isset($_POST['submitImage'])){
$data = file_get_contents($_FILES["image"]["tmp_name"]); //get the fike path
$filename=$_FILES['image']['name']; //get filename
// Insert form data in the database
$stmt = $db->prepare("INSERT INTO product (file, filename) VALUES (?, ?)");
$stmt->bind_param("ss", $data, $filename);
$insert= $stmt->execute();
$stmt->close();
}
?>
6. Display the table
.')
convert Blob data into JPG file
<?php
$sql = "SELECT * FROM product";
$result = $db->query($sql);
echo "<table>";
echo "<thead>";
echo " <tr>";
echo " <th>";
echo " <b>File Name</b>";
echo " <b>Image</b>";
echo " </th>";
echo " </tr>";
echo " </thead>";
echo " <tbody>";
if ($result){
while($row = mysqli_fetch_assoc($result)) {
echo " <tr>";
echo " <td>".$row['filename']."</td>";
echo '<td><img src="data:image/jpeg;base64,'.base64_encode($row['file']).'"/></td>';
echo " </tr>";
}
}
echo" </tbody>";
echo"</table>";
?>
7 Test
