Hi All, I have been trying to create a php page that will upload a image, create a thumbnai and process a sql query, all automatically.
I have attached the two files. The form page (show-addrecord2.php) and the processing page (do_addrecord2.php).

The sql statement works fine. I am just having problems with the image upload and thumbnail creation part. I will also need the image and thumnail names to be added to the database as is in the sql query. I have tried a few things but cant seem to get it to work.

The problem seems to be at the point of upload.

I also should mention that the upload script is going to be in the admin folder of my script where the images will be in the images folder (not in admin/images - just /images). I hope you understand what I am trying to say. Also the links MUST remain reletive, just incase I install my script somewhere else.

Any help is greatly apreciated.

Attachments
<?

include ('../config/db2.php');

require_once("login.inc.php");

//set up database and table names


$table_name ="BurialsTable";

//////////////////////////////////////////////
//  Image Processing and Upload Scripting   //
//


//define a maxim size for the uploaded images
define ("MAX_SIZE","100"); 
// 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"); 
define ("HEIGHT","100"); 

// 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);

//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); 

//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 errro 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['image']['name'];
// if it is not empty
if ($image) 
{
// get the original name of the file from the clients machine
$filename = stripslashes($_FILES['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")) 
{
echo '<h1>Unknown extension!</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['image']['tmp_name']);
$sizekb=filesize($_FILES['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 size limit!</h1>';
$errors=1;
}

//we will give an unique name, for example the time in unix time format
$image_name=time().'.'.$extension;
//the new name will be containing the full path where will be stored (images folder)
$newname="../images/".$image_name;
$copied = copy($_FILES['image']['tmp_name'], $newname);
//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='../images/thumbs/thumb_'.$image_name;
// 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($newname,$thumb_name,WIDTH,HEIGHT);
}} }}

//If no errors registred, print the success message and show the thumbnail image created
if(isset($_POST['Submit']) && !$errors) 
{
echo "<h1>Thumbnail created Successfully!</h1>";
echo '<img src="'.$thumb_name.'">';
}
/*
//<!-- next comes the form, you must set the enctype to "multipart/form-data" and use an input type "file" -->

//<form name="newad" method="post" enctype="multipart/form-data" action="">
//<table>
//<tr><td><input type="file" name="image" ></td></tr>
//<tr><td><input name="Submit" type="submit" value="Upload image"></td></tr>
//</table> 
//</form>
*/


//
//End image Processing scripting            //
//////////////////////////////////////////////




//connect to MySQL and select database to use

$connection = @mysql_connect($server,$dbusername,$dbpassword) or die(mysql_error());

$db = @mysql_select_db($db_name,$connection) or die(mysql_error());



//create SQL statement and issue query

$sql = "INSERT INTO $table_name (EndowmentNumber, LotSize, Town, Cemetery, Section, LotNumber, LotOwner, LastName, FirstName, MiddleInitial, MaidenName, Suffix, Born, Died, VeteranInfo, MiscInfo, fullimg, thumbimg) VALUES ('$_POST[EndowmentNumber]', '$_POST[LotSize]', '$_POST[Town]', '$_POST[Cemetery]', '$_POST[Section]', '$_POST[LotNumber]', '$_POST[LotOwner]', '$_POST[LastName]', '$_POST[FirstName]', '$_POST[MiddleInitial]', '$_POST[MaidenName]', '$_POST[Suffix]', '$_POST[Born]', '$_POST[Died]', '$_POST[VeteranInfo]', '$_POST[MiscInfo]', '".$image_name."', '".$thumb_name."')";



$result = @mysql_query($sql,$connection)or die(mysql_error());



mysql_close();



$title = "<title>Record Added- PHP Grave Finder</title>";

include ("../config/adminheader.php");

?>



</head>

<body>

<h1>Adding a Record to <? echo "$table_name"; ?></h1>

<table cellspacing="3" cellpadding="3">

<tr>

<td valign="top">

<p><strong>Endowment Number:</strong>

<? echo "$_POST[EndowmentNumber]"; ?>

</p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>LotSize:</strong>

<? echo "$_POST[LotSize]"; ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>Town:</strong>

<? echo "$_POST[Town]"; ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>Cemetery:</strong>

<? echo "$_POST[Cemetery]"; ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>Section:</strong>

<? echo "$_POST[Section]"; ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>Lot Number:</strong>

<? echo "$_POST[LotNumber]"; ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>Lot Owner:</strong>

<? echo "$_POST[LotOwner]"; ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>Last Name:</strong>

<? echo "$_POST[LastName]"; ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>First Name:</strong>

<? echo "$_POST[FirstName]"; ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>MiddleInitial:</strong>

<? echo "$_POST[MiddleInitial]"; ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>MaidenName:</strong>

<? echo "$_POST[MaidenName]"; ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>Suffix:</strong>

<? echo "$_POST[Suffix]"; ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>Born:</strong>

<? echo "$_POST[Born]"; ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>Died:</strong>

<? echo "$_POST[Died]"; ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>Veteran Info:</strong><br />

<? echo stripslashes($_POST[VeteranInfo]); ?></p>

</td>

</tr>

<tr>

<td valign="top">

<p><strong>Misc. Info:</strong><br />

<? echo stripslashes($_POST[MiscInfo]); ?></p>

<p><a href="show_addrecord.php">Add Another</a></p>

<p><a href="index.php">Return to Main Menu</a></p>

</td>

</tr>

</table>

<? include ("../config/adminfooter.php");?>
</body>

</html>
<?php
require_once("login.inc.php");

$title = "<title>Add A Record - PHP Grave Finder</title>";

include ("../config/adminheader.php");
?>

</head>
<body>
<h1>Adding a Record to Burials &amp; Graves Database</h1>
<form method="post" action="do_addrecord2.php" enctype="multipart/form-data">
<table cellspacing="3" cellpadding="3">
<tr>
<td valign="top">
<p><strong>Endowment Number:</strong>
<input type="text" name="EndowmentNumber" size="10" maxlength="10" /></p>
</td>

<td valign="top">
<p><strong>Lot Size:</strong>
<input type="text" name="LotSize" size="10" maxlength="10" value="2 X 6" /></p>
</td>
</tr>


<tr>
<td valign="top">
<p><strong>Town:</strong>
<input type="text" name="Town" size="25" /></p>
</td>

<td valign="top">
<p><strong>Cemetery:</strong>
<input type="text" name="Cemetery" size="25" /></p>
</td>
</tr>


<tr>
<td valign="top">
<p><strong>Section:</strong>
<input type="text" name="Section" size="2" maxlength="2" /></p>
</td>

<td valign="top">
<p><strong>Lot Number:</strong>
<input type="text" name="LotNumber" size="15" maxlength="15" /></p>
</td>
</tr>


<tr>
<td valign="top" colspan="2">
<p><strong>Lot Owner:</strong>
<input type="text" name="LotOwner" size="50" maxlength="50" /></p>
</td>
</tr>


<tr>
<td valign="top">
<p><strong>Last Name:</strong>
<input type="text" name="LastName" size="50" maxlength="50" /></p>
</td>

<td valign="top">
<p><strong>First Name:</strong>
<input type="text" name="FirstName" size="50" maxlength="50" /></p>
</td>
</tr>

<tr>
<td valign="top">
<p><strong>MiddleInitial:</strong>
<input type="text" name="MiddleInitial" size="20" maxlength="20" /></p>
</td>

<td valign="top">
<p><strong>MaidenName:</strong>
<input type="text" name="MaidenName" size="20" maxlength="20" /></p>
</td>
</tr>


<tr>
<td valign="top" colspan="2">
<p><strong>Suffix:</strong>
<input type="text" name="Suffix" size="20" maxlength="20" /></p>
</td>
</tr>


<tr>
<td valign="top">
<p><strong>Born:</strong>
<input type="text" name="Born" size="20" maxlength="20" /></p>
</td>

<td valign="top">
<p><strong>Died:</strong>
<input type="text" name="Died" size="20" maxlength="20" /></p>
</td>
</tr>
<tr>
<td valign="top">
<p><strong>Veteran Info:</strong><br />
<textarea name="VeternInfo" cols="50" rows="5"></textarea></p>
</td>
<td rowspan="2">
<p><strong>Upload Headstone Image</strong> (leave empty for default image)
<input type="file" name="userfile" size="20"></p>
</td>
</tr>

<tr>
<td valign="top">
<p><strong>Misc. Info:</strong><br />
<textarea name="MiscInfo" cols="50" rows="8"></textarea></p>
</td>
</tr>
<tr>
<td>
<p><input type="submit" name="submit" value="Add Record" /></p>
</td></tr>
</table>
</form>

<? include ("../config/adminfooter.php"); ?>

</body>
</html>

After a quick scan of your code, I suspect you are mixed up with two variables $newname and $image_name .

Forgive me if I'm wrong.

wulawula, The upload an thumbnail creation was taken form a tutorial that said it was supposed to work. I didn't test it before trying to integrate it into my script. So I don't know what the script should look like. I will continue to try different things though.

maxabet,
I actually have already read that thread, but was trying to get the script to do more. so, trying to make things easy, i downloaded one script that said it did what I wanted.

maxabet, I noticed something when going thru the other thread. The do_addrecord.php file that I uses a definition $img_name, but I don't see how or where that would be defined. Should I have a line near the top of the file that looks like this.

$img_name = $HTTP_POST_FILES;

I will go ahead and try it. The worst thing that could happen is it won't work.

i have an upload class if you want it. i created it to upload mulitple files and i also added a thumbnailing capability.

also $HTTP_POST_FILES is outdated. use $_FILES

kkieth29, I am interested in anything that will help me get this script going. Whether it is fixing this page or creating a new one. If you look at the do_addrecord.php page there is a couple of comment areas that specify where the image upload and processing script is. The important part is that the script is functional. I need the script to upload the image to (../images) folder and create a thumbnail and place that in the (../images/thumbs) folder. Then it needs to place the image and thumbnail images into the sql database.

Thanks for the help in advanced.

Does anyone have any help they can offer. I have tried a few things but can't get it to work. I'm stumped myself. Any Help is appreciated.

This article has been dead for over six months. Start a new discussion instead.