upload file?

sandbudd · June 27, 2008

I have a information form that I need to allow people to upload files. Here are the two files I use to upload which works except for the upload.

form.php

<html>
<style type="text/css">
<!--
.style1 {	font-size: 14px;
color: #0000FF;
}
-->
</style>
<body>



<form action="submit.php" method="post">
<table width="848" border="0" cellpadding="2" cellspacing="0">
  <tr>
    <td width="58"><label for="customer">Name:</label>
        <input name="hidden" type="hidden" id="hiddenField">
      </label></td>
    <td width="322"><input type="text" name="customer" id="customer" size="50"></td>
    <td width="62"><label for="company">Company:</label>
    <td width="347"><input type="text" name="company" id="company" size="50"></td>
  </tr>
  <tr>
    <td>
    <label for="address">Address:</label>
    <td>
    <input type="text" name="address" id="address" size="50">
    </td>
    <td><label for="City">City:</label></td>
    <td><input type="text" name="city" id="city" size="50"></td>
  </tr>
  <tr>
    <td><label for="state">State:</label></td>
    <td><select name="state">
      <option value="alabama">Alabama</option>
      <option value="Alaska">Alaska</option>
      <option value="Arizona">Arizona</option>
      <option value="Arkansas">Arkansas</option>
      <option value="California">California</option>
      <option value="Colorado">Colorado</option>
      <option value="Connecticut">Connecticut</option>
      <option value="Delaware">Delaware</option>
      <option value="Florida">Florida</option>
      <option value="Georgia">Georgia</option>
      <option value="Hawaii">Hawaii</option>
      <option value="idaho">idaho</option>
      <option value="Illinois">Illinois</option>
      <option value="Indiana">Indiana</option>
      <option value="Iowa">Iowa</option>
      <option value="Kansas">Kansas</option>
      <option value="Kentucky">Kentucky</option>
      <option value="Louisiana">Louisiana</option>
      <option value="Maine">Maine</option>
      <option value="Maryland">Maryland</option>
      <option value="Massachusetts">Massachusetts</option>
      <option value="Michigan">Michigan</option>
      <option value="Minnesota">Minnesota</option>
      <option value="Mississippi">Mississippi</option>
      <option value="Missouri">Missouri</option>
      <option value="Montana">Montana</option>
      <option value="Nebraska">Nebraska</option>
      <option value="Nevada">Nevada</option>
      <option value="New Hampshire">New Hampshire</option>
      <option value="New Jersey">New Jersey</option>
      <option value="New Mexico">New Mexico</option>
      <option value="New York">New York</option>
      <option value="North Carolina">North Carolina</option>
      <option value="North Dakota">North Dakota</option>
      <option value="Ohio">Ohio</option>
      <option value="Oklahoma">Oklahoma</option>
      <option value="Oregon">Oregon</option>
      <option value="Pennsylvania">Pennsylvania</option>
      <option value="Rhode Island">Rhode Island</option>
      <option value="South Carolina">South Carolina</option>
      <option value="South Dakota">South Dakota</option>
      <option value="Tennessee">Tennessee</option>
      <option value="Texas">Texas</option>
      <option value="Utah">Utah</option>
      <option value="Vermont">Vermont</option>
      <option value="Virginia">Virginia</option>
      <option value="Washington">Washington</option>
      <option value="West Virginia">West Virginia</option>
      <option value="Wisconsin">Wisconsin</option>
      <option value="Wyoming">Wyoming</option>
    </select></td>
    <td><label for="zip">Zip:</label></td>
    <td><input type="text" name="zip" id="zip" size="50"></td>
  </tr>
  <tr>
    <td><label for="email">Email:</label></td>
    <td colspan="3"><input type="text" name="email" id="email" size="50"></td>
  </tr>
  <tr>
    <td><label for="phone">Phone:</label></td>
    <td><input type="text" name="phone" id="phone" size="50"></td>
    <td><label for="fax">Fax:</label></td>
    <td><input type="text" name="fax" id="fax" size="50"></td>
  </tr>
  <tr>
    <td colspan="4"><span class="style1">Process requested (please check all that apply):</span></td>
  </tr>
  <tr>
    <td colspan="2"><input type="checkbox" name="type2" id="checkbox2">
      Type II (Conventional Anodize) </td>
    <td colspan="2"><input type="checkbox" name="type3" id="checkbox3">
      Type III (Hard Coat Anodize)</td>
  </tr>
  <tr>
    <td colspan="2"><input type="checkbox" name="burnish" id="checkbox4">
      (Burnish, Deburr)</td>
    <td colspan="2"><input type="checkbox" name="chromate" id="checkbox5">
      Chromate Conversion</td>
  </tr>
  <tr>
    <td colspan="2"><input type="checkbox" name="hex" id="checkbox6">
      Chromate Conversion Hex &#8211; free</td>
    <td colspan="2"><input type="checkbox" name="impregnation" id="checkbox7">
      Impregnation</td>
  </tr>
  <tr>
    <td colspan="2"><input type="checkbox" name="strip" id="checkbox8">
      Strip</td>
    <td colspan="2"> </td>
  </tr>
  <tr>
    <td colspan="2"><label for="part">Part Number:</label></td>
    <td colspan="2"><input type="text" name="part" id="part" size="50"></td>
  </tr>
  <tr>
    <td colspan="2"><label for="description">Part Description (part name or basic size):</label></td>
    <td colspan="2"><input type="text" name="description" id="description" size="50"></td>
  </tr>
  <tr>
    <td><label for="alloy">Alloy:</label></td>
    <td><input type="text" name="alloy" id="alloy" size="50"></td>
    <td><label for="quantity">Quantity:</label></td>
    <td><input type="text" name="quantity" id="quantity" size="50"></td>
  </tr>
  <tr>
    <td><label for="spec">Specification:</label></td>
    <td><input type="text" name="spec" id="spec" size="50"></td>
    <td><label for="color">Color:</label></td>
    <td><input type="text" name="color" id="color" size="50"></td>
  </tr>
  <tr>
    <td colspan="2"><span class="style1">How did you hear about us?</span></td>
    <td colspan="2"> </td>
  </tr>
  <tr>
    <td colspan="4"><table width="100%" border="0" cellpadding="2" cellspacing="0">
      <tr>
        <td colspan="2"><input type="checkbox" name="repeat_customer" id="checkbox9">
          I am a repeat customer</td>
        <td width="23%"><input type="checkbox" name="isearch" id="checkbox10">
          Internet Search</td>
        <td width="16%"><label for="label">Internet Directory:</label></td>
        <td width="28%"><input type="text" name="idir" id="idir" size="30"></td>
      </tr>
      <tr>
        <td width="7%"><label for="referral">Referral:</label></td>
        <td width="26%"><input type="text" name="referral" id="referral" size="30"></td>
        <td><input type="checkbox" name="yellow" id="checkbox">
          Yellow Pages</td>
        <td><label for="trade">Trade Show:</label></td>
        <td><input type="text" name="trade" id="trade" size="30"></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td> </td>
    <td colspan="3"> </td>
  </tr>
  <tr>
    <td><label for="other">Other:</label></td>
    <td colspan="3"><textarea name="other" cols="80" id="other"></textarea></td>
  </tr>
  <tr>
    <td colspan="2"> </td>
    <td colspan="2"> </td>
  </tr>
  <tr>
    <td colspan="4"><table width="100%" border="0" cellpadding="2" cellspacing="0">
      <tr>
        <td width="25%"><label for="notes">Notes / Special Requests:</label></td>
        <td colspan="2"><textarea name="notes" cols="80" id="notes"></textarea></td>
      </tr>
      <tr>
        <td> </td>
        <td width="43%"> </td>
        <td width="32%"> </td>
      </tr>
      
      <tr>
        <td> </td>
        <td colspan="2"> </td>
      </tr>
      <tr>
        <td>Upload File:</td>
        <td colspan="2"><input type="file" name="upload" id="upload"></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td></p>
        <label for="label"></label></td>
    <td colspan="3"> </td>
  </tr>
  <tr>
    <td colspan="2"> </td>
    <td colspan="2"> </td>
  </tr>
  <tr>
    <td colspan="2"><input type="submit" value="Submit"></td>
    <td colspan="2"> </td>
  </tr>
