Upload images to mysql database

metalix 0 Tallied Votes 992 Views Share

first create the table

create table images (
    image_id    serial,
    filename    varchar(255) not null,
    mime_type   varchar(255) not null,
    file_size   int          not null,
    file_data   longblob     not null,
    primary key (image_id),
    index (filename)

the file to output the images to the browser picsrc.php

//detect if image is called correctly
//connect to db
    $db = mysql_connect('localhost', 'user', 'password');
//find the image
        $query  = sprintf('select * from images where filename = %d', $image);
        $result = mysql_query($query, $db);
$image = mysql_fetch_array($result);
//tell the browser the url is an image
    header('Content-type: ' . $image['mime_type']);
    header('Content-length: ' . $image['file_size']);
//finally output the image
echo $image['file_data'];

to call the image use this line

<img src="picsrc.php?image=potato.jpeg">

fairly straightforward. you can view a full tutorial at http://www.effectivewebdesign.co.nz/tutorial.php

hope this helps.

//connect to database
    $db = mysql_connect('localhost', 'user', 'password');

//detect if form has been processed
  $image = $_FILES['image'];
//detect file is image
  $info = getImageSize($image['tmp_name']);
        if (!$info) {
            $notice = 'File is not an image';
  else {
//insert the image
           $query = sprintf(
            "insert into images (filename, mime_type, file_size, file_data)
                values ('%s', '%s', %d, '%s')",
$notice = 'Image Uploaded successfully';

<title>Upload an Image</title>
<h1>Upload an Image</h1>
<?PHP if ($notice){
//echo image status
 echo $notice;
<br />
<a href="view.php">View uploaded images</a>
<form method="post" action="<?PHP echo $_SERVER['PHP_SELF']; ?>" enctype="multipart/form-data">
<input type="file" name="image" />
<input type="submit" value="Upload Image" />
metalix 0 Posting Whiz in Training

yes I realise it is in the wrong order.
It is difficult to put tutorials in code snippets :)

Rewired 0 Light Poster

Hey where is the

<a href="view.php">View uploaded images</a>


metalix 0 Posting Whiz in Training

Yeah sorry I didn't put that one in.
you just call the images as you normally would (<img src="images/pic.jpg">)
but instead you'll have <img src="picsrc.php?image=myimage.jpg">

however I suggest you use a .htaccess mod rewrite and an url encoder so as to make it a little more secure (I removed security checks for simplicity)

guruparthi -6 Newbie Poster

You can use this code to upload images to database using PHP

 <form action="#" method="post" enctype="multipart/form-data">
File: <input type="file" name="file">
       <input type="submit" name="submit" value="Upload">
   if($type=='image/jpeg' || $type=='image/png' || $type=='image/gif' || $type=='image/pjpeg')
      echo'file is already present';
      $q=mysql_query("insert into image values('','".$name."')");
  if($up && $q)
   echo'image uploaded and stored';
   echo'image not uploaded';
   echo'image not stored';
    echo'Invalid file type';
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, learning, and sharing knowledge.