Inserting and displaying images in MySQL using PHP

Posted on July 7, 2010 by Vikas Mahajan

Well working with images is quite easy task in MySQL using php code. Some years back managing images in relational database is quite complex task as at those times relational databases are able to store only textual data so file path to the images are stored in database and images are stored and retrieved externally. Also special file functions are necessary for retrieving images this way and this approach is system dependent (because of path names used). Nowadays, almost all major DBMS support storing of images directly in database by storing images in the form of binary data. Here, I am explaining the method of storing and retrieving images in MySQL database using PHP code.

Inserting images in mysql-:

MySQL has a blob data type which can used to store binary data. A blob is a collection of binary data stored as a single entity in a database management system. Blobs are typically images, audio or other multimedia blob objects. MySQL has four BLOB types:

TINYBLOB
BLOB
MEDIUMBLOB
LONGBLOB

All these types differ only in their sizes.

For my demonstration, lets us create a test table named test_image in MySQL having 3 columns show below-:

Id (INT) -Act as primary key for table.
Name (VARCHAR) – Used to store image name.
Image (BLOB) – Used to store actual image data.

You can use phpMyAdmin tool to create the above table else use the following MySQL query-:

create table test_image (
id              int(10)  not null AUTO_INCREMENT PRIMARY KEY,
name            varchar(25) not null default '',
image           blob        not null
 );

PHP code to upload image and store in database-:

To upload the image file from client to server and then store image in MySQL database on server, I am posting here the PHP code for our test/sample table (test_image).

Please change the values of variables in file_constants.php file according to your system. Save the following scripts with names as shown in your web directory.

file_constants.php

<?php
$host="your_hostname";
$user="your_databaseuser";
$pass="your_database_password";
$db="database_name_to_use";
?>

file_insert.php

<html>
<head><title>File Insert</title></head>
<body>
<h3>Please Choose a File and click Submit</h3>

<form enctype="multipart/form-data" action=
"<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<input type="hidden" name="MAX_FILE_SIZE" value="10000000" />
<input name="userfile" type="file" />
<input type="submit" value="Submit" />
</form>

<?php

// check if a file was submitted
if(!isset($_FILES['userfile']))
{
    echo '<p>Please select a file</p>';
}
else
{
    try {
    $msg= upload();  //this will upload your image
    echo $msg;  //Message showing success or failure.
    }
    catch(Exception $e) {
    echo $e->getMessage();
    echo 'Sorry, could not upload file';
    }
}

// the upload function

function upload() {
    include "file_constants.php";
    $maxsize = 10000000; //set to approx 10 MB

    //check associated error code
    if($_FILES['userfile']['error']==UPLOAD_ERR_OK) {

        //check whether file is uploaded with HTTP POST
        if(is_uploaded_file($_FILES['userfile']['tmp_name'])) {    

            //checks size of uploaded image on server side
            if( $_FILES['userfile']['size'] < $maxsize) {  
  
               //checks whether uploaded file is of image type
              //if(strpos(mime_content_type($_FILES['userfile']['tmp_name']),"image")===0) {
                 $finfo = finfo_open(FILEINFO_MIME_TYPE);
                if(strpos(finfo_file($finfo, $_FILES['userfile']['tmp_name']),"image")===0) {    

                    // prepare the image for insertion
                    $imgData =addslashes (file_get_contents($_FILES['userfile']['tmp_name']));

                    // put the image in the db...
                    // database connection
                    mysql_connect($host, $user, $pass) OR DIE (mysql_error());

                    // select the db
                    mysql_select_db ($db) OR DIE ("Unable to select db".mysql_error());

                    // our sql query
                    $sql = "INSERT INTO test_image
                    (image, name)
                    VALUES
                    ('{$imgData}', '{$_FILES['userfile']['name']}');";

                    // insert the image
                    mysql_query($sql) or die("Error in Query: " . mysql_error());
                    $msg='<p>Image successfully saved in database with id ='. mysql_insert_id().' </p>';
                }
                else
                    $msg="<p>Uploaded file is not an image.</p>";
            }
             else {
                // if the file is not less than the maximum allowed, print an error
                $msg='<div>File exceeds the Maximum File limit</div>
                <div>Maximum File limit is '.$maxsize.' bytes</div>
                <div>File '.$_FILES['userfile']['name'].' is '.$_FILES['userfile']['size'].
                ' bytes</div><hr />';
                }
        }
        else
            $msg="File not uploaded successfully.";

    }
    else {
        $msg= file_upload_error_message($_FILES['userfile']['error']);
    }
    return $msg;
}

// Function to return error message based on error code

function file_upload_error_message($error_code) {
    switch ($error_code) {
        case UPLOAD_ERR_INI_SIZE:
            return 'The uploaded file exceeds the upload_max_filesize directive in php.ini';
        case UPLOAD_ERR_FORM_SIZE:
            return 'The uploaded file exceeds the MAX_FILE_SIZE directive that was specified in the HTML form';
        case UPLOAD_ERR_PARTIAL:
            return 'The uploaded file was only partially uploaded';
        case UPLOAD_ERR_NO_FILE:
            return 'No file was uploaded';
        case UPLOAD_ERR_NO_TMP_DIR:
            return 'Missing a temporary folder';
        case UPLOAD_ERR_CANT_WRITE:
            return 'Failed to write file to disk';
        case UPLOAD_ERR_EXTENSION:
            return 'File upload stopped by extension';
        default:
            return 'Unknown upload error';
    }
}
?>
</body>
</html>

Below is screenshot of above web page when executed by browser-:

With this you will be able to upload and store images in MySQL database. Also check for the presence of file in the database using phpMyAdmin or any other tool.

Displaying images stored in MySQL-:

Now we are in a position to write PHP code to see images stored by the above script. For that firstly save the script below with name file_display.php in your web directory.

file_display.php

<?php
 include "file_constants.php";
 // just so we know it is broken
 error_reporting(E_ALL);
 // some basic sanity checks
 if(isset($_GET['id']) && is_numeric($_GET['id'])) {
     //connect to the db
     $link = mysql_connect("$host", "$user", "$pass")
     or die("Could not connect: " . mysql_error());

     // select our database
     mysql_select_db("$db") or die(mysql_error());

     // get the image from the db
     $sql = "SELECT image FROM test_image WHERE id=" .$_GET['id'] . ";";

     // the result of the query
     $result = mysql_query("$sql") or die("Invalid query: " . mysql_error());

     // set the header for the image
     header("Content-type: image/jpeg");
     echo mysql_result($result, 0);

     // close the db link
     mysql_close($link);
 }
 else {
     echo 'Please use a real id number';
 }
?>

Now you can see the images stored in the database using the following query string-:

http://{path_to_your_web_directory}/file_display.php?id=1

You will see image which is stored in database corresponding to id having value “1” . You can use different numbers to see different images. Below is a sample screenshot-:

189 thoughts on “Inserting and displaying images in MySQL using PHP”

prasanth on January 13, 2011 at 1:20 PM said:

