Page 1 of 1

thumbnail file field doesn't upload or add path to DB

Posted: Fri Mar 21, 2003 8:59 pm
by fariquzeli
My thumbnail field in my form won't work, it doesn't upload a file, give me an error, or put the path of the file into the database. It's as if I haven't even set that field in the form or something.

I'm almost 100% sure my filenames are correct and field names are correct. I know for sure the code is right because its an exact replica of a field called picture, and the picture field works wonderfully, it sends the path to the mysql database, and uploads the file to the directory necessary.

Here's the code

Code: Select all

<?php
if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) {
copy($HTTP_POST_FILES['picture']['tmp_name'], "../images/".$HTTP_POST_FILES['picture']['name']) or die("tis broken");
$imagepath = "http://www.pancorp.com/images/".$HTTP_POST_FILES['picture']['name']."";
if (isset($HTTP_POST_VARS['thumbnail'])) {
copy($HTTP_POST_FILES['thumbnail']['tmp_name'], "../images/s/".$HTTP_POST_FILES['thumbnail']['name']) or die("could not copy2");
$thumbpath = "http://www.pancorp.com/images/s/".$HTTP_POST_FILES['thumbnail']['name']."";
}
  $insertSQL = sprintf("INSERT INTO products (id, type, category, picture, thumbnail, partA, nameA, priceA, partB, nameB, priceB, partC, nameC, priceC, partD, nameD, priceD, partE, nameE, priceE, partF, nameF, priceF, info, featured) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($HTTP_POST_VARS['id'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['type'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['category'], "text"),
                       GetSQLValueString($imagepath, "text"),
                       GetSQLValueString($thumbpath, "text"),
					   GetSQLValueString($HTTP_POST_VARS['partA'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['nameA'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['priceA'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['partB'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['nameB'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['priceB'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['partC'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['nameC'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['priceC'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['partD'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['nameD'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['priceD'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['partE'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['nameE'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['priceE'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['partF'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['nameF'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['priceF'], "text"),					   					   
                       GetSQLValueString($HTTP_POST_VARS['info'], "text"),
                       GetSQLValueString(isset($HTTP_POST_VARS['featured']) ? "true" : "", "defined","'Y'","'N'"));

  mysql_select_db($database_userLogin, $userLogin);
  $Result1 = mysql_query($insertSQL, $userLogin) or die(mysql_error());

  $insertGoTo = "http://www.pancorp.com/siteadmin/admin.php";
  if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}

?>

If you need to see the code for the form I can post that too.

The thumbnail field is called simply thumbnail while the picture field is called picture. If you can help and/or figure this out I'd greatly appreciate it. Then again I'm sure it's just some simple mistake that I'm not seeing.

Posted: Sun Mar 23, 2003 5:07 pm
by fariquzeli
anyone?

Posted: Sun Mar 23, 2003 5:54 pm
by Zoram
Can we see the form code?

Posted: Sun Mar 23, 2003 6:03 pm
by fariquzeli

Code: Select all

<?php require_once('Connections/userLogin.php'); ?>
<?php

$editFormAction = $HTTP_SERVER_VARS['PHP_SELF'];
if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
  $editFormAction .= "?" . $HTTP_SERVER_VARS['QUERY_STRING'];
}

if ((isset($HTTP_POST_VARS["MM_insert"])) && ($HTTP_POST_VARS["MM_insert"] == "form1")) {

copy($HTTP_POST_FILES['picture']['tmp_name'], "../images/".$HTTP_POST_FILES['picture']['name']) or die("tis broken");
$imagepath = "http://www.pancorp.com/images/".$HTTP_POST_FILES['picture']['name']."";

copy($HTTP_POST_FILES['thmb']['tmp_name'], "../images/s/".$HTTP_POST_FILES['thmb']['name']) or die("could not copy2");
$thumbpath = "http://www.pancorp.com/images/s/".$HTTP_POST_FILES['thmb']['name']."";

  $insertSQL = sprintf("INSERT INTO products (id, type, category, picture, thumbnail, partA, nameA, priceA, partB, nameB, priceB, partC, nameC, priceC, partD, nameD, priceD, partE, nameE, priceE, partF, nameF, priceF, info, featured) VALUES (%s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s, %s)",
                       GetSQLValueString($HTTP_POST_VARS['id'], "int"),
                       GetSQLValueString($HTTP_POST_VARS['type'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['category'], "text"),
                       GetSQLValueString($imagepath, "text"),
                       GetSQLValueString($thumbpath, "text"),
					   GetSQLValueString($HTTP_POST_VARS['partA'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['nameA'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['priceA'], "text"),
                       GetSQLValueString($HTTP_POST_VARS['partB'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['nameB'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['priceB'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['partC'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['nameC'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['priceC'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['partD'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['nameD'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['priceD'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['partE'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['nameE'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['priceE'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['partF'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['nameF'], "text"),
					   GetSQLValueString($HTTP_POST_VARS['priceF'], "text"),					   					   
                       GetSQLValueString($HTTP_POST_VARS['info'], "text"),
                       GetSQLValueString(isset($HTTP_POST_VARS['featured']) ? "true" : "", "defined","'Y'","'N'"));

  mysql_select_db($database_userLogin, $userLogin);
  $Result1 = mysql_query($insertSQL, $userLogin) or die(mysql_error());

  $insertGoTo = "http://www.pancorp.com/siteadmin/admin.php";
  if (isset($HTTP_SERVER_VARS['QUERY_STRING'])) {
    $insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
    $insertGoTo .= $HTTP_SERVER_VARS['QUERY_STRING'];
  }
  header(sprintf("Location: %s", $insertGoTo));
}
?>
<html>
<head>
<title>Add Product - Pancorp.com</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<form method="post" name="form1" action="<?php echo $editFormAction; ?>" enctype="multipart/form-data">
  <table width="796" align="center">
    <tr valign="baseline"> 
      <td width="92" align="right" nowrap><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Type:</font></td>
      <td> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
        <select name="type">
          <option value="PC-1000 Cassette Sleeve /Intensifying Screens">PC-1000 
          Cassette Sleeve/Intensifying Screens</option>
          <option value="Beam Filter Kit">Beam Filter Kit</option>
          <option value="Radio Opaque Marking Tape">Radio Opaque Marking Tape</option>
          <option value="Clear Image Processor Cleaner">Clear Image Processor 
          Cleaner</option>
          <option value="Clean Image Roller Sheets">Clean Image Roller Sheets</option>
          <option value="Star Dip Tank">Star Dip Tank</option>
          <option value="Ambient Light Film Duplicator">Ambient Light Film Duplicator</option>
          <option value="Star Illuminated Film Duplicator">Star Illuminated Film 
          Duplicator</option>
          <option value="Dial Thermometer">Dial Thermometer</option>
          <option value="Pano Shield Lead Apron">Pano Shield Lead Apron</option>
          <option value="Adult Size Lead Poncho">Adult Size Lead Poncho</option>
          <option value="Bite Guides">Bite Guides</option>
          <option value="Remote Switch Kit">Remote Switch Kit</option>
          <option value="Mailing & Filing Envelopes">Mailing & Filing 
          Envelopes</option>
          <option value="Disposable Ear Rod Barriers">Disposable Ear Rod Barriers</option>
          <option value="User Manuals">User Manuals</option>
          <option value="User Videos">User Videos</option>
          <option value="Gleco Solid Waste Trap">Gleco Solid Waste Trap&#8482;</option>
          <option value="Emergency Drug Kit">Emergency Drug Kit</option>
          <option value="Basic Emergency Drug Kit">Basic Emergency Drug Kit</option>
          <option value="FirstSave Automated External Defibrillator">FirstSave&reg; 
          Automated External Defibrillator</option>
          <option value="On Demand Oxygen System">On Demand Oxygen System</option>
          <option value="Oxygen System">Oxygen System</option>
          <option value="Ambu MediBag Resuscitator">Ambu&reg; MediBag&#8482; Resuscitator</option>
          <option value="New Life CPR Resuscitator Kit">New Life CPR Resuscitator 
          Kit</option>
          <option value="XXV First Aid Kit">XXV First Aid Kit</option>
          <option value="Lube Pen Oiler and Drop Applicator">Lube Pen Oiler and 
          Drop Applicator</option>
          <option value="PNEU-CARE: Aerosol Lubricant/Cleaner">PNEU-CARE: Aerosol 
          Lubricant/Cleaner</option>
          <option selected>SELECT</option>
        </select>
        (specific for individual pages)</font></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Category:</font></td>
      <td> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
        <select name="category">
          <option value="FilmCassettesandFilmSupplies">Film, Cassettes & Film 
          Supplies</option>
          <option value="DarkroomChemicalsandCleaners">Darkroom Chemicals & 
          Cleaners</option>
          <option value="DarkroomAccessories">Darkroom Accessories</option>
          <option value="XrayAccessories">X-ray Accessories</option>
          <option value="XrayInstructionalLiterature">X-ray Instructional Literature</option>
          <option value="DentalOfficeProducts">Dental Office Products</option>
          <option value="EmergencyMedicalProducts">Emergency Medical Products</option>
          <option value="HandpieceProductsandRepair">Handpiece Products & 
          Repair</option>
          <option selected>SELECT</option>
        </select>
         (general for product index) </font></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Picture:</font></td>
      <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
        <input type="file" name="picture" value="" size="30">
        </font></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Thumbnail:</font></td>
      <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
        <input name="thmb" type="file" id="thmb" value="" size="30">
        </font></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Part 
        Number A:</font></td>
      <td> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
        <input name="partA" type="text" id="partA" value="" size="15">
        Name A: 
        <input name="nameA" type="text" id="nameA">
        Price A: 
        <input name="priceA" type="text" id="priceA" value="" size="12">
        </font></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Part 
        Number B:</font></td>
      <td> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
        <input name="partB" type="text" id="partB" value="" size="15">
        Name B: 
        <input name="nameB" type="text" id="nameB">
        Price B: 
        <input name="priceB" type="text" id="priceB" value="" size="12">
        </font></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Part 
        Number C:</font></td>
      <td> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
        <input name="partC" type="text" id="partC" value="" size="15">
        Name C: 
        <input name="nameC" type="text" id="nameC">
        Price C: 
        <input name="priceC" type="text" id="priceC" value="" size="12">
        </font></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Part 
        Number D:</font></td>
      <td> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
        <input name="partD" type="text" id="partD" value="" size="15">
        Name D: 
        <input name="nameD" type="text" id="nameD">
        Price D: 
        <input name="priceD" type="text" id="priceD" value="" size="12">
        </font></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Part 
        Number E:</font></td>
      <td> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
        <input name="partE" type="text" id="partE" value="" size="15">
        Name E: 
        <input name="nameE" type="text" id="nameE">
        Price E: 
        <input name="priceE" type="text" id="priceE" value="" size="12">
        </font></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right" valign="top"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Part 
        Number F:</font></td>
      <td> <font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
        <input name="partF" type="text" id="partF" value="" size="15">
        Name F: 
        <input name="nameF" type="text" id="nameF">
        Price F: 
        <input name="priceF" type="text" id="priceF" value="" size="12">
        </font></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right">&nbsp;</td>
      <td>&nbsp;</td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Info: 
        </font></td>
      <td><textarea name="info" cols="80" rows="12" id="info"></textarea></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">Featured:</font></td>
      <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
        <input type="checkbox" name="featured" value="" >
        </font></td>
    </tr>
    <tr valign="baseline"> 
      <td nowrap align="right"><font size="2" face="Verdana, Arial, Helvetica, sans-serif">&nbsp;</font></td>
      <td><font size="2" face="Verdana, Arial, Helvetica, sans-serif"> 
        <input type="submit" value="Add Product">
        </font></td>
    </tr>
  </table>
  <input type="hidden" name="id" value="">
  <input type="hidden" name="MM_insert" value="form1">
</form>
<p>&nbsp;</p>
  
</body>
</html>

Posted: Sun Mar 23, 2003 6:06 pm
by fariquzeli
Fixed it, nevermind

Had to get rid of this line right where the thumbnail field was getting copied:

Code: Select all

<?php
if (isset($HTTP_POST_VARS['thmb'])) 
?>