How to upload images to mySQL within PHP

Published on 2/6/2007 by Dotnetindex

Aim of this article is to sho you the simples way to uplaod images to mySQL database. First you need to create a custom database table. The name of this table can be named as "images_table". Now here is the SQL code for creating the table.

images_table.sql

CREATE TABLE `images_table` (
`imageID` int(11) NOT NULL auto_increment,
`imageName` varchar(25) NOT NULL default '',
`imageFile` longtext NOT NULL,
PRIMARY KEY (`imageID`)
)  AUTO_INCREMENT=1 ;

This is our upload HTML file. There will be no server-side coding on this file :

imageupload.php



Upload Image



Name :

Image :






Now this is the rest of the code. This php file will insert the image to our database.

imageupload.php



  /*
    This function take the image from form variables
                            */

function getImageFile($file){
$takeFile = fopen($file, "r");
$file = fread($takeFile, filesize($file));
fclose($takeFile);

return $file;
}

  /*
    We learn image type using this function
    Because we will let onlt gif, jpg and png images can be uploaded
                            */

function getfileType( $name ){
$name = explode(".", $name);
$name = array_reverse($name);
$name = $name[0];
return $name;
}

$allowedImageTypes = array("gif","jpg","png");
if(empty($_FILES['image_file']['tmp_name'])){
echo "File not uploaded";
}
else {
$fileType = $_FILES['image_file']['name'];

if(in_array(getfileType($fileType), $allowedImageTypes)){
$fileContent = getImageFile($_FILES['imgFile']['tmp_name']);

$uploadedImage = chunk_split(base64_encode($fileContent));

$query = "INSERT INTO images_table VALUES('NULL','$imgName','$uploadedImage')";

$result = mysql_query($query);

if(mysql_affected_rows() > 0){

echo "Image has been inserted succesfully";
}
else {
echo "Image can not be inserted check your submission";
}
}
else {
echo "This is not a true image type";
}
}

Happy Coding

Latest Posts

• Database driven web counter with PHP/mySQL
• PHP mail() function
• Workingwith Arrays in PHP
• Check if the domain name exists
• Generating random strings within PHP
• Encode/Decode an ISO-8859-1 string to UTF-8
• Creating error pages using .htaccess
• PHP Security
• Displaying mySQL table structures in PHP
• Capitilize strings in PHP
• Counting records in PHP mySQL
• Parsing XML/RSS feeds easily with SimpleXML
• Sending queries to mySQL
• Session in PHP
• MD5 Encryption in PHP
• PHP Functions array fill
• How to display date time in real time
• PHP Functions urlencode
• In Case You Missed ItThe Week of January 23 2006
• In Case You Missed ItThe Week of January 16 2006