im a beginner in php…i have tried out the above script, but i was not able to view the image…how should i use the above query (http://{path_to_your_web_directory}/file_display.php/?id=1;) for retrieving the image

Reply ↓
- Vikas Mahajan on January 14, 2011 at 8:45 PM said:
  
  “http://{path_to_your_web_directory}/file_display.php/?id=1”
  This is not any query. This is address of the path where you copied file_display.php file. For example if you copied it in document root of web browser which is /var/www in most cases (if you installed web server using binaries), then the address on your local pc is
  “http://localhost/file_display.php/?id=1”
  Please tell me if still you are not getting the image displayed.
  
  Reply ↓
  - Mamta on April 27, 2012 at 1:35 PM said:
    
    $finfo = finfo_open(FILEINFO_MIME_TYPE)
    
    u write this code in the file_insert.php . but dont specify related file related to this.
- Vikas Mahajan on January 14, 2011 at 9:02 PM said:
  
  I think you had misunderstood the word “query string” in the post.
  Query string does not means any SQL query but it means any Url which sends data from client to server. In this case url is sending id from client to server.
  
  Reply ↓
Dilip on January 19, 2011 at 7:25 PM said:

Hello Sir! i hav a problem while displaying the images back from mysqldb along with html code…i want to confine its height and width using the …every time i use any of html my screen goes blank…here’s a sample code of a script i’m using to display the picture..

showimage.php

it works fine but when i add some html to it the screen just goes blank and doesn’t show any error too…i.e.

It will be a great help of yours!
Thanks in Advance!

Reply ↓
- Vikas Mahajan on January 19, 2011 at 9:40 PM said:
  
  You wrote “i want to confine its height and width using the …every time i use any of html my screen goes blank”.
  You can’t you HTML on the link/page which is generating image from database as resultant page is initialised using header(“Content-type: image/jpeg”) tag and it deletes all HTML elements on the current page before displaying file. Due to this reason you are seeing blank page.
  If you want to use HTML with image then correct way is to use HTML <img> tag with source to query string or anchor tag <a> with href as query string to make a target link of image.
  Examples:-
  <td><a href=file_display.php?id=1>Target link</a></td<
  or
  <td><img src=file_display.php?id=1 width=100 height=100></td>
  If still you are not able to do what you want then email me your source file as I am not able to find your code in your comment. My email id is vikas.mahajan12@gmail.com
  
  Reply ↓
Dilip on January 19, 2011 at 10:52 PM said:

Thanks Sir It Worked! I have also got another method, to save the image files on to the local hard disk and then accessing them as required…! Which one u think i go for i’m designing a Alumni website with some social networking features and a forum!

Reply ↓
- Vikas Mahajan on January 19, 2011 at 11:08 PM said:
  
  Ok. Yes I know about the second method. Actually the method to use for a particular web application depends upon the type and size of that application. If your application is large i.e you have to display a large number/size of images repeatedly then you should go for second method (storing only image path in database and actual images on filesystem). This will reduce the processing time to display images moreover consumes less resources. Secondly, if your application/no. of images/size of images is small then you can store them directly in database using method described in the post. This way it becomes easy to take backups and port application to another OS.
  
  Reply ↓
Dilip on January 20, 2011 at 10:37 AM said:

It is really helpful info…thnks! 🙂

Reply ↓
Ganesh Shrestha on February 11, 2011 at 12:42 PM said:

first of all thanks for the code. I tried and it worked, now i want help from you.Cant i resize the image or user it inside the table as a background or apply any sort of operation with it. Currentlly the image is displayed in its full size.Now i want to resize.
I would be grateful to you if you send me the technique to perform the action mentioned above.

sincerely
Ganesh Shrestha.

Reply ↓
- Vikas Mahajan on February 11, 2011 at 3:09 PM said:
  
  You can do any sort of operation with the generated image. You can save it, use it in table with specified width or height etc.
  Please refer to the previous comment (in reply to Dilip’s comment) in which I had explained the method to use image inside table cell. After that if you need any help feel free to ask me 🙂
  
  Reply ↓
- shruti s kittur on March 1, 2012 at 1:04 PM said:
  
  Its shruti kittur from bvb college hubli, i need code to insert and display image from mysql database using php,please mail me that code as soon as possible.I am doing my M.C.A final year project,so i need that code so kindly help me by sending code for these two
  
  Reply ↓
Emeka on February 26, 2011 at 9:48 PM said:

Hello Vikas, I quite appreciate your tutorial. My problem is that the image has to be submitted in a form containing other information like name, date of birth, etc. How can i submit image and other form data together to my database and then display the image and other form data using a search query. My database is expected to hold information of about 300 persons. Only image required is their passport. Thanks for ur help.

Reply ↓
- Vikas Mahajan on February 28, 2011 at 4:35 PM said:
  
  Hello Emeka, thanks for your appreciation.
  For submitting other data along with image, change the code given in file_insert.php (see above for code). You can add your custom form elements to represent other data inside the form created there. Then change the upload function to save the data from your form elements in the database. Basically, you have to change queries in the upload function. You can also add some error checking code if you want.
  For displaying data alongwith other fields read previous comments where you will find way to show resultant image inside table cell or way to create a link to your image.
  Try out and share your problem/experience.
  
  Reply ↓
vladan on February 28, 2011 at 10:37 PM said:

Hello Vikas, I have a question for you, if you could help me…
I am just a beginner in mysql, and php(for now:).. I have stored my files for website in a BLOB field (mysql), some images from gallery, and I don’t know how to download them from database to hard disk.. Is there any phpMyAdmin option, or some other way to do it?
Thank you in advance!
Vladan

Reply ↓
- Vikas Mahajan on March 1, 2011 at 6:33 PM said:
  
  Hello Vladan, welcome to the world of opensource(specially php and mysql). I far as I understood your problem, you want to save image data in database into real images on filesystem. You can use “PHP GD and image functions” to do this task easily. Mostly you need function imagecreatefromstring() to create image resource from blob data and another function like imagejpeg() or imagepng() to save image resource in format you want. I am showing here code to save images in JPEG format. For that edit file_display.php file, comment lines which output image to browser and add following code after mysql query statement:-
  
  $image = imagecreatefromstring(mysql_result($result, 0));
  if ($image !== false) {
  imagejpeg($image,$_GET[‘id’].”.jpg”,94);
  imagedestroy($image);
  echo “Image Successfully saved with name “.$_GET[‘id’].”.jpg”;
  }
  else {
  echo “Can’t create image of this id.”;
  }
  
  I think from above code you got a basic idea on how you can accomplish your task 🙂
  
  Reply ↓
- Vikas Mahajan on March 1, 2011 at 6:48 PM said:
  
  And don’t forgot to use meaningful names while saving images which corresponds to the entry of that image in database. Also you can modify mysql query and use php loops to save all the database images to filesystem at once.
  
  Reply ↓
Ganesh Shrestha on March 8, 2011 at 2:45 PM said:

sir,

thanks for the code. It became very helpful to me. Now what i want is to display the image contained in the database. And also other features related to database and the images.

thank you.

Reply ↓
- Vikas Mahajan on March 8, 2011 at 5:49 PM said:
  
  Hello Ganesh,
  Thanks for your appreciation. To just display image which is in database you need to customize the display.php file according to your database table structure. And you can display generated image in any format you want just like normal images. Read carefully previous comments, you can get lot of help from them.
  
  Reply ↓
Ganesh Shrestha on March 8, 2011 at 2:46 PM said:

sir and also the second method you were talking above.

thank you.

Reply ↓
- Vikas Mahajan on March 8, 2011 at 6:01 PM said:
  
  In second method, you can just save the image name or image path (corresponding to the table row) in the database and actual images are placed in some folder. Even you can migrate from one method to another. For example- If you want to use second method for your blob images, you can convert and save them in some folder. Give meaningful name to the image being saved and then save that name or its relative path in the corresponding row of database (for referring back and using images). Then you can delete the blob images from the database. Again read previous comments for code to save image in JPEG extension and for comparisons of both methods.
  
  Reply ↓
sijo on March 19, 2011 at 8:55 PM said:

this article is more helpful , i am serch many days for how to insert image into mysql , now i get the idea for it , thank u very much

Reply ↓
micah david on March 22, 2011 at 5:29 PM said:

your site is the best, alot of questions have been answered through your site. please help me with connecting my site to my database. i have tried so many ways and it couldn’t work.

Reply ↓
- Vikas Mahajan on March 22, 2011 at 6:20 PM said:
  
  Thanks for your appreciation. Detail you are giving is too less for anyone to understand the problem. Please explain in detail about what you are trying to do, what errors you are facing and about the softwares you are using like web server, database, os etc.
  
  Reply ↓
Garima Bhadviya on March 31, 2011 at 3:05 PM said:

On using the above code with the html syntax as i have to display image as well as other fields…I get

Warning: Cannot modify header information – headers already sent by (output started at C:\wamp\caplacement\admin\employee\view_all_employee.php:9) in C:\wamp\caplacement\admin\employee\view_all_employee.php on line 13

Please resolve this error and give an example in which name of the person,his photo n some other information is displayed

Reply ↓
- Vikas Mahajan on March 31, 2011 at 11:51 PM said:
```
Warning: Cannot modify header information
```
  This warning may occurs because you are sending something to output before the execution of header statement or your script already sends headers to web page. You need to take care that your script do not output anything (even a single space) prior to header statement as header must be sent before the body of web page. See following links for additional help to solve this problem:-
  
  http://www.tech-recipes.com/rx/1489/solve-php-error-cannot-modify-header-information-headers-already-sent/
  
  http://www.geeklog.net/faqman/index.php?op=view&t=38
  
  So, to display picture along with other HTML elements, make separate HTML or php file for all information to be displayed and use display.php file inside table cell with img or achor tag and define other information in other table cells. See previous comments for more information.:)
  Reply ↓
  - Satish Chaudhary on November 16, 2011 at 11:06 AM said:
    
    i have faced also same problem
    because i have left one line to header
    so thanks for help
kamal on April 6, 2011 at 11:09 PM said:

thanku sir….
code is really working …
but it is working only for a single image..
plz sir tell what are the changes should i made in the above code so that i can retrive “MORE THAN ONE IMAGES” from the data base…..

Reply ↓
- Vikas Mahajan on April 7, 2011 at 8:03 PM said:
  
  Code given here is for demonstration. Retrieving an image from database in nothing more than retrieving a single field value from database. So, to retrieve more images at once change the SQL query to fetch more images (Eg-: change condition to id < 10 ) then use PHP loop to repeatedly show images in different HTML table cells. Also, refer to previous comments. You will get a lot of help from them 🙂
  
  Reply ↓
kamal on April 8, 2011 at 9:45 PM said:

Thanku sir..
i tried to retrive the images through a loop but this tym it is showing a very strange results.
in place of images page is showing some strange characters like this..
“7%%77777777777777777777777777777777777777777777777777ÿÀ^–”ÿÄÿÄ9!1Qa”Aq2‘¡#BR$3b±ÁÑS²ðñÿÄÿÄ”!A1Q2aqÿÚ?©ûÊì•3f¥é eµxRx-]z æLBµ¥$“ä¦6Q¤6¤`:XmîO’IÃiùÔF£˜ÐðVAsÝÚÅ&=±¼:Z!ù”}isa®ñŒéÑZðqZ3ƒþ±NáæˆÑÄýjeÊH¤-¶ÙòýÊÇ¶ëL6U³³1—¼j6T· ÉYP×’5ô-¾ÎXáô–¦¡°w€Á è”

