Member Avatar for PomonaGrange

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.

<?

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>
  • 4 Contributors
  • 8 Replies
  • 107 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by somedude3488
Member Avatar for wulawula

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.

Member Avatar for PomonaGrange

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.

Member Avatar for PomonaGrange

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.

Member Avatar for somedude3488

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

Member Avatar for PomonaGrange

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.

Member Avatar for PomonaGrange

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.

Member Avatar for somedude3488

wow, sorry. been really busy with work. i will pm you the file as soon as i can.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.