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 Code:
<?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
????: NamePros.com http://www.namepros.com/webmaster-tutorials/81935-upload-image-to-mysql-database-php.html
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 Code:
<?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????: NamePros.com http://www.namepros.com/showthread.php?t=81935 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?
04-11-2005, 01:24 PM
Upload Image to Mysql Database with PHP 
Similar Threads 