m not getting any solution for this….
so kindly plz help….
my code is…

<?php
// connect to mysql server
$link = mysql_connect('localhost', 'root');
if (!$link) {
die('Not connected : ' . mysql_error());
}
// connect to database server
$db_selected = mysql_select_db('image', $link);

if (!$db_selected) {
die ('Database error : ' . mysql_error());
}

$sql = "SELECT * FROM image";

// the result of the query
$result = mysql_query($sql) or die("Invalid query: " . mysql_error());
while($row = mysql_fetch_assoc($result)){
echo "ID: ".$row['sid'].", Name:".$row['title']
.", image:".$row['img']."”;

}
?>

thnks
regards..

Reply ↓
- Vikas Mahajan on April 14, 2011 at 8:38 PM said:
  
  Hi,
  You can’t display images like this. Database returns image data in binary form. This is the reason that you are getting strange characters. To display image you need to use header element of HTML. So, solution is that keep display.php file separate (without any loop) and create another file to select image id’s to be displayed then pass these id’s one by one to display.php file (inside the loop). Output data which display.php file returns for each image in separate table cell using img HTML tag.
  I think this much detail is enough. If still you are getting any problem feel free to ask !!!
  
  Reply ↓
AARABI MADHAVAN on April 14, 2011 at 7:26 PM said:

this is the table i have created in the database
mysql> CREATE TABLE tbl_images (
> id tinyint(3) unsigned NOT NULL auto_increment,
> image blob NOT NULL,
> PRIMARY KEY (id)
> );
and this the php code to retrieve it..

BUT THE PROBLEM is that instead of displaying the image it just prints out the url once again!!!
example : the output is ::: the same url
PLEASE HELP !!!
URGENT
http://localhost/proj/trial/ret.php?id=1

Reply ↓
- Vikas Mahajan on April 14, 2011 at 8:29 PM said:
  
  Hi,
  I think image data in not getting saved in database. In most of the cases, when you are seeing the url instead of image that means database is not returning image data. So, check your code to insert image in database and verify that images are successfully getting saved. Also, check the query you are using to get display data.
  
  Reply ↓
AARABI MADHAVAN on April 14, 2011 at 9:53 PM said:

this is my code for inserting into mysql.

0)
{

$tmpName = $_FILES[‘image’][‘tmp_name’];
echo “$tmpName”;
$fp = fopen($tmpName, ‘r’);
$data = fread($fp, filesize($tmpName));
$data = addslashes($data);
fclose($fp);
$query = “INSERT INTO tbl_images”;
$query .= “(image) VALUES (‘$data’)”;
$results = mysql_query($query, $link) or die(“could not upload”. mysql_error());
echo “done?!!!!!!!!”;
}
else
{
echo “nothing”;
}
?>

i have sent u an attachment by mail..plz chk..

Reply ↓
AARABI MADHAVAN on April 14, 2011 at 10:25 PM said:

sent all files by mail.

Reply ↓
- Vikas Mahajan on April 15, 2011 at 9:29 AM said:
  
  Hi,
  I study your ret.php file and got the error which you are doing. The
  problem was that you are sending output to browser prior setting the
  header of HTML page. Actually, you need to take care that your script
  is not sending any output before setting header of page. Even a single
  space outside php tags can cause this problem 😦
  I hope this solves your problem.
  
  Reply ↓
AARABI MADHAVAN on April 15, 2011 at 9:43 AM said:

oh yes!!!!!!!!!!!! that was the problem !!!!
thank you so much!!
hi 5!

Reply ↓
Dave on April 23, 2011 at 4:12 AM said:

I have not been able to successfully insert and then display images to and from mysql until trying your code. It works beautifully! Thank you! I should note that I had to change a setting in mysql settings, my.ini, changing max_allowed_packet = 1M to max_allowed_packet = 10M since the image files I was testing with were larger than 1M in size. Anyway, thanks again; I now have something I can build upon.

Reply ↓
- Vikas Mahajan on April 23, 2011 at 9:07 AM said:
  
  In addition, if you are working with large images use LONGBLOB field to store images else only a portion of image is stored in database.
  
  Reply ↓
Abhyshek on May 4, 2011 at 12:21 PM said:

Hi,

I am trying to display an image from the image path stored in database. The problem is the image isn’t getting displayed. Pl. help me. Thanks.

Reply ↓
- Vikas Mahajan on May 4, 2011 at 1:21 PM said:
  
  If the images are stored in file system, then problem may be in path you are giving to retrieve the image or it may be permission issue.
  So, see the complete path you are using to fetch image using php echo statement and see if the image actually exists on this path.
  If your path is correct then verify whether web server have read permission on images or not. If not give necessary permissions.
  
  Reply ↓
  - Abhyshek on May 5, 2011 at 2:13 AM said:
    
    Hi Vikas,
    
    Thanks for your inputs. I verified and is the problem with the path. I rectified my mistake and mentioned the path as “http://localhost/mypics/pic1.jpg” for the image pic1 lying under the mypics folder of the www directory in the WAMP. Thanks for your help. Your’s is a cool site!
Beni on May 7, 2011 at 10:55 AM said:

Hi here is my php code for insert the image in database.
Now i want to store the imaze in small size in the folder when we load the image in uploaded file.
plz tell me how i can store the small size in image folder.
thnxs
0)
{
echo “Return Code: ” . $_FILES[“file”][“error”] . “”;
}
else
{
echo “Upload: ” . $_FILES[“file”][“name”] . “”;
echo “Type: ” . $_FILES[“file”][“type”] . “”;
echo “Size: ” . ($_FILES[“file”][“size”] / 1024) . ” Kb”;
echo “Temp file: ” . $_FILES[“file”][“tmp_name”] . “”;
$new_path=$path. $_FILES[“file”][“name”];
if (file_exists($new_path))
{
echo $_FILES[“file”][“name”] . ” already exists. “;
}
else
{
move_uploaded_file($_FILES[“file”][“tmp_name”],$new_path);
echo “Stored in: ” . $new_path;
}
}

$sql =”INSERT INTO gallery (id, name, caption, status, images) VALUES (NULL, ‘$name’, ‘$caption’, ‘$status’, ‘$new_path’)”;

mysql_query($sql);
header(‘location:index.php’);
}

?>

Image Upload

Name

Caption

Status

Upload Image

Reply ↓
- Vikas Mahajan on May 10, 2011 at 7:32 PM said:
  
  Hi,
  If you just want to store image in separate folder on server (when user uploads the image), you need not to insert image in database. Just rename the image from tmp_name to something useful and store it in your directory of choice using php filesystem functions.
  To process image (i.e. reduce size) use imagemagick convert command or some other utility of your choice.
  Finally, if you want to store images in database to some folder then read previous comments (in response to vladan). You will get a lot of help from them.
  
  Reply ↓
Hafiz on May 9, 2011 at 6:15 PM said:

Hai Vikas,

I have a problem of UPDATE an image into database.. It will UPDATE the images when id=0, but will not UPDATE if its other than 0. In ‘function upload’ I just put ‘function upload($id)’ since need to UPDATE into database.
If I put ‘function upload($id=4)’ it will only UPDATE image that has an ID = 4. The question is, How can I UPDATE image trough different ID??
example code are like below..

function upload($id)
{
include “constants.php”;
$maxsize = $_POST[‘MAX_FILE_SIZE’];
if(is_uploaded_file($_FILES[‘userfile’][‘tmp_name’]))
{

if( $_FILES[‘userfile’][‘size’] < $maxsize)
{
$imgData =addslashes (file_get_contents($_FILES['userfile']['tmp_name']));
mysql_connect($host, $user, $pass) OR DIE (mysql_error());
mysql_select_db ($db) OR DIE ("Unable to select db".mysql_error());

$sql = 'UPDATE user SET ';
$sql .= 'name = "'.($_FILES['userfile']['name']).'",';
$sql .= 'image = "'.($imgData).'" ';
$sql .= 'WHERE id = "'.$id.'";';
mysql_query($sql) or die("Error in Query: " . mysql_error());
}
}
else
{

echo
'File exceeds the Maximum File limit
Maximum File limit is ‘.$maxsize.’
File ‘.$_FILES[‘userfile’][‘name’].’ is ‘.$_FILES[‘userfile’][‘size’].
‘ bytes
‘;
}
}

Reply ↓
- Vikas Mahajan on May 10, 2011 at 7:16 PM said:
  
  You are doing right. You need to pass id of corresponding image to update. Mechanism to pass id will depend upon your application. For example:- You can give a field to enter id in the image upload form or you can pass the id of image displayed to upload function (displayed in some form or other) to change it.
  About your code, I must say use php echo statement to see the correctness of SQL query and see if the id your are giving is correctively passed or not.
  
  Reply ↓
  - Hafiz on May 11, 2011 at 1:42 AM said:
    
    I have try an input id that will display the id of the image
    <input type="text" name="id" value="”/>
    
    But still cannot work and if I change the value it will remain the same. What do you mean by “pass the id of image displayed to upload function “?? is it “function upload($id)”? if it so I try to change to “function upload($id = 2)”, it will only change id=2. How do I change other than 2? without changing the function upload id to other numbers??
Vikas Mahajan on May 11, 2011 at 8:33 AM said:

