Resize Image + retain quality + upload to mysql database

[rajeshswain]

Hi Friends,

I want to upload a image file to my mysql database. But before that i want to resize it. I have used the following code. But what happens is that the image is successfully resized but the quality is not retained. Please someone guide me with some help.

The code goes here:

The php part

<?php
//***********************************************************************************************************
////////////////-------Photo upload, validation at server-------//////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////

$sPhotoFileName = $_FILES['photo']['name']; // get client side file name
if ($sPhotoFileName) // file uploaded
{	$aFileNameParts = explode(".", $sPhotoFileName);
	$sFileExtension = end($aFileNameParts); // part behind last dot
	if ($sFileExtension != "jpg"
		&& $sFileExtension != "JPEG"
		&& $sFileExtension != "JPG")
	{	die ("Choose a JPG for the photo");
	}
	$nPhotoSize = $_FILES['photo']['size']; // size of uploaded file
	if ($nPhotoSize == 0)
	{	die ("Sorry. The upload of $sPhotoFileName has failed.
Search a photo smaller than 100K, using the button.");
	}
	if ($nPhotoSize > 10240000000)
	{	die ("Sorry.
The file $sPhotoFileName is larger than 100K.
Advice: reduce the photo using a drawing tool.");
	}

	// read photo
	$sTempFileName = $_FILES['photo']['tmp_name']; // temporary file at server side
	$oTempFile = fopen($sTempFileName, "r");
	$sBinaryPhoto = fread($oTempFile, fileSize($sTempFileName));

	// Try to read image
	$nOldErrorReporting = error_reporting(E_ALL & ~(E_WARNING)); // ingore warnings
	$oSourceImage = imagecreatefromstring($sBinaryPhoto); // try to create image
	error_reporting($nOldErrorReporting);

	if (!$oSourceImage) // error, image is not a valid jpg
	{ die ("Sorry.
It was not possible to read photo $sPhotoFileName.
Choose another photo in JPG format.");
	}
}
//////////////////////////////////////////////////////////////////////////////////////////
//////////////-------Photo upload, validation at server ends---/////////////////////////////

//***********************************************************************************************************
////////////////----------Create thumbnail--------------//////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////

	$nWidth = imagesx($oSourceImage); // get original source image width
	$nHeight = imagesy($oSourceImage); // and height

	// create small thumbnail
	$nDestinationWidth = 80;
	$nDestinationHeight = 60;
//$oDestinationImage = imagecreatetruecolor($nDestinationWidth, $nDestinationHeight);
	$oDestinationImage = imagecreate($nDestinationWidth, $nDestinationHeight);

/*$oResult = imagecopyresampled(
	$oDestinationImage, $oSourceImage,
	0, 0, 0, 0,
	$nDestinationWidth, $nDestinationHeight,
	$nWidth, $nHeight); // resize the image
*/
	imagecopyresized($oDestinationImage, $oSourceImage,0, 0, 0, 0,$nDestinationWidth, $nDestinationHeight,$nWidth, $nHeight); // resize the image

	ob_start(); // Start capturing stdout.
	imageJPEG($oDestinationImage); // As though output to browser.
	$sBinaryThumbnail = ob_get_contents(); // the raw jpeg image data.
	ob_end_clean(); // Dump the stdout so it does not screw other output.
	
//***********************************************************************************************************
////////////////------Store Thumbnail in database------//////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////
if($_POST['send'])
{
$sBinaryThumbnail = addslashes($sBinaryThumbnail);

$oDatabase = mysql_connect("localhost", "root", "karma");
mysql_select_db("upload", $oDatabase);

$sQuery = "insert into image (thumbnail) values ('$sBinaryThumbnail')";
echo $sQuery;

mysql_query($sQuery, $oDatabase);
}

?>

The html form

<form enctype="multipart/form-data" method="post" action="" name="form1">
<input type="hidden" name="MAX_FILE_SIZE" value="102400">
<input type="file" name="photo">
<input type="hidden" name="id" value="12345">
<input type=submit value="Send" name=send>
</form>

Here is the code where i have displayed the uploaded image. the quality becomes bad here.

<?
$oDatabase = mysql_connect("localhost", "root", "karma");
mysql_select_db("upload", $oDatabase);
	$s="select thumbnail from image";
	$r=mysql_query($s);
	while($p=mysql_fetch_array($r))
	{
		$bytes = $p[0];
		if($bytes == null)
		{
		    $instr = fopen("images/d_silhouette.gif","rb");
		    $bytes = fread($instr,filesize("images/d_silhouette.gif"));
		}
		$data = base64_encode($bytes);
		echo '<img src="data:image/jpeg;base64,', $data, '" border=0 />';
	}
	?>

Waiting for reply...

[kevin wood]

try this code out i have no problems with the image quality with it.

<?php

			

set_time_limit(0); 
		
$link  =  mysql_connect(localhost, xxxxxxxx, xxxxxxxxx) or die("Could not connect to host.");  //put in your db connection details here
mysql_select_db(xxxxxxx) or die("Could not find database.");  // put your db name in here where the xxxx are
		
		
		
		
 //define a maxim size for the uploaded images
define ("MAX_SIZE","500"); 
// define the width and height for the thumbnail
 // note that theese dimmensions are considered the maximum dimmension and are not fixed, 
 // because we have to keep the image ratio intact or it will be deformed
 define ("WIDTH","150");  //set here the width you want your thumbnail to be
 define ("HEIGHT","120");  //set here the height you want your thumbnail to be.
		
 // this is the function that will create the thumbnail image from the uploaded image
// the resize will be done considering the width and height defined, but without deforming the image
 function make_thumb($img_name,$filename,$new_w,$new_h)
{
//get image extension.
$ext=getExtension($img_name);
//creates the new image using the appropriate function from gd library
if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext))
$src_img=imagecreatefromjpeg($img_name);
		
if(!strcmp("png",$ext))
$src_img=imagecreatefrompng($img_name);
			
if(!strcmp("gif",$ext))
$src_img=imagecreatefromgif($img_name);
		
//gets the dimmensions of the image
$old_x=imageSX($src_img);
$old_y=imageSY($src_img);
		
 // next we will calculate the new dimmensions for the thumbnail image
// the next steps will be taken: 
// 	1. calculate the ratio by dividing the old dimmensions with the new ones
//	2. if the ratio for the width is higher, the width will remain the one define in WIDTH variable
//		and the height will be calculated so the image ratio will not change
//	3. otherwise we will use the height ratio for the image
// as a result, only one of the dimmensions will be from the fixed ones
$ratio1=$old_x/$new_w;
$ratio2=$old_y/$new_h;
if($ratio1>$ratio2)	{
$thumb_w=$new_w;
$thumb_h=$old_y/$ratio1;
}
else	{
$thumb_h=$new_h;
$thumb_w=$old_x/$ratio2;
}
		
// we create a new image with the new dimmensions
			$dst_img=ImageCreateTrueColor($thumb_w,$thumb_h);
// resize the big image to the new created one
			imagecopyresampled($dst_img,$src_img,0,0,0,0,$thumb_w,$thumb_h,$old_x,$old_y); 
		
// output the created image to the file. Now we will have the thumbnail into the file named by $filename
if(!strcmp("png",$ext))
imagepng($dst_img,$filename); 
else
imagejpeg($dst_img,$filename);
				
if (!strcmp("gif",$ext))
imagegif($dst_img,$filename); 
		
//destroys source and destination images. 
imagedestroy($dst_img); 
imagedestroy($src_img); 
 }
	
 // This function reads the extension of the file. 
 // It is used to determine if the file is an image by checking the extension. 
function getExtension($str) {
 $i = strrpos($str,".");
 if (!$i) { return ""; }
 $l = strlen($str) - $i;
 $ext = substr($str,$i+1,$l);
 return $ext;
 }
 // This variable is used as a flag. The value is initialized with 0 (meaning no error found) 
 //and it will be changed to 1 if an error occures. If the error occures the file will not be uploaded.
 $errors=0;
 // checks if the form has been submitted
 if(isset($_POST['Submit']))
 {
 //reads the name of the file the user submitted for uploading
$image=$_FILES['cons_image']['name'];
// if it is not empty
if ($image) 
{
// get the original name of the file from the clients machine
$filename = stripslashes($_FILES['cons_image']['name']);
				
// get the extension of the file in a lower case format
$extension = getExtension($filename);
$extension = strtolower($extension);
// if it is not a known extension, we will suppose it is an error, print an error message 
//and will not upload the file, otherwise we continue
if (($extension != "jpg")  && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif"))	
{
echo '<h1>Unknown extension!  Please use .gif, .jpg or .png files only.</h1>';
$errors=1;
}
else
{
// get the size of the image in bytes
// $_FILES[\'image\'][\'tmp_name\'] is the temporary filename of the file in which 
//the uploaded file was stored on the server
					$size=getimagesize($_FILES['cons_image']['tmp_name']);
$sizekb=filesize($_FILES['cons_image']['tmp_name']);
		
//compare the size with the maxim size we defined and print error if bigger
if ($sizekb > MAX_SIZE*1024)
{
echo '<h1>You have exceeded the 1MB size limit!</h1>';
$errors=1;
}
		
					
$rand= rand(0, 1000);
//we will give an unique name, for example a random number
$image_name=$rand.'.'.$extension;
//the new name will be containing the full path where will be stored (images folder)
$consname="image/".$image_name;  //change the image/ section to where you would like the original image to be stored
					$consname2="image/thumb".$image_name; //change the image/thumb to where you would like to store the new created thumb nail of the image
$copied = copy($_FILES['cons_image']['tmp_name'], $consname);
$copied = copy($_FILES['cons_image']['tmp_name'], $consname2);
												
$sql="UPDATE your table name SET image= '$consname2'  WHERE id= '$lastid'"or die(mysql_error());
$query = mysql_query($sql)or die(mysql_error());
//we verify if the image has been uploaded, and print error instead
if (!$copied) {
echo '<h1>Copy unsuccessfull!</h1>';
$errors=1;
}
else
{
// the new thumbnail image will be placed in images/thumbs/ folder
$thumb_name=$consname2	;
// call the function that will create the thumbnail. The function will get as parameters 
//the image name, the thumbnail name and the width and height desired for the thumbnail
						$thumb=make_thumb($consname,$thumb_name,WIDTH,HEIGHT);
}
}	
}
}
					
 //If no errors registred, print the success message and how the thumbnail image created
if(isset($_POST['Submit']) && !$errors) 
 {
echo "<h5>Thumbnail created Successfully!</h5>";
echo '<img src="'.$thumb_name.'">';
echo $lastid;
}
		 
echo "<form name=\"newad\" method=\"post\" enctype=\"multipart/form-data\"  action=\"\">";
echo "<input type=\"file\" name=\"cons_image\"  >";
echo "<input name=\"Submit\" type=\"submit\"  id=\"image1\" value=\"Upload image\" />";
 echo "</form>";
		 
?>

just change the sql section to an insert and this should work fine for you.

[parkerproject]

reading your code,it looks like you are storing just the filename in the database.i guess if i want to store the thumbnail in the database,then i would INSERT $thumb rather than $consname2

correct me in am wrong

[kevin wood]

this code stores the path to the image in the db an stores two copies of the image on the server. the original and the newly created thumbnail image.

you will need to create a folder called image and one call thumb inside of that.

[parkerproject]

All the images are stored in the images folder.I want the thumbnails stored in the thumb and the original store in images.

can you help

[kevin wood]

if you look for the section where the values of $consname and $consname2 are set you can change where the files are stored on the server there.
if you want the oiginal image stored in the images folder then the line of code should look like this

$consname="images/".$image_name;

and the thumbs to be stored in a thumb folder the next line of code will be

$consname2="thumb/".$image_name;

[webnathan]

i cant even get the form to display.
i copied and pasted this code:

<?php

			

set_time_limit(0); 
		
$link  =  mysql_connect(localhost, xxxxxxxx, xxxxxxxxx) or die("Could not connect to host.");  //put <strong class="highlight">in</strong> your db connection details here
mysql_select_db(xxxxxxx) or die("Could not find <strong class="highlight">database</strong>.");  // put your db name <strong class="highlight">in</strong> here where the xxxx are
		
		
		
		
 //define a maxim size for the uploaded images
define ("MAX_SIZE","500"); 
// define the width <strong class="highlight"><vb_highlight>and</strong></vb_highlight> height for the thumbnail
 // note that theese dimmensions are considered the maximum dimmension <strong class="highlight"><vb_highlight>and</strong></vb_highlight> are not fixed, 
 // because we have to keep the <strong class="highlight">image</strong> ratio intact or it will be deformed
 define ("WIDTH","150");  //set here the width you want your thumbnail to be
 define ("HEIGHT","120");  //set here the height you want your thumbnail to be.
		
 // this is the function that will create the thumbnail <strong class="highlight">image</strong> from the uploaded <strong class="highlight">image</strong>
// the <strong class="highlight">resize</strong> will be done considering the width <strong class="highlight"><vb_highlight>and</strong></vb_highlight> height defined, but without deforming the <strong class="highlight">image</strong>
 function make_thumb($img_name,$filename,$new_w,$new_h)
{
//get <strong class="highlight">image</strong> extension.
$ext=getExtension($img_name);
//creates the new <strong class="highlight">image</strong> using the appropriate function from gd library
if(!strcmp("jpg",$ext) || !strcmp("jpeg",$ext))
$src_img=imagecreatefromjpeg($img_name);
		
if(!strcmp("png",$ext))
$src_img=imagecreatefrompng($img_name);
			
if(!strcmp("gif",$ext))
$src_img=imagecreatefromgif($img_name);
		
//gets the dimmensions of the <strong class="highlight">image</strong>
$old_x=imageSX($src_img);
$old_y=imageSY($src_img);
		
 // next we will calculate the new dimmensions for the thumbnail <strong class="highlight">image</strong>
// the next steps will be taken: 
// 	1. calculate the ratio by dividing the old dimmensions <strong class="highlight">with</strong> the new ones
//	2. if the ratio for the width is higher, the width will remain the one define <strong class="highlight">in</strong> WIDTH variable
//		<strong class="highlight"><vb_highlight>and</strong></vb_highlight> the height will be calculated so the <strong class="highlight">image</strong> ratio will not change
//	3. otherwise we will use the height ratio for the <strong class="highlight">image</strong>
// as a result, only one of the dimmensions will be from the fixed ones
$ratio1=$old_x/$new_w;
$ratio2=$old_y/$new_h;
if($ratio1>$ratio2)	{
$thumb_w=$new_w;
$thumb_h=$old_y/$ratio1;
}
else	{
$thumb_h=$new_h;
$thumb_w=$old_x/$ratio2;
}
		
// we create a new <strong class="highlight">image</strong> <strong class="highlight">with</strong> the new dimmensions
			$dst_img=ImageCreateTrueColor($thumb_w,$thumb_h);
// <strong class="highlight">resize</strong> the big <strong class="highlight">image</strong> to the new created one
			imagecopyresampled($dst_img,$src_img,0,0,0,0,$thumb_w,$thumb_h,$old_x,$old_y); 
		
// output the created <strong class="highlight">image</strong> to the file. Now we will have the thumbnail into the file named by $filename
if(!strcmp("png",$ext))
imagepng($dst_img,$filename); 
else
imagejpeg($dst_img,$filename);
				
if (!strcmp("gif",$ext))
imagegif($dst_img,$filename); 
		
//destroys source <strong class="highlight"><vb_highlight>and</strong></vb_highlight> destination images. 
imagedestroy($dst_img); 
imagedestroy($src_img); 
 }
	
 // This function reads the extension of the file. 
 // It is used to determine if the file is an <strong class="highlight">image</strong> by checking the extension. 
function getExtension($str) {
 $i = strrpos($str,".");
 if (!$i) { return ""; }
 $l = strlen($str) - $i;
 $ext = substr($str,$i+1,$l);
 return $ext;
 }
 // This variable is used as a flag. The value is initialized <strong class="highlight">with</strong> 0 (meaning no error found) 
 //and it will be changed to 1 if an error occures. If the error occures the file will not be uploaded.
 $errors=0;
 // checks if the form has been submitted
 if(isset($_POST['Submit']))
 {
 //reads the name of the file the user submitted for uploading
$image=$_FILES['cons_image']['name'];
// if it is not empty
if ($image) 
{
// get the original name of the file from the clients machine
$filename = stripslashes($_FILES['cons_image']['name']);
				
// get the extension of the file <strong class="highlight">in</strong> a lower case format
$extension = getExtension($filename);
$extension = strtolower($extension);
// if it is not a known extension, we will suppose it is an error, print an error message 
//and will not <strong class="highlight">upload</strong> the file, otherwise we continue
if (($extension != "jpg")  && ($extension != "jpeg") && ($extension != "png") && ($extension != "gif"))	
{
echo '<h1>Unknown extension!  Please use .gif, .jpg or .png files only.</h1>';
$errors=1;
}
else
{
// get the size of the <strong class="highlight">image</strong> <strong class="highlight">in</strong> bytes
// $_FILES[\'image\'][\'tmp_name\'] is the temporary filename of the file <strong class="highlight">in</strong> which 
//the uploaded file was stored on the server
					$size=getimagesize($_FILES['cons_image']['tmp_name']);
$sizekb=filesize($_FILES['cons_image']['tmp_name']);
		
//compare the size <strong class="highlight">with</strong> the maxim size we defined <strong class="highlight"><vb_highlight>and</strong></vb_highlight> print error if bigger
if ($sizekb > MAX_SIZE*1024)
{
echo '<h1>You have exceeded the 1MB size limit!</h1>';
$errors=1;
}
		
					
$rand= rand(0, 1000);
//we will give an unique name, for example a random number
$image_name=$rand.'.'.$extension;
//the new name will be containing the full path where will be stored (images folder)
$consname="image/".$image_name;  //change the image/ section to where you would like the original <strong class="highlight">image</strong> to be stored
					$consname2="image/thumb".$image_name; //change the image/thumb to where you would like to <strong class="highlight">store</strong> the new created thumb nail of the <strong class="highlight">image</strong>
$copied = copy($_FILES['cons_image']['tmp_name'], $consname);
$copied = copy($_FILES['cons_image']['tmp_name'], $consname2);
												
$sql="UPDATE your table name SET <strong class="highlight">image</strong>= '$consname2'  WHERE id= '$lastid'"or die(mysql_error());
$query = mysql_query($sql)or die(mysql_error());
//we verify if the <strong class="highlight">image</strong> has been uploaded, <strong class="highlight"><vb_highlight>and</strong></vb_highlight> print error instead
if (!$copied) {
echo '<h1>Copy unsuccessfull!</h1>';
$errors=1;
}
else
{
// the new thumbnail <strong class="highlight">image</strong> will be placed <strong class="highlight">in</strong> images/thumbs/ folder
$thumb_name=$consname2	;
// call the function that will create the thumbnail. The function will get as parameters 
//the <strong class="highlight">image</strong> name, the thumbnail name <strong class="highlight"><vb_highlight>and</strong></vb_highlight> the width <strong class="highlight"><vb_highlight>and</strong></vb_highlight> height desired for the thumbnail
						$thumb=make_thumb($consname,$thumb_name,WIDTH,HEIGHT);
}
}	
}
}
					
 //If no errors registred, print the success message <strong class="highlight"><vb_highlight>and</strong></vb_highlight> how the thumbnail <strong class="highlight">image</strong> created
if(isset($_POST['Submit']) && !$errors) 
 {
echo "<h5>Thumbnail created Successfully!</h5>";
echo '<img src="'.$thumb_name.'">';
echo $lastid;
}
		 
echo "<form name=\"newad\" method=\"post\" enctype=\"multipart/form-data\"  action=\"\">";
echo "<input type=\"file\" name=\"cons_image\"  >";
echo "<input name=\"Submit\" type=\"submit\"  id=\"image1\" value=\"<strong class="highlight">Upload</strong> image\" />";
 echo "</form>";
		 
?>

I uploaded it to run it on the server so i can see what it does before i make any changes and try to understand the code.

Any help.

Please feel free to email me [snipped]

[mukhtar1234]

This script works like heaven thanks alot to the author.. im completely indebted to your sir as i was just looking for the samething