Popular Articles | Latest Articles | Categories | RSS Feeds

How to upload images to mySQL within PHP

Published on 2/6/2007 by Dotnetindex
More articles in PHP



 Vote this tutorial:

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

Comments:
no comments submitted


Only members can write comments.Please, login / register to write comment.

Latest Posts

Active News Manager - news management system




Welcome to Dotnetindex.com:Login  |  Register
Free software:
Giga RSS Reader
IkonAdman
QMailing list
Active News
Download Manager (PRO)
Download Manager (Lite)

Search Dotnetindex.com:


Who's online

  • There 34 online users.

Latest tutorialsIntroduction to Dependency Injection Using StructureMap
SEO For ASP.NET Web Site
Using ASP.NET 3.5's ListView and DataPager Controls: The Ultimate DataPager Interface
Using jQuery To Hijack ASP.NET MVC Form Posts
Accessing and Updating Data in ASP.NET: Filtering Data Using a CheckBoxList
Predictive Fetch with jQuery and the ASP.NET Ajax Library
Building ASP.NET Web Forms to Use a MySQL Database
A Guide to Upgrading Your XP Machine for Optimum Performance with Windows 7
Retrieving Data from Microsoft SQL Server 2008 Using ASP.NET 3.5
Creating an ASP.NET Dynamic Web Page Using MS SQL Server 2008 Database (GridView Display)
Inserting Data into a Microsoft SQL 2008 Database in ASP.NET 3.5
Using C#, ASP.NET, and ADO.NET To Develop A Multi-Tier App From Start To Finish
URL Routing in ASP.NET 4.0
Integrating Twitter Into An ASP.NET Website
Creating Multiple Choice Exam Application Using ASP.NET MVC Framework
ASP.NET Resources, Reviews

ASP Resources, Reviews

PHP, ASP, .NET, JSP Resources, Reviews

Hotscripts.com Free Photoshop, Flash and 3DS MAX tutorials