Hi,
Are you copying the id passed by the form into PHP $id variable?
If not add this line before calling the upload($id) function (in file_insert.php file):-
$id = $_POST[‘id’];
I can’t help too much with this much of information. Try to remove error and if still you are not able to get your code work then send your code files to my email id (vikas.mahajan12@gmail.com) so that I can debug them.

Reply ↓
- Hafiz on May 11, 2011 at 6:03 PM said:
  
  Inserting $id = $_POST[‘id’]; is the solution.. Thank you very much.. 🙂 as you motto says “Life and Computers are Simple, Lets don’t Complicate them” 😀
  
  Reply ↓
sasi on May 12, 2011 at 12:52 PM said:

hey

its really working. thanku thanku for this coding.

Reply ↓
ashish kumar rena on May 13, 2011 at 2:08 PM said:

thanks big bro …… thank for your code ….. helps a lot…….

Reply ↓
sem on May 23, 2011 at 3:13 PM said:

hi, the upload is ok but when i try the download part this is what it returns:

also using “header(“Content-type: image/jpeg”);” in the middle of the code causes problem. can you please help me?

Reply ↓
- Vikas Mahajan on May 25, 2011 at 8:44 AM said:
  
  Hi,
  Problem is with the header of HTML page. You can’t use header(“Content-type: image/jpeg”); in the middle of file because once you write anything (outputs any character) its header is automatically set to text and once header is set you can’t change it. So, check your file and remove any output before header statement (even tabs and spaces are not allowed).
  
  Reply ↓
  - priya on March 5, 2012 at 3:14 PM said:
    
    hi sir i am priya i am engineering student
    i doing project of website creation for digital studio
    i put coding for storing and displaying image i use BLOB for storing the image when display
    usin coding
    mysql_fetch($sql)
    {
    echo “.row[image].”;
    echo “.row[name].”;
    echo “.row[changes].”;
    }
    
    but text fields are displayed correctly in but image is displayed as some other strange character
- Vikas Mahajan on March 6, 2012 at 6:45 PM said:
  
  Hi Priya,
  
  Answer to your question is already given in previous comment. To display image with other form data use HTML tables. You can’t display image with other data in top level body of because its header is already set to text/html. That is why you seeing strange characters because browser is displaying image binary data as text.
  
  Reply ↓
sawan on May 24, 2011 at 6:38 PM said:

Hello Vikas,
thanks for code, its actually working fine. and i am new in php programming. i have a problem, i were saving a image name in db and image save with actual name in specified folder. now what? i want to display all images which names stored in database with resize. i know how to display single image but i don’t know how to resize? please help me…

Reply ↓
- Vikas Mahajan on May 25, 2011 at 8:37 AM said:
  
  Hello,
  Use HTML img tag and give width and height according to your need. If you want to resize original image then use PHP GD library for this task. Read previous comments for details.
  
  Reply ↓
sanam on May 26, 2011 at 12:09 AM said:

Hi, Vikas I am trying to use your code to store and retrieve image from database but whenever I upload any image, there is a message” s Thank you for submitting” . I checked in code, I am not sending any echo message “s” before “Thank you for submitting” and also whenever I tried to retrieve image there is a message” sPlease use a real id number”. Would you please help me, how could I fix this problem.

Sanam Maharjan

Reply ↓
- Vikas Mahajan on May 26, 2011 at 6:47 PM said:
  
  Hi Sanam,
  You have to pass valid id corresponding to the image you want to see while retrieving the image as shown below:
  http://path_to_your_web_directory/file_display.php?id=1
  Check id from database and replace last “1” with your id.
  
  Reply ↓
Aj on June 19, 2011 at 4:41 PM said:

hey thanks for the script
i am happy that now i can proceed ahead in my project work

Reply ↓
reenez on June 24, 2011 at 11:39 PM said:

thanx vikas for the code

Reply ↓
- reenez on June 24, 2011 at 11:51 PM said:
  
  It worked for so many although am getting back the same url with the id number
  i tried the solution above but i think i don’t know how to implement it. i have emailed you my diplay and insert scripts and hope that your can’t help me clean it and verify the problem. Am axiously waiting for your reply. reenez
  
  Reply ↓
Caleb on July 1, 2011 at 1:14 AM said:

Thank you very much for this. I do have a question though. A bit of an explination first. I wanted the user to be able to view the picture after upload, so I added a link in the file_insert html section for the user to click on to view the file. Lets say that the file didn’t get uploaded. where would I implement the error code if there was no file. As of right now, my
link displays no error, just the file path for the image. I am also new to PHP, but understand what’s going on in the code, but don’t see the problem. I know there is no image uploaded yet, but would like an error for just in case a file didn’t get uploaded.

Reply ↓
- Caleb on July 1, 2011 at 1:16 AM said:
  
  I guess I should have typed the link different. the link I have in my code is the “a href=filepath…… that was posted earlier in the comments.
  
  Reply ↓
  - Vikas Mahajan on July 2, 2011 at 2:50 PM said:
    
    Hi Caleb,
    Most of the error code must be in upload function. I edited the file_insert.php file to include some error code to handle most of the common errors. See the modified code, you can add additional code according to your requirement. About displaying image, give link to user on successful image upload. Now you can see id of uploaded file after successful upload. Just convert that message to HTML link.
Ratheesh R on August 9, 2011 at 3:46 PM said:

hii

Brother I used your code for uploading an Image . But When I run the program I can select an Image to Upload but when I submit the form I got the following Warning .

Fatal error: Call to undefined function finfo_open() in /var/www/imageupload/file_insert.php on line 47

function finfo_open is not working for me . Please help me to overcome this

Thank you.

Reply ↓
- Vikas Mahajan on August 10, 2011 at 9:43 AM said:
  
  Hi,
  It seems you PHP installation does not have FileInfo module installed. So, upgrade your php to latest version and after that if the module still not works then install it manually.
  
  Reply ↓
chandra shekhar on August 19, 2011 at 11:45 PM said:

Dear Sir,
When i choose the image,the following error are accrued –

Fatal error: Call to undefined function finfo_open() in C:\wamp\www\music\file_insert.php on line 47

Plz tell me a solution.

Reply ↓
- Vikas Mahajan on August 25, 2011 at 9:50 AM said:
  
  Hi,
  You need to install FileInfo module for your Php installation. Google about it, you will get a lot of results. May be this link helps you:-
  http://www.sitepoint.com/forums/php-34/cannot-access-fileinfo-extension-680522.html
  
  Reply ↓
OPEYEMI TOSIN on August 24, 2011 at 9:40 PM said:

Hello Vikas
I found this site very use for me.
Please check out my code to upload a passport and to display it, it does display locally but not on the internet and i don’t know why. i have tried all i could but no success.
Here is the code

