Inserting and retrieving a blob data from mysql database using php
I am having great difficulty in displaying an image that I had already inserted into a database. Below is my two script code to help in inserting and displaying. While using google chrome as my browser, I end up getting a broken image icon, but when i just recently used firefox, i got the error message that the file contains error!
Please what could be the problem in this case?
This is my first script: uploadFile.php:
<?php
//Open a new connection to the MySQL server
$user="root";
$host="localhost";
$password="";
$database = "dynamic_data";
$cxn = mysqli_connect($host,$user,$password,$database);
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?><?php
@$name = $_FILES['file']['name'];
$extension = strtolower(substr($name, strpos($name, '.') + 1));
@$tmp_name = $_FILES['file']['tmp_name'];
@$type = $_FILES['file']['type'];
@$size = $_FILES['file']['size'];
$max_size = 74752;
if(isset($name)){
if(!empty($name)){
if(($extension == 'jpg' || $extension == 'jpeg')&& $type == 'image/jpeg' && $size <= $max_size){
// Image submitted by form. Open it for reading (mode "r")
$fp = fopen($_FILES['file']['tmp_name'], "r");
// If successful, read from the file pointer using the size of the file (in bytes) as the length.
if ($fp) {
$content = fread($fp, $_FILES['file']['size']);
fclose($fp);
// Add slashes to the content so that it will escape special characters.
// As pointed out, mysql_real_escape_string can be used here as well. Your choice.
$content = addslashes($content);
$content= mysqli_real_escape_string($cxn, $content);
$name= mysqli_real_escape_string($cxn, $name);
// Insert into the table "table" for column "image" with our binary string of data ("content")
mysqli_query($cxn,"INSERT INTO uploaded (file_id, name, type, size, image, email) Values('','$name','$type', '$size','$content','[email protected]')") or
die("Couldn't execute query in your database!".mysqli_error($cxn));
echo 'Data-File was inserted into the database!|';
echo '<a href="showImages.php?id=1">view</a>';
}
else{
echo 'There was an error!';
}
}
else{
echo 'File must be jpg/jpeg and must be 73 kilobyte or less! ';
}
}
else {
echo 'Please select a file!';
}
}
?>File upload
My second script to actually display the image is : showImages.php comes next
<?php
//Open a new connection to the MySQL server
$user="root";
$host="localhost";
$password="";
$database = "dynamic_data";
$cxn = mysqli_connect($host,$user,$password,$database);
// Check connection
if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
if (isset($_GET['id'])) {
$id= mysqli_real_escape_string($cxn, $_GET['id']);
$mysql_run=mysqli_query($cxn, "SELECT * FROM uploaded WHERE file_id ='$id';");
while ($row=mysqli_fetch_assoc($mysql_run)) {
header("Content-type: image/jpeg");
$name=$row['name'];
$type=$row['type'];
$size=$row['size'];
//header("Content-length: $size");
//header("Content-type: $type");
//header("Content-Disposition: attachment; filename=$name");
echo $image=$row['image'];
}
}
else {
echo 'Error!';
}
?>Please what could be possibly wrong?