Upload Image to Mysql Database with PHP

squeaky14 · Apr 11, 2005

Hi, this is my first tutorial. I have tested it and it all works great.
It should work with any type of image.

Today, err.. class, were going to make an image >> database uploader.

Requirements:
-Basic knowledge of php and mysql.
-Access to a mysql database.

First of all, create a table (and a database if necessary):

CREATE TABLE `images` (
`img` INT NOT NULL AUTO_INCREMENT ,
`data` LONGTEXT NOT NULL ,
PRIMARY KEY ( `img` )
);

Secondly, create a directory called "temporary" and chmod it to 777.

Ok, now that you have made the table and directory lets get to the coding.
This script will consist of 2 pages, "upload.php" and "image.php".

First page, "upload.php":

PHP:

<?php
//connect to database. Username and password need to be changed
mysql_connect("localhost", "username", "password");

//Select database, database_name needs to be changed
mysql_select_db("database_name");

if (!$_POST['uploaded']){
//If nothing has been uploaded display the form
?>

<form action="<? echo $_SERVER['PHP_SELF']; ?>" method="post" 
ENCTYPE="multipart/form-data">
Upload:<br><br>
<input type="file" name="image"><br><br>
<input type="hidden" name="uploaded" value="1">
<input type="submit" value="Upload">
</form>

<?
}else{
//if the form hasn't been submitted then:

//from here onwards, we are copying the file to the directory you made earlier, so it can then be moved 
//into the database. The image is named after the persons IP address until it gets moved into the database

//get users IP
$ip=$REMOTE_ADDR;

//don't continue if an image hasn't been uploaded
if (!empty($image)){

//copy the image to directory
copy($image, "./temporary/".$ip."");

//open the copied image, ready to encode into text to go into the database
$filename1 = "./temporary/".$REMOTE_ADDR;
$fp1 = fopen($filename1, "r");

//record the image contents into a variable
$contents1 = fread($fp1, filesize($filename1));

//close the file
fclose($fp1);

//encode the image into text
$encoded = chunk_split(base64_encode($contents1)); 

//insert information into the database
mysql_query("INSERT INTO images (img,data)"."VALUES ('NULL', '$encoded')");

//delete the temporary file we made
unlink($filename1);
}

//end
}
?>

Now thats the upload script complete, how do we view the images?

Second Page, "image.php":

PHP:

<?php
//connect to database. Username and password need to be changed
$connection=mysql_connect("localhost", "username", "password");

//Select database, database_name needs to be changed
mysql_select_db("database_name");

//get decoded image data from database
$result=mysql_query("SELECT * FROM images WHERE img='".$_GET['img']."'");

//fetch data from database
$data=mysql_fetch_array($result);
$encoded=$data['data'];

//note: "$data['data']" is the row "data" in the table we made.
//The image ID would be "$data['img']" for example


//close connection
mysql_close($connection);

//decode and echo the image data
echo base64_decode($encoded);

//end
?>

Now, test it. To view the images you upload go to:
http://www.yourdomain.com/image.php?img=1
http://www.yourdomain.com/image.php?img=2
http://www.yourdomain.com/image.php?img=3

and so on...

My first tutorial, tell me what you think. Did you find it hard to understand any parts?