if(isset($_POST[‘Submit’])){
if(($_FILES[‘pic’][‘tmp_name’]==””) || (!ereg(‘image’,$_FILES[‘pic’][‘type’])) || ($_FILES[‘pic’][‘size’]>50000))
{
$message=”Please you have to upload your passport in the format specified”;
//header(“location:.php?message=$message”);
}
else
{
$temp_name=$_FILES[‘pic’][‘tmp_name’];
$destination=”Pics_File/”.$_FILES[‘pic’][‘name’];
move_uploaded_file($temp_name,$destination) or die(‘The Upload is not successful, Please try again’);
$image_name=$_FILES[‘pic’][‘name’];
include(“connection.php”);
$sqlimage=”INSERT INTO utme_images (temp_name, image_name) VALUES (‘$temp_name’,’$image_name’)”;
$sqlquery=mysql_query($sqlimage) or die(mysql_error());
$image_id=mysql_insert_id();
$sql=”SELECT * FROM utme_images where image_id=’$image_id'”;
$qry=mysql_query($sql) or die (mysql_error());
if($rw=mysql_fetch_array($qry))
{
$imag=$rw[“temp_name”];
}

Reply ↓
- Vikas Mahajan on August 25, 2011 at 10:19 AM said:
  
  Hi,
  You have not posted the complete code. The code to display image is missing. Of the code posted, I must say that don’t move the image with $_FILES[‘pic’][‘name’] as name of saved file as users may upload images with same name. So, use some unique identifier as name of image (such as id of sql query, md5 identifier or temp_name may be). And if you are saving image with original name then $imag=$rw[“temp_name”] should be $imag=$rw[“image_name”] to fetch image. Try out and see what happens, if you still faces problems then email me your code.
  
  Reply ↓
marl on August 29, 2011 at 7:21 PM said:

hello vikas, there is a slight problem regarding the codes above, when i press submit button i get this fatal error:

Fatal error: Call to undefined function finfo_open() in C:\xampp\htdocs\imageupload\file_insert.php on line 50

what is the problem there?
thx sir

Reply ↓
- Vikas Mahajan on September 2, 2011 at 11:43 PM said:
  
  Hello,
  FileInfo module is required for the finfo_open() function. Install this module for your PHP installation.
  
  Reply ↓
  - reyna roslan on March 18, 2012 at 2:41 PM said:
    
    how to install the module for PHP installation..
abdallah on September 2, 2011 at 11:30 PM said:

hello

i was try it but there an error
” Fatal error: Call to undefined function finfo_open() in C:\AppServ\www\test_image\file_insert.php on line 47 ” and i don’t no what shroud i do ? please help me

Thank you

Reply ↓
- Vikas Mahajan on September 2, 2011 at 11:44 PM said:
  
  Hello,
  Please read above comment.
  
  Reply ↓
ankur on September 5, 2011 at 2:28 PM said:

HEY VIKAS MAHAJAN….. ITS VERY USEFULL INFO NOW I AM ABLE TO INSERT IMAGES IN MYSQL BUT THERE IS DOUBT IN DISPLAYING IT… IS THERE ANY OTHER SIMPLE METHOOD……..

Reply ↓
- Vikas Mahajan on September 5, 2011 at 2:36 PM said:
  
  Hi,
  What doubt do you have regarding displaying images?
  Simpler and faster method is to save only path in database and save images in local folder.
  
  Reply ↓
mini on September 11, 2011 at 12:52 PM said:

! ) Fatal error: Call to undefined function finfo_open() in C:\wamp\www\mini_image\file_insert.php on line 47
Call Stack
# Time Memory Function Location
1 0.0017 394800 {main}( ) ..\file_insert.php:0
2 0.0017 394800 upload( ) ..\file_insert.php:23
this is the error please help me

Reply ↓
- Vikas Mahajan on September 11, 2011 at 1:08 PM said:
  
  Install FileInfo module for your PHP installation. finfo_open() function requires this module.
  
  Reply ↓
mini on September 11, 2011 at 1:49 PM said:

i am using wampserver in window 7 i cann’t found the module for this so what i can do?

Reply ↓
Vikas Mahajan on September 11, 2011 at 3:15 PM said:

See following links:-
http://www.sitepoint.com/forums/php-34/cannot-access-fileinfo-extension-680522.html
http://www.php.net/manual/en/fileinfo.installation.php
Also, search Internet for more results.

Reply ↓
Rahul M. on September 12, 2011 at 1:28 PM said:

I’ve made a table in mysql called testimonials where I saved client’s testimonials and their photo in same table. But at the time of retrieving the images with their testimonials I’m unable to do that. I want to display pictures with the testimonial content on a page called testimonials. Everything is working at my end except images are not displaying with each testimonial. Is there anyone can help me out. Its kind of urgent for me.

Reply ↓
- Vikas Mahajan on September 12, 2011 at 2:18 PM said:
  
  Nobody can help you unless he/she doesn’t knows the cause of your problem. So, explain problem you are facidng in detail (any error you are getting). I advice you to firstly try to display only images (see post for code) and later on display both text and images on same page by using html tables (read other comments).
  
  Reply ↓
mini on September 13, 2011 at 1:59 PM said:

( ! ) Warning: finfo_file() expects at least 2 parameters, 1 given in C:\wamp\www\mini_image\file_insert.php on line 47
Call Stack
# Time Memory Function Location
1 0.0021 395968 {main}( ) ..\file_insert.php:0
2 0.0021 395968 upload( ) ..\file_insert.php:23
3 0.0031 396832 finfo_file ( ) ..\file_insert.php:47

( ! ) Warning: finfo_file() expects parameter 1 to be resource, boolean given in C:\wamp\www\mini_image\file_insert.php on line 50
Call Stack
# Time Memory Function Location
1 0.0021 395968 {main}( ) ..\file_insert.php:0
2 0.0021 395968 upload( ) ..\file_insert.php:23
3 0.0038 397040 finfo_file ( ) ..\file_insert.php:50

Uploaded file is not an image.
after installing i got this problem please help me

Reply ↓
- Vikas Mahajan on September 15, 2011 at 3:24 PM said:
  
  Use following code after finfo_open() function to see are you able to get fileinfo resource:
  if (!$finfo) {
  echo “Opening fileinfo failed”;
  exit();
  }
  If $finfo resource is correctly returned then see mime type of uploaded file with:
  echo finfo_file($finfo, $_FILES[‘userfile’][‘tmp_name’]);
  
  Reply ↓
mini on September 13, 2011 at 2:17 PM said:

in some case
The uploaded file exceeds the upload_max_filesize directive php.ini
this error will be apper

Reply ↓
- Vikas Mahajan on September 15, 2011 at 3:32 PM said:
  
  To store large images, use longblob data type, also change following directives in php.ini file:
  post_max_size
  upload_max_filesize
  Restart, apache server for changes to be effective.
  
  Reply ↓
Peter on September 15, 2011 at 1:42 PM said:

Nice article. I also found on more artcle. http://electrofriends.com/qna/php-mysql/upload-image-database-phpmysql/

May be useful for someone

Reply ↓
Amara on September 18, 2011 at 2:12 AM said:

Hi,
i did try ur code given at the site and others codes as well to show images from database.Bt i m facing a similar problem that my images r being stored in Db bt not showing,only the path is displayed on it and no error???
please do help as soon as possible

Reply ↓
- Vikas Mahajan on September 18, 2011 at 9:06 AM said:
  
  Hi,
  There may be many reasons for showing only path instead of image. See below for some reasons:
  1. Incorrect Id. Be sure that you are using correct Id when retrieving the image (which you get upon submitting it using code given).
  2. Image not uploaded successful. Be sure your image data gets saved in database. Use echo statement in display.php for debugging purpose to display image data (comment header statement to verify this). See are you getting a lot of chars as output.
  3. If second step is successful, then restore display.php to normal. Be sure to exactly copy the code of this file. Even a single extra space is harmful and will not let you to see image. Reason is that no output should be sent to web server prior setting header for displaying image, else header is automatically set by web server to text/html and you will not be able to see image.
  I think trying these steps will solve your problem 🙂
  
  Reply ↓
Dinesh Saini on October 15, 2011 at 6:11 PM said:

The image “http://localhost/dinesh/php-code/img-upload.php” cannot be displayed because it contains errors.

Sir,I am getting this error for displaying images on my page..Please tell me the solution for this…

Reply ↓
Vikas on October 20, 2011 at 10:06 PM said:

Hi Sir, Your tutorial is really helpful for my project . Actually I am working on a project where I need to store the pages of a book in sql database and then wanna retrieve. As per your tutorial we can retrieve by manually changing the (?id=x) .Is there any way where I click on a link suppose (Maths Book) and this should start retrieving the images from the id=1 and giving me an option like next button on which I click and post id changes to id=2 and so on..

Regards
vikas

Reply ↓
- Vikas Mahajan on November 4, 2011 at 11:02 AM said:
  
  Hi,
  You question is off-topic. You can achieve what you want to do easily by using JavaScript or Ajax at front-end. Simple fetch images say (1 to 10) on initial request using php limits. Display them one by one as user selects using JavaScript (that reduces delay than retrieving images one by one). Also provide user next button with which next images (10 in this case) are downloaded from server again and so on.
  
  Reply ↓
Hani on October 25, 2011 at 4:04 PM said:

Hello Sir, Please help with this 😦 I have tried many thing but i could not figure out how to do it. I will explain my web (code) then show you what I could not do.
I have three pages in my web. The first page has a description of graphical password and ask user for information such as email, age, country, gender. By click on button (called register), a php page will be opened to 1- store the previous information in the database and 2- to show a grid of pictures 10 by 10 which is already stored in the database.***** THE USER SHOULD BE ABLE TO SELECT 4 PICTURES AND EACH SELECTED PICTURE ONCE THE USER CLICK ON IT, SHOULD BE APPEAR IN A RAW UNDER OR ABOVE THIS 10 BY 10 PICTURES. AS SOON AS THE USER SELECT 4 PICTURES, A BUTTON CALLED (DONE) WILL BE ACTIVATED AND ABLE TO BE CLICKED****. If it is clicked, another php page will be opened to store the paths of 4 pictures the user selected during the registration the database. Also, to show thank you message for participating.

I have succeed in doing first page and store its information in the database. Also I managed to show the grid of pictures using their paths stored in the database. The thing that I could not done is above between ***
I think I have to deal with onclick function and do some AJAX or Javascript. The point is I do not know how to do it.

Here is my code to show the grid of pictures using their paths stored in the database. If you tell me what to add to make these pictures selectable and able to send what the user selected to the database, this will be very helpful.

Thank you in advance

<?php

//This gets all the other information from the form
$country=$_POST['Country'];
$age=$_POST['Age'];
$gender=$_POST['gender'];
$email=$_POST['email'];

// Connects to your Database

$con = mysql_connect("localhost","root", "root");
if (!$con)
{
die('Could not connect: ' . mysql_error());
}

mysql_select_db("ImagesOfNationalCultures", $con);

//Writes the information to the database

$query1 = "INSERT INTO Users (email, gender, age, country) VALUES ('$email','$gender','$age','$country')";

$query2 = "SELECT * from Images ORDER BY RAND()";
mysql_query($query1,$con);

$result = mysql_query($query2,$con);
$i = 0;
$max_columns = 10;
echo "”;
while ($query_row=mysql_fetch_array($result)){

// open row if counter is zero
if($i == 0)
echo “”;
echo “”;

//Display the pictures (WHAT TO DO HERE TO MAKE IT SELECTABLE AND SHOW WHAT HAS BEEN SELECTED SOMEWHERE IN THE SAME PAGE BESIDE BUTTON TO BE CLICKED TO SEND THESE SELECTED PICTURES PATHS BACK TO THE DATABASE ?)

echo ”;
echo “”;

// increment counter – if counter = max columns, reset counter and close row
if(++$i == $max_columns)
{
echo “”;
$i=0;
} // end if
} // end while
echo “”;

?>

Reply ↓
- Vikas Mahajan on November 4, 2011 at 10:49 AM said:
  
  Hi,
  
  Your comment is slightly off-topic so I can’t help you much. But I can give you slight hint. When the user selects the image you can store its identifier in JavaScript array and at the end whem submit button is clicked converts that array values into a single string (delimited by some character) and pass them to server by setting that string to some hidden form field. Thats one simple possible solution.
  
  Reply ↓
Hani on October 25, 2011 at 4:44 PM said:

By the way, I would like the picture itself to be selected NOT to include check box beside each picture in the set.

Many thanks again

Reply ↓
Scott Snider on November 4, 2011 at 2:11 AM said:

Hi,

I’ve been able to successfully insert images into a table and then display them, but I was just trying to transfer images from one table into another and haven’t been able to figure it out. Do you know how to do that?

Reply ↓
- Vikas Mahajan on November 4, 2011 at 10:24 AM said:
  
  Hi,
  Images are being stored in database as binary data. They don’t need any special method to transfer to another table.You can use normal queries to copy them to another table.
  
  Reply ↓
  - Scott Snider on November 4, 2011 at 12:00 PM said:
    
    Ya, I finally figured out I just needed to addslashes again after I retrieved the image before I could insert it into another table. Thanks.
  - Vikas Mahajan on November 4, 2011 at 12:04 PM said:
    
    Good,
    You are right, addslashes is for one time only. It doesn’t add anything into database just escape characters to safely add them.
Derrick on November 16, 2011 at 9:55 AM said:

Hi Mr Vikas
i have been looking all over the web for these useful php codes but found them here i only encounter a single problem whenever i try to submit and it looks like this
Fatal error: Call to undefined function finfo_open() in C:\xampp\htdocs\kia\file_insert.php on line 47
iam trying to design a website for my company but i still face another css problem whenever i try to minimize a window elements overlap other elements i’ve tried dispay:block; but it still fails can you help me out
Thanks in advance

Reply ↓
- Vikas Mahajan on November 22, 2011 at 10:20 AM said:
  
  Hi,
  Install FileInfo module of php. finfo_open() function is present in that module.
  
  Reply ↓
Satish Chaudhary on November 16, 2011 at 11:25 AM said:

Hi Sir i can display picture at another page as you describe in above example. Sir but i want to display picture in same page where i insert image or other page included html element and php scripts but face error like modify header so pls help
thanks Sir.

Reply ↓
- Vikas Mahajan on November 22, 2011 at 10:22 AM said:
  
  Hi,
  Use HTML tables for this. See other comments for details.
  
  Reply ↓
Gforuce on November 22, 2011 at 6:13 AM said:

Hello,

I have problem when uploading the image…
when i try to upload the image…

it says like this

“The image “http://localhost/up/getImage.php?=1″ cannot be displayed because it contains errors.”

I do understand and I assume that there is nothing wrong with the uploading code because..
when i try to cut the header… it will echo unknown binary characters.. therefore that this code is correct and it can talk to mysql….

So .. what is actually the problem here??

Reply ↓
- Vikas Mahajan on November 22, 2011 at 10:33 AM said:
  
  Hi,
  Be sure that you are not sending any output (not even space or newline outside php tags) before setting header of webpage. Alternatively, try to display image inside html table cell. If you are successful in doing that then problem is in header of webpage that means webpage got output before setting header mime type. Also, use longblob to store if image of large size (in megabytes).
  
  Reply ↓
avishek shah on November 22, 2011 at 8:55 AM said:

hello vikas ji,
i have created form to insert image in mysqldatabase which i got success. the code goes like this

File:

now the problem is i’m unable to display the images, it does diaply in binay form. ths code goes like this:

<?php
ini_set('display_errors',1);
//error reporting(E_ALL);
//connecing database
$conn=mysql_connect("localhost","root","");
if(!$conn)
{
echo mysql_error();
}
$db=mysql_select_db("newsbank",$conn);
if(!$db)
{
echo mysql_error();
}
// Grab the data from our people table

$q="SELECT image FROM imagebank";
$r=mysql_query("$q",$conn);
if($r)
{
while($row=mysql_fetch_array($r))
{
//echo $row['id'];
//echo"”;
//echo $row[‘name’];
//echo””;
header(“Content-type: image/jpeg”);
echo $row[‘image’];
//echo””;
}
}
else
{
echo mysql_error();
}
?>

Please help me out, i have to a submit as project.

Hoping of your prompt response.

Reply ↓
- Vikas Mahajan on November 22, 2011 at 10:13 AM said:
  
  Hi,
  The reason for seeing binary characters may be because of incorrect header of webpage. Don’t output anything on webpage before setting header. Even a single space outside php tags can result to this. Also, this way you can only display one image (and nothing else) in a page. So to display more images and other data with images use html tables and dispaly image inside table cell.
  
  Reply ↓
  - avishek shah on November 23, 2011 at 7:46 AM said:
    
    dear sir,
    i applied your above code to display the BLOB type image from my database, it worked after i entered id one after another. now i want to get it displayed in tabulated form. Please help me out. E-mail: u2avishek@yahoo.com.
    
    Thanking your, sir.
    
    sincerely
Azim on November 25, 2011 at 4:49 PM said:

Hi,
I have problem while access data form DB.
Data type is BLOG and in that field .txt file is uploaded.
How can i access that txt file.
Thank You.

Reply ↓
- Vikas Mahajan on November 28, 2011 at 10:02 AM said:
  
  Just retrieve data in that field. If you have encoded it, then decode it before printing it. You can also explicitly declare headers to be of text/plain type by this php statement:-
  header(“Content-type: text/plain”);
  I hope this will help you.
  
  Reply ↓
  - Azim on December 1, 2011 at 11:52 AM said:
    
    Ok
    Thank You so much
Blaine Anderson on November 30, 2011 at 1:54 PM said:

First of all, let me say thank you for your wonderful tutorial, I’ve learned a lot so far; however, I’m having an issue.

The issue I’m having is with an error message regarding the $file_open() function. I have looked for a number of solutions, but haven’t found any. The error I get is:

Fatal error: Class ‘finfo’ not found in C:\xampp\htdocs\test\file_insert.php on line 50

I am running PHP 5.3.8 and can’t get the file to call the function. Any advice?

Reply ↓
- Vikas Mahajan on January 5, 2012 at 3:17 PM said:
  
  Install FileInfo module which is used here to check mime-type of uploaded file else edit code of file_insert.php to use mime_content_type function to check mime-type. See this link for details:-
  http://php.net/manual/en/function.mime-content-type.php
  
  Reply ↓
bronze16 on December 16, 2011 at 5:02 PM said:

Thank u for this tutorial can anybody in the forum give an php approach on how can I upload image and save it direct to the database.. I was doing a school project on card cataloguing system.. “The situation is this: If input all information about the books in the form I need to upload also an image of the book browse it and select and then save it.. ” How can I do this..? Please help me

Reply ↓
Mohamed on December 23, 2011 at 3:42 AM said:

Hello Sr i try the code and it work with me in uploading bt when i’m trying to display it it give me this msg

Please use a real id number .. how to solve it plz

Reply ↓
- Vikas Mahajan on January 5, 2012 at 3:15 PM said:
  
  Use id which you got upon successfully uploading image to display it. Replace “xx” by id while displaying using url below:-
  http://path_to_your_web_directory/file_display.php?id=xx
  
  Reply ↓
ted chimwaga on January 3, 2012 at 7:36 PM said:

Fatal error: Call to undefined function finfo_open() in C:\wamp\www\example\file_insert.php on line 47
hi this is the error displayed when am running the codes

Reply ↓
- Vikas Mahajan on January 5, 2012 at 3:12 PM said:
  
  Install FileInfo module which is used here to check mime-type of uploaded file else use mime_content_type function to check mime-type. See this link for details:-
  http://php.net/manual/en/function.mime-content-type.php
  
  Reply ↓
ian on January 5, 2012 at 2:10 PM said:

sir.. how is this work ($finfo = finfo_open(FILEINFO_MIME_TYPE);)?

Reply ↓
- Vikas Mahajan on January 5, 2012 at 3:06 PM said:
  
  Hi,
  This returns fileinfo object which is used to check mime-type of uploaded image. But you need to enable/install FileInfo module if not already done.
  
  Reply ↓
- Vikas Mahajan on January 5, 2012 at 3:09 PM said:
  
  If you are unable to install FileInfo module then you can use deprecated mime_content_type function to check mime-type. See this link for details:-
  http://php.net/manual/en/function.mime-content-type.php
  
  Reply ↓
  - Ashraf ali on January 19, 2012 at 12:47 PM said:
    
    hello sir,
    i have a problem with my image show…
    actually i use an ajax popup form to show my images in a galleriffic view.. i can easy show them,but my problem is that,i have multiple images and i want to show this ajaxpopup to all of them via there id.. which is fetched from tha data base…
  - Shyam Sunder on March 9, 2012 at 2:39 PM said:
    
    Hello sir i want to display multiple image from mysql to single php page but it can’t i’m sending u all files through em mail plz check it my emailid is-shyambca123@gmail.com
ian on January 8, 2012 at 5:22 PM said:

sir?

Reply ↓
gowtham on January 9, 2012 at 12:15 AM said:

Sir i read the above comments and i really dont know how to install finfo_open() module. I am using PHP MY DAmin and using xampp server. could you terll the steps as i ma getting the error

Fatal error: Call to undefined function finfo_open() in F:\xampp\htdocs\xampp\db\images\file_insert.php on line 47

Reply ↓
haleem on January 10, 2012 at 9:05 PM said:

pls when I executed the code…file_insert.php I got an error. The error is this “fatal error: call to undefined function finfo_open() in c:\wamp\www\practice\file_insert.php on line 47. Pls I need help on the error, because I am new to php and mysql

Reply ↓
haleem on January 10, 2012 at 9:48 PM said:

thanks…I am able to rectify the finfo problem….I enabled it in php extension option of my wamp server…..yea…it is inserting..thanks plenty

Reply ↓
shruti s kittur on March 2, 2012 at 1:25 PM said:

hello vikas,
insert code is working properly now and yes i can open mysql through phpmyadmin,but display image is not working.The error is that:Whenever am running “displayimage” file without taking any input from me only its saying use a real id. So can u tell me what modification i should do.

Reply ↓
- shruti s kittur on March 2, 2012 at 1:31 PM said:
  
  hello vikas,
  Thanks alot for ur suggestion on insert code.It worked
  
  Reply ↓
Shyam Sunder on March 4, 2012 at 2:47 PM said:

Hello sir i’m shyam, sir i want to display all the images in php page from mysql, code is also correct but it does not resturn any value, plz help me i have to submit the project within 10 days. I hope that u will sol ve it my code is

Untitled Document

am sending u also by mail

Reply ↓
Shyam Sunder on March 4, 2012 at 2:53 PM said:

Hello sir, sir i want to display all the images but it does not return any image in php page am using wamp server,it returns blank white page plz help me i hate to submit project within 10 days, code is following

Reply ↓
shruti s kittur on March 6, 2012 at 1:39 PM said:

Hello vikas,

Its shruti i executed display image file from think out of box, but its saying PLEASE USE REAL ID ,could u please tell me where i may have gone wrong.I tried all possible way that i can,but ‘m not getting output.Please kindly reply soon
,

Reply ↓
Shyam Sunder on March 8, 2012 at 10:34 AM said:

Hello sir, I’m want to display multiple image from mysql to php page in single php page but only one image is displayed , plz help me by giving some code , Thanks in advance.

Reply ↓
Shyam Sunder on March 8, 2012 at 6:21 PM said:

Thanks sir, I’m shyam your suggestion is working properly thanks for helping me

Reply ↓
deepu on March 19, 2012 at 10:09 PM said:

hello vikas,
im gettin this error when i submit a image could u help me with this

Fatal error: Call to undefined function finfo_open() in I:\xampp\htdocs\deeya\file_insert.php on line 48

Reply ↓
deepu on March 19, 2012 at 10:14 PM said:

u hav given a link to check out dont no exactly what to do as im new to php could u help out with dis

Reply ↓
- Vikas Mahajan on March 26, 2012 at 9:21 AM said:
  
  Hi,
  Hi,
  
  “To use finfo_open() function you need to install FileInfo module of Php”. If you don’t want or was unable to install this module use can another inbuilt php function “mime_content_type()” to check Mime-type. I updated the code and added the line which uses this function. This line is commented in code. So, to use it uncomment the next line after comment
  “//checks whether uploaded file is of image type” and comment the next two lines following that line. I think this will solve your problem.
  Please tell if you have any doubts or need help.
  
  Thanks,
  Vikas
  
  Reply ↓
  - KOUSIK DAS on May 2, 2012 at 12:03 PM said:
    
    i cant find mime_content_type() in php.ini file. please help me
awessome on March 24, 2012 at 8:18 AM said:

Hello!
I am trying to use the image uploading code to upload and image to my database but it is showing this error:

( ! ) Fatal error: Call to undefined function finfo_open() in C:\wamp\www\upload.php on line 48
Call Stack
# Time Memory Function Location
1 0.0025 706816 {main}( ) ..\upload.php:0
2 0.0025 706816 upload( ) ..\upload.php:24

I understand that the function finfo_open() is not defined that is why it is giving this error but I am not sure of how to debug and proceed! Please help me out!

Reply ↓
- Vikas Mahajan on March 26, 2012 at 9:14 AM said:
  
  Hi,
  As I commented before in number of comments, “To use finfo_open() function you need to install FileInfo module of Php”. If you don’t want or was unable to install this module use can another inbuilt php function “mime_content_type()” to check Mime-type. I updated the code and added the line which uses this function. This line is commented in code. So, to use it uncomment the next line after comment
  “//checks whether uploaded file is of image type” and comment the next two lines following that line. I think this will solve your problem.
  Please tell if you have any doubts or need help.
  
  Thanks,
  Vikas
  
  Reply ↓
Luka Timothy on March 24, 2012 at 11:33 PM said:

i tried using the code but it is not working, pls help me?

Reply ↓
- Vikas Mahajan on March 26, 2012 at 9:19 AM said:
  
  Please give more detailed information about the problem you are facing like error you are getting? os/platform you are using?
  
  Reply ↓
F on March 27, 2012 at 7:26 PM said:

wen i insert the image i get a disgusting error message like this
Fatal error: Call to undefined function finfo_open() in C:\wamp\www\image\file_insert.php on line 49

wats te prob tell pliz

Reply ↓
Pravin Kottawar on March 29, 2012 at 3:40 PM said:

I tried to run the code using wamp server on local host its giving following error
Fatal error: Call to undefined function finfo_open() in C:\wamp\www\image-exp\file_insert.php on line 49
if u can , plz solve it ty

Reply ↓
mathsfreak on March 30, 2012 at 8:58 PM said:

Hi,
Is it possible to use your codes for videos as well? Or do you have any ways to view images as though as they are viewed in videos?

Reply ↓
- Vikas Mahajan on April 26, 2012 at 11:03 AM said:
  
  Hi,
  You can use this code to upload/save videos in database because blob is binary type so you can store any type of data in it. For playing videos, you have to see at some other logic based on method adopted like HTML5 or flash.
  
  Reply ↓
fysisoft on April 2, 2012 at 11:32 PM said:

Thanks a lot for such nice tip

Reply ↓
brunda on April 5, 2012 at 11:21 AM said:

hi i just had a small doubt i dnt know how to write the code for image uploading in php and that image has to be inserted on database

Reply ↓
brunda on April 5, 2012 at 11:22 AM said:

please help me out in writing the code

Reply ↓
Ayuba on April 20, 2012 at 2:13 PM said:

Hi. For you guys having issues with finfo_open() function especially those using XAMPP and WAMP; do this:
Simply edit your php.ini file and uncomment finfo_open.

Ayuba

Reply ↓
Pono on April 26, 2012 at 3:49 AM said:

hello sir… i am sort of new to php scripting and i have being trying to display images from my database using the following code
<?php
mysql_connect("localhost","root","")or die('Connection not established');
mysql_select_db("test")or die('Database not connected');

// Grab the data from our people table
$sql = "select * from tbl_images";

$result = mysql_query($sql) or die ("Could not access DB: " . mysql_error());

$imgLocation = " /uploadfile/";

while ($row = mysql_fetch_array($result))
{
$imgName ="image" ;
$imgPath = $imgLocation . $imgName;

echo "”;
echo $row[‘id’] . ” ” . $imgName. “”;

}
?>
all iam getting is this and no real images displayed and sometimes i get some funny characters:

14 image

15 image

16 image

17 image
with no real images displayed can you help me to have the right syntax for displaying real images and not some funny characters…thank you

Reply ↓
- Vikas Mahajan on April 26, 2012 at 10:57 AM said:
  
  Hi,
  Seems like images are stored on filesystem and not in database in your case. If this is the case get image name from database, append it after image path and display image using IMG HTML tag.
  
  Reply ↓
KOUSIK DAS on May 2, 2012 at 10:33 AM said:

sir m unable to upload image. when ever i click submit button give a fatal error. the error show like this—-(Fatal error: Call to undefined function finfo_open() in C:\xampp\htdocs\imageupload\file_insert.php on line 49) .

Reply ↓
- Vikas Mahajan on May 17, 2012 at 10:18 AM said:
  
  Please see other comments. You just need to uncomment 1 line and comment 2 lines.
  
  Reply ↓
belachew on May 11, 2012 at 7:04 AM said:

my sir ,i tried to use your php code to insert image and display it on my web page. But,i couldn’t insert image with this code.
Here is the problem “Fatal error: Call to undefined function finfo_open() in C:\Program Files\xampp\htdocs\rightupload\file_insert.php on line 37”. please help me.

Reply ↓
- Vikas Mahajan on May 17, 2012 at 10:16 AM said:
  
  Hi,
  To use finfo_open() function you need to install FileInfo module of Php. If you were unable to install this module use can another inbuilt php function “mime_content_type()” to check Mime-type. To use it uncomment the next line after comment
  “//checks whether uploaded file is of image type” and comment the next two lines following that line. I think this will solve your problem.
  Please tell if you have any doubts or need help.
  
  Thanks,
  Vikas
  
  Reply ↓
RAVI on May 15, 2012 at 3:40 PM said:

Hi Vikas!
Your coding is nice!!
I have problem “Please use a real id number” when running file_display.php. What does it mean? How can I resolve it. Please reply as soon as possible. I am waiting. Thanks!!

Reply ↓
- Vikas Mahajan on May 17, 2012 at 10:23 AM said:
  
  Hi,
  As mentioned in post, to display a particular image you need to pass id of already inserted image as GET request in url like:-
  http://path_to_your_web_directory/file_display.php?id=x
  Replace x with id of image to be displayed.
  
  Thanks,
  Vikas
  
  Reply ↓
suraj on May 17, 2012 at 1:47 AM said:

Hello Sir,
Thanks for the code I try this and it’s executing well. But I have some sort of problems I also wanna store some more information from user like date of birth, name etc…. And I am using the code::
$name = $_POST[‘name’];
$dob = $_POST[‘dob’];
in your image coding in upload function but it’s displaying some warning message in include “file_constants.php”; and two notices undefined index in $name = $_POST[‘name’];
$dob = $_POST[‘dob’];
And one error in Query: Column count doesn’t match value count at row 1.. I tried a lot to fix this problem but still fail.. Please Sir help me to get out of this problem..

Reply ↓
- Vikas Mahajan on May 17, 2012 at 10:31 AM said:
  
  Hi,
  Your corresponding form elements should have exact names which you are using in $_POST like “name” and “dob”. To make sure whether you are getting other values or not, you can output whole $_POST variable by using “vardump($_POST);”.
  I can’t comment further without source code. Share your source if you will not be able to solve the problem.
  
  Reply ↓
  - suraj on May 18, 2012 at 5:07 PM said:
    
    thank sir it worked….
Ska on May 17, 2012 at 11:09 AM said:

hello sir.,
what should i do in this error?:
(Fatal error: Call to undefined function finfo_open() in C:\xampp\htdocs\file_insert.php on line 55 )
please help me..

Reply ↓
- Vikas Mahajan on May 17, 2012 at 11:15 AM said:
  
  There are already a lot of comments on this error. So, Please read some other recent comments.
  
  Reply ↓
suraj on May 21, 2012 at 12:48 PM said:

Hello again sir,
I tried the php code to display an image provided by you but there are two warning message with file_constants.php.. And displaying message “please use real id number” instead taking id number from user… I checked the code myself and try to fix the problem but I fail. Please help me with this…..

Reply ↓
suraj on May 21, 2012 at 11:03 PM said:

Hello Sir,
I am trying to display an image in the thumbnail form from my database and on clicking those thumbnails full image should be displayed. My php code is::

$query = mysql_query(“SELECT `imgURL` FROM `images` ORDER BY `imgDate` DESC”) or die(mysql_error());
if(!$query) {
echo “Cannot retrieve information from database.”;
} else {
while($row = mysql_fetch_assoc($query)) {
echo ” “;
}
}

But it not executing well and images are not displayed in the thumbnail please help me with this….

Reply ↓
- Azim on June 15, 2012 at 9:26 AM said:
  
  $query = mysql_query(“SELECT `imgURL` FROM `images` ORDER BY `imgDate` DESC”) or die(mysql_error());
  if(!$query) {
  echo “Cannot retrieve information from database.”;
  } else {
  echo “”;
  $count =0;
  while($row = mysql_fetch_assoc($query)) {
  if($count==0)
  {
  echo “”;
  }
  echo ”
  
  “;
  if($count==2)
  {
  echo “”;
  $count=0;
  }
  else
  {
  
  $count++;
  }
  
  }
  echo “”;
  }
  
  Reply ↓
sumit on May 22, 2012 at 12:15 PM said:

nice post ..how we can fix the dimension of images….?

Reply ↓
Filter on May 26, 2012 at 7:28 PM said:

Hi,
nice tutorial and seems like support on different errors is great. Personally i had to use “mime_content_type” function to get it work. I can upload and display jpg, gif extensions, but still can not upload png : “uploaded file is not an image”.
Any suggestion on that? i would prefer using png type. Php version is 5.2.9 btw.

best regards and thanks

Reply ↓
ayantunde on June 3, 2012 at 1:56 AM said:

Hi. I saw your blog and decided to ask if you could with the project I have. I am trying to upload pdf and download pdf using php and mysql. I have written the codes to upload and download. However, when I try to download the pdf files, it shows that is downloaded and when I try to open it, it gives an error: The selected file can not be opened. The codes for downloading is below and I will need your assistance please:

Reply ↓
Drewdin on June 7, 2012 at 12:08 AM said:

no matter what i try i keep getting the error “MySQL server has gone away” after i select an image and click upload, any suggestions? thanks

Reply ↓
- Drewdin on June 8, 2012 at 1:31 AM said:
  
  I had to change max_allowed_packet = 1M to max_allowed_packet = 16M to get it working. Thanks
  
  Reply ↓
joss on June 8, 2012 at 5:18 AM said:

Hi ,
I am trying to upload the file into the mysql database using the same PHP script as yours “file_insert.php”
But I am getting following error ”Missing a temporary folder’ (UPLOAD_ERR_NO_TMP_DIR).

Could you please tell me what settings do I need to made in the php.ini file to resolve this error.

Thanks

Reply ↓
amadi on June 9, 2012 at 10:09 PM said:

please i need your help with your code, am new to php and just found your site. was trying it out then i met this error and got tied.

Fatal error: Call to undefined function finfo_open() in C:\xampp\htdocs\glorycorp\nett.php on line 111

what do i do ???
thanks a trillion.

Reply ↓
amadi on June 9, 2012 at 10:11 PM said:

please i need your help with your code, am new to php and just found your site. was trying it out then i met this error and got tied.

Fatal error: Call to undefined function finfo_open() in file_insert.php on line 111

what do i do ???
thanks a trillion.

Reply ↓
fahad on June 10, 2012 at 12:02 AM said:

sir i have this problem in your code how it solve
==> Fatal error: Call to undefined function finfo_file() in C:\wamp\www\image_upload_database\file_insert.php on line 49

==> IN YOUR CODE LINE IS THIS
$finfo = finfo_open(FILEINFO_MIME_TYPE);

Reply ↓
- Rajesh Rathor on June 22, 2012 at 12:03 PM said:
  
  i got the same error..
  Pls tick or on the php_fileinfo extention..
  
  Reply ↓
Shashank on June 15, 2012 at 4:00 PM said:

Hello sir,
Firstly thank you for your code. It works perfectly.
But i need to make an addition. I want to display the image uploaded to a gallery on the HTML page.
How can I do that?

Reply ↓
MS Dosser on June 15, 2012 at 5:26 PM said:

firstly thanks so much for publishing this code, I am new to php and have an error occurring and am unsure how to fix it, any chance you could help with this please?

I have saved all the code to my file system and set up the database but when trying to submit an image I get the following error.

Fatal error: Call to undefined function finfo_open() in /home/nesto387/public_html/file_insert.php on line 49

line 49 is this $finfo = finfo_open(FILEINFO_MIME_TYPE);

any help would be greatly appreciated.

Reply ↓
- Rajesh Rathor on June 22, 2012 at 12:02 PM said:
  
  i got the same error..
  Pls tick the or on the php_fileinfo extention..
  
  Reply ↓
Rajesh on June 21, 2012 at 11:09 AM said:

Hello sir,
I tried your code but while executing it,
it showing a error.
Fatal error: Call to undefined function finfo_open() in C:\wamp\www\MySQL\file_insert.php on line 52

pls tell how to resolve it..
Thanks
Rajesh

Reply ↓
- Rajesh Rathor on June 22, 2012 at 11:59 AM said:
  
  i got the same error..
  Pls tick the or on the php_fileinfo extention..
  
  Reply ↓
  - Vikas Mahajan on June 22, 2012 at 12:06 PM said:
    
    See,
    
    Inserting and displaying images in MySQL using PHP
Rajesh Rathor on June 22, 2012 at 12:19 PM said:

Thanks sir,
i already solved the mime problem.
just new problem airse while displaying the images..
i want to know what this code means i mean fromwhere the ID comming in this line..
if(isset($_GET[‘id’]) && is_numeric($_GET[‘id’]))

Reply ↓
Rajesh on June 25, 2012 at 3:23 PM said:

How to show the images without giving the Directory path?
because we are retriving from data base. I only have to see the image by giving the path of my remote folder..
but i want to access the images without that pats,

Reply ↓
zero.cool on December 11, 2012 at 11:35 PM said:

OMG! Thank you SOOO much! I didn’t need your script persay… but the way you did it showed my what I was missing to make mine work. ($image=addslashes(… AWESOMENESS!

Reply ↓
ram on January 4, 2013 at 3:41 PM said:

Fabulous it is going to execute at a single step

Reply ↓
Rajkumar on February 18, 2015 at 8:20 PM said:

fileinfo error solution:

Windows users: just edit php.ini and uncomment this line:

extension=php_fileinfo.dll

Remember to restart Apache for new php.ini to take effect.

Reply ↓