CREATE TABLE images (
img_id int(9) NOT NULL auto_increment,
img_file varchar(13) NOT NULL default '',
img_type enum('JPG','PNG') NOT NULL default 'JPG',
img_height int(6) NOT NULL default '0',
img_width int(6) NOT NULL default '0',
img_bytes int(9) NOT NULL default '0',
img_title text NOT NULL,
img_descr text NOT NULL,
img_alt text NOT NULL,
PRIMARY KEY (img_id)
) TYPE=MyISAM;

//Define dirs
$base_img_dir = "./img/";
$img_conv_dir = "./bin/";

//Image table
$img_table = "images";

//Database connection !!needs your info!!
mysql_connect("host", "user", "pass");
mysql_select_db("yourtable");

//Generate a unique image property..id
$uniq = uniqid("");

// new file name
$filename = $base_img_dir.$uniq;

//Get image size
$imginfo = getimagesize($filename);


//Get image extension
function image_type_to_extension($imagetype,$include_dot=false)
{
if(empty($imagetype)) return false;
switch($imagetype)
{
case IMAGETYPE_GIF: return 'gif';
case IMAGETYPE_JPEG: return 'jpg';
case IMAGETYPE_PNG: return 'png';
case IMAGETYPE_SWF: return 'swf';
case IMAGETYPE_WBMP: return 'wbmp';
default: return false;}}

//full image name
$Dot='.';
$image="$filename$Dot$imagetype";

//find non jpg
if(($imagetype==gif) || ($imagetype==png) || ($imagetype==swf) || ($imagetype==wbmp)){
$imagetype='jpg';

//Remove original and rename new to save space
unlink($filename);
$jpgimg=$filename$imagetype;

//preload check
if($imagetype=!'jpg'){
$imagetype='jpg;
$Dot='.';
$jpgimg="$filename$Dot$imagetype;}

//Load image to check correct handling
$img = imagecreatefromjpg($filename);
imagejpg($img, $filename);
imagedestroy($img);

//Done...get it into your db
// insert image into db
mysql_query("INSERT INTO $img_table (img_file, img_type, img_height,
img_width, img_bytes, img_title, img_descr, img_alt)
VALUES('$uniq', '$img_type', ".$imginfo[1].", ".$imginfo[0].",
$imgbytes, '".addslashes($HTTP_POST_VARS["title"])."', '".
addslashes($HTTP_POST_VARS["descr"])."',
'".addslashes($HTTP_POST_VARS["alt"])."');");

//Last chance on failure..
if($filename$Dot$imagetype=!$filename.jpg){
$color="#ff0000"';
$result = "Sorry, Image conversion failed";;}
else {
$color="#06FF00";
$result = "Success! Your image was successfully converted to the .JPG extension!";}

//Result screen
echo "Your Image: ".$filename$Dot$imagetype."";
echo "<br>";
echo "has received the following result:";
echo "<br>";
echo "<font color=\"".$color."\">$result</font>";