I need a unique upload script

[David_P]

I spent the day (all day) yesterday searching for some way of doing this:

ALL at the same time - one click does it all.

• I need to be able to upload info into mysql db.
• Upload images into a folder - making thumbnail (80x80) and maintaining original image so I can link to it from thumbnail.
• Insert image name into db.

$query = "INSERT INTO blahblah VALUES ('', '$item_name', '$item_desc', '$item_price', '$image_name', '$cat_name')";
mysql_query($query);

OK images (80x80 thumbnail and original image) goes into a folder above root, the image name into the $image_name field in database table.

The thumbnails can have a "_t" on the end of the image name and put in same folder as large pics or keep the same name but placed into a separate folder called thumbs and the big pics into a folder called big_pics.

I'm trying to make a little online store where people can upload a picture, along with the item information, price, etc. but only display the thumbs that are linked to their bigger siblings.

I'm trying to make it simple as possible for people to manage their own little mini-site who may not be very technically savvy - like me.

I've read a thousand resize and image scripts and most will do everything in the world to an image - flip it, flop it, watermark it, write on it, crop it, kiss it, slap it and make love to it, but it will not create a thumbnail and save it to folder, keep original pic and save it to folder and put image name into db, etc.

David

[David_P]

OK, I found an image script that does what I want:

Keeps and stores original image into a folder called /PICS and creates a thumbnail and stores it in /PICS/THUMBS. Both have the same name, which is good.

Now, I need to take the form part of this image upload script and incorporate it into this form so that it still does what it does, but at the same time the Image name is entered into the database field - image_name:

this_form.php <form action="insert_this_form.php" method="post">

<p>
Item Name:<br>
<input type="text" name="item_name" size="45" value="">

<br><br>

Item description:<br>
<textarea rows="10" name="item_desc" cols="35" wrap=virtual></textarea>

<br><br>

Item Price: &nbsp;Example: 20.00 (do not use $-sign)<br>
<input type="text" name="item_price" size="25" value="">

<br><br>

Image Name: &nbsp; Include image extension - <strong>.jpg</strong><br>
<input type="text" name="image_name" size="45" value="">

<br>
<br>

Category Name:<br>
<select name="cat_name">
<option value"" selected="selected">Select One</option>
<option value="Shoes">Shoes</option>
<option value="Pants">Pants</option>
<option value="Earrings"selected">Earrings</option>
<option value="Shirts">Shirts</option>
</select>

<br>
<br>

<p><input type="Submit" value="Add Item"></p>

</form>

I would just post the url for the image upload script but I don't know if it's allowed, so here it is:

<?php 
$idir = "pics/";   // Path To Images Directory 
$tdir = "pics/thumbs/";   // Path To Thumbnails Directory 
$twidth = "125";   // Maximum Width For Thumbnail Images 
$theight = "100";   // Maximum Height For Thumbnail Images 

if (!isset($_GET['subpage'])) {   // Image Upload Form Below   ?> 
  <form method="post" action="addphoto.php?subpage=upload" enctype="multipart/form-data"> 
   File:<br /> 
  <input type="file" name="imagefile" class="form"> 
  <br /><br /> 
  <input name="submit" type="submit" value="Sumbit" class="form">  <input type="reset" value="Clear" class="form"> 
  </form> 
<? } else  if (isset($_GET['subpage']) && $_GET['subpage'] == 'upload') {   // Uploading/Resizing Script 
  $url = $_FILES['imagefile']['name'];   // Set $url To Equal The Filename For Later Use 
  if ($_FILES['imagefile']['type'] == "image/jpg" || $_FILES['imagefile']['type'] == "image/jpeg" || $_FILES['imagefile']['type'] == "image/pjpeg") { 
    $file_ext = strrchr($_FILES['imagefile']['name'], '.');   // Get The File Extention In The Format Of , For Instance, .jpg, .gif or .php 
    $copy = copy($_FILES['imagefile']['tmp_name'], "$idir" . $_FILES['imagefile']['name']);   // Move Image From Temporary Location To Permanent Location 
    if ($copy) {   // If The Script Was Able To Copy The Image To It's Permanent Location 
      print 'Image uploaded successfully.<br />';   // Was Able To Successfully Upload Image 
      $simg = imagecreatefromjpeg("$idir" . $url);   // Make A New Temporary Image To Create The Thumbanil From 
      $currwidth = imagesx($simg);   // Current Image Width 
      $currheight = imagesy($simg);   // Current Image Height 
      if ($currheight > $currwidth) {   // If Height Is Greater Than Width 
         $zoom = $twidth / $currheight;   // Length Ratio For Width 
         $newheight = $theight;   // Height Is Equal To Max Height 
         $newwidth = $currwidth * $zoom;   // Creates The New Width 
      } else {    // Otherwise, Assume Width Is Greater Than Height (Will Produce Same Result If Width Is Equal To Height) 
        $zoom = $twidth / $currwidth;   // Length Ratio For Height 
        $newwidth = $twidth;   // Width Is Equal To Max Width 
        $newheight = $currheight * $zoom;   // Creates The New Height 
      } 
      $dimg = imagecreate($newwidth, $newheight);   // Make New Image For Thumbnail 
      imagetruecolortopalette($simg, false, 256);   // Create New Color Pallete 
      $palsize = ImageColorsTotal($simg); 
      for ($i = 0; $i < $palsize; $i++) {   // Counting Colors In The Image 
       $colors = ImageColorsForIndex($simg, $i);   // Number Of Colors Used 
       ImageColorAllocate($dimg, $colors['red'], $colors['green'], $colors['blue']);   // Tell The Server What Colors This Image Will Use 
      } 
      imagecopyresized($dimg, $simg, 0, 0, 0, 0, $newwidth, $newheight, $currwidth, $currheight);   // Copy Resized Image To The New Image (So We Can Save It) 
      imagejpeg($dimg, "$tdir" . $url);   // Saving The Image 
      imagedestroy($simg);   // Destroying The Temporary Image 
      imagedestroy($dimg);   // Destroying The Other Temporary Image 
      print 'Image thumbnail created successfully.';   // Resize successful 
    } else { 
      print '<font color="#FF0000">ERROR: Unable to upload image.</font>';   // Error Message If Upload Failed 
    } 
  } else { 
    print '<font color="#FF0000">ERROR: Wrong filetype (has to be a .jpg or .jpeg. Yours is ';   // Error Message If Filetype Is Wrong 
    print $file_ext;   // Show The Invalid File's Extention 
    print '.</font>'; 
  } 
} ?>

The thing is that this script uses:

  <form method="post" action="addphoto.php?subpage=upload" enctype="multipart/form-data">

Which I assume is necessary, so how can I get the imagefile (image name)in this script to magically appear in the above script to go into the database field - image_name?

I can change the database field name to imagefile but I still have to get it in there.

Thanks.

David