</table>
</form>
</body>
</html>

submit.php

<?php
$db_host = ''; // don't forget to change 
$db_user = ''; 
$db_pwd = '';

$database = '';
$table = '';


if (!mysql_connect($db_host, $db_user, $db_pwd))
    die("Can't connect to database");

if (!mysql_select_db($database))
    die("Can't select database");

$sql="INSERT INTO ae_gallery (customer, company, address, city, state, zip, email, phone, fax, type2, type3, burnish, chromate, hex, impregnation, strip, part, description, alloy, quantity, spec, color, repeat_customer, isearch, idir, referral, yellow, trade, other, notes, ext)
VALUES
('$_POST[customer]','$_POST[company]','$_POST[address]','$_POST[city]','$_POST[state]','$_POST[zip]','$_POST[email]','$_POST[phone]','$_POST[fax]','$_POST[type2]','$_POST[type3]','$_POST[burnish]','$_POST[chromate]','$_POST[hex]','$_POST[impregnation]','$_POST[strip]','$_POST[part]','$_POST[description]','$_POST[alloy]','$_POST[quantity]','$_POST[spec]','$_POST[color]','$_POST[repeat_customer]','$_POST[isearch]','$_POST[idir]','$_POST[referral]','$_POST[yellow]','$_POST[trade]','$_POST[other]','$_POST[notes]','$_POST[fax]','$_POST[ext]')";
if (!mysql_query($sql))
  {
  die('Error: ' . mysql_error());
  }
echo "1 record added";

?>

Tchelo · June 27, 2008

In your html, you should use

<form action="submit.php" method="post" enctype="multipart/form-data">

Sign In

upload file?

Recommended Posts

sandbudd

Link to comment

Share on other sites

Tchelo

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information