Image upload and form submission at same time?

[Kudose]

Here is whats going on. I made a submission form for a auto dealer and I want him to be able to upload an image using the same form.

Like this.

He enters all the car info, clicks browse to select image, clicks submit and it uploads the image and the info he entered into the DB.

If so, anyone know how?

I dont need a detailed script. Just a simple:

<form action="post.php" method="post" name="post">

Milage: <input type="text" maxlength="12" name="milage">
Image: <input type="file" name="???"> 

//I get lost on that one too (image file name), how is the DB supposed to know how to save it as, or how I should call it to be displayed on the site...?

<input type="submit" value="submit">
</form>

Anyone able to help?

[cosminb]

did you searched this forum ????
have you tried google ???

Searched the web for upload php script. Results 1 - 10 of about 674,000. Search took 0.09 seconds.

[Kudose]

I am not an idiot. I know what google is. Thanks though.

I get an error saying the form messed up when I use this script and fill out everything completely. Can anyone tell me why? I wil put //'s next to the line that it supposedly messes up at.

This one is my form page:

  <table width="80%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" background="images/shadowcar.jpg">
    <tr> 

      <td height="475" width="100%" valign="center"> 
        <table width="100%" height="231">
          <tr>
                        <td><table width="100%" border="0">

          <tr> 
            <td height="110"> <form action="post.php" method="post" enctype="multipart/form-data" name="postcar">
                <table width="66%" border="0">
      <tr> 
        <td width="43%"><strong><font size="2">Vehicle Identification Number:</font></strong></td>
        <td width="57%"><input name="vin" type="text" id="vin" size="24" maxlength="36"></td>
      </tr>
      <tr> 
        <td><strong><font size="2">Vehicle Year:</font></strong></td>
        <td><input name="year" type="text" id="year" size="24" maxlength="4"></td>
      </tr>
      <tr> 
        <td><font size="2"><strong>Vehicle Make:</strong></font></td>
        <td><input name="make" type="text" id="make" size="24" maxlength="12"></td>
      </tr>
      <tr> 
        <td><strong><font size="2">Vehicle Model:</font></strong></td>
        <td><input name="model" type="text" id="model" size="24" maxlength="24"></td>
      </tr>
      <tr> 
        <td><strong><font size="2">Vehicle Color:</font></strong></td>
                    <td><select name="color" id="color">
                        <option selected>Black</option>
                        <option>Blue</option>
                        <option>Red</option>
                        <option>Yellow</option>
                        <option>Gray</option>
                        <option>Green</option>
                        <option>Purple</option>
                        <option>Orange</option>
                        <option>White</option>
                      </select></td>
      </tr>
      <tr> 
                    <td><strong><font size="2">Automatic/Standard:</font></strong></td>
                    <td><select name="transmission" id="transmission">
                        <option selected>Automatic</option>
                        <option>Standard</option>
                      </select></td>
      </tr>
      <tr> 
                    <td><strong><font size="2">How many miles:</font></strong></td>
        <td><input name="miles" type="text" id="miles" size="24" maxlength="6"></td>
      </tr>
      <tr> 
                    <td><strong><font size="2">Price to customer:</font></strong></td>
        <td><input name="price" type="text" id="price" size="24" maxlength="6"></td>
      </tr>
      <tr> 
                    <td><strong><font size="2">Engine type:</font></strong></td>
        <td><input name="engine" type="text" id="engine" size="24" maxlength="24"></td>
      </tr>
      <tr>
                    <td><font size="2"><strong>4WD FWD RWD:</strong></font></td>
                    <td><select name="driveshaft" id="driveshaft">
                        <option>4WD</option>
                        <option>FWD</option>
                        <option selected>RWD</option>
                      </select></td>
      </tr><tr> 
                    <td><strong><font size="2">How many doors::</font></strong></td>
                    <td>
                      <select name="doors" id="doors">
                        <option>2 Door</option>
                        <option selected>4 Door</option>
                        <option>Hatchback</option>
                      </select></td>
      </tr>
      <tr>
                    <td><font size="2"><strong>Extra Specifications (CD, Sunroof..):</strong></font></td>
                    <td><input name="extras" type="text" id="extras" size="24" maxlength="249"></td>
      </tr>
	  <tr>
                    <td><font size="2"><strong>Image of vehicle to upload:</strong></font></td>
                    <td> <input name="image" type="file" id="image"></td>
      </tr>
    </table>
                <table width="66%" border="0" align="left">
                  <tr> 
                    <td width="43%"><left>
                        <input name="Reset" type="reset" id="Reset" value="Reset">
                      </left></td>
                    <td width="57%"><right><input name="submit" type="submit" id="submit2" value="Insert into Database"></right></td>
                  </tr>
                </table>
    <p align="left"><br>
  </form>
              <p>&nbsp;</p>
                    </td>
                </tr>

              </table></td>
                      </tr>
                    </table> </tr>
              </table>
            </td>
          </tr>
        </table>
      </td>
    </tr>
    <tr valign="top"> 
      <td height="50" colspan="2"> 
        <div align="right"> 
          <table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr> 
              <td background="/images/bar3.gif" height="21"> 

              </td>
            </tr>
          </table>

[Kudose]

This one is my actions page.

<? include('dbinfo.inc.php'); ?>

<?
//right here is where it checks everything.  If I add an echo after the checks it says something is missing when nothing is.

if($vin=='' || $year=='' || $make=='' || $model=='' || $color=='' || $transmission=='' || $miles=='' || $price=='' || $engine=='' || $driveshaft=='' || $doors==''){

?>

<? include('hiddencode.php'); ?>
<? include('top.php'); ?>
<? include ('left.php'); ?>

  <table width="80%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" background="images/shadowcar.jpg">
    <tr> 

      <td height="475" width="100%" valign="center"> 
        <table width="100%" height="231">
          <tr>
                        <td><table width="100%" border="0">
                <tr>
                  <td height="110"><p><font size="1" face="Tahoma"><strong>You fucked up the form G.  <a href="addcar.php">Try again foo!</a></strong></font></p>
                    </td>
                </tr>

              </table></td>
                      </tr>
                    </table> </tr>
              </table>
            </td>
          </tr>
        </table>
      </td>
    </tr>
    <tr valign="top"> 
      <td height="50" colspan="2"> 
        <div align="right"> 
          <table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr> 
              <td background="/images/bar3.gif" height="21"> 

              </td>
            </tr>
          </table><? include('bottom.php'); ?>

<?

 } else {

include('dbinfo.inc.php');
$query=mysql_query("SELECT * FROM vehicle WHERE vin='$vin'");
$rows = mysql_num_rows($query) or die(mysql_error());
if($rows > "0"){

?>

<? include('hiddencode.php'); ?>
<? include('top.php'); ?>
<? include ('left.php'); ?>

  <table width="80%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" background="images/shadowcar.jpg">
    <tr> 

      <td height="475" width="100%" valign="center"> 
        <table width="100%" height="231">
          <tr>
                        <td><table width="100%" border="0">
                <tr>
                  <td height="110"><p><font size="1" face="Tahoma"><strong>That VIN is already in the DB foo.  Someone fucked up hardcore man!</strong></font></p>
                    </td>
                </tr>

              </table></td>
                      </tr>
                    </table> </tr>
              </table>
            </td>
          </tr>
        </table>
      </td>
    </tr>
    <tr valign="top"> 
      <td height="50" colspan="2"> 
        <div align="right"> 
          <table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr> 
              <td background="/images/bar3.gif" height="21"> 

              </td>
            </tr>
          </table><? include('bottom.php'); ?>

<?

 } else {

mysql_query("INSERT INTO vehicle (vin, year, make, model, color, transmission, miles, price, engine, driveshaft, doors, extras, image)
VALUES ('$vin', '$year', '$make', '$model', '$color', '$transmission', '$miles', '$price', '$engine', '$driveshaft', '$doors', '$extras', '$image')") or die(mysql_error()); 

?>
<? include('hiddencode.php'); ?>
<? include('top.php'); ?>
<? include ('left.php'); ?>


  <table width="80%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#000000" background="images/shadowcar.jpg">
    <tr> 

      <td height="475" width="100%" valign="center"> 
        <table width="100%" height="231">
          <tr>
                        <td><table width="100%" border="0">
                <tr>
                  <td height="110"><p><font size="1" face="Tahoma"><strong>Werd 
                homie. Your shit worked!</strong></font></p>
                    </td>
                </tr>

              </table></td>
                      </tr>
                    </table> </tr>
              </table>
            </td>
          </tr>
        </table>
      </td>
    </tr>
    <tr valign="top"> 
      <td height="50" colspan="2"> 
        <div align="right"> 
          <table width="100%" border="0" cellspacing="0" cellpadding="0">
            <tr> 
              <td background="/images/bar3.gif" height="21"> 

              </td>
            </tr>
          </table>
<? include('bottom.php'); ?>
<?


 }} ?> 

Thanks to everyone in advance.

[cosminb]

if($rows > "0")

should be

if($rows > 0)

....
put this at the begining of your script(before the long if)

echo '<pre>';
print_r($_POST);

to see if all your variables are right.

[mtimdog]

Also, register_globals might be off so $vin == '' won't work.

Try $_POST['vin'] == '' ....with all your posted variables.

[Kudose]

no dice. Even tried the echo <pre> thing, it just gave me a BIG blank spot, then gave me the rest of the pafe telling me I jacked up. If you dont mind since you have seen the script, can you try the form?

http://kudose.ionichost.com/addcar.php

[Kudose]

no dice on the $_POST[XXX] either. Thanks though 🙁

[mtimdog]

I tried it with and without an image and it said it worked....what are you inputting...or how large is your file?

[Kudose]

I just fixed it. Now all I need to do is figure out how to get 2 variables to combine.

This is what I mean.

$vin = 123456;
$type = .jpg;

this is what I need:

$image = $vin+$type;

Can you help with that?

Thanks a million already!

[Kudose]

Also, I cant tell what you entered. Everything in my DB of your submission is blank. I figured out the variable combining too. thanks all for everything.

[fandelem]

Originally posted by Kudose
I just fixed it. Now all I need to do is figure out how to get 2 variables to combine.

This is what I mean.

$vin = 123456;
$type = .jpg;

this is what I need:

$image = $vin+$type;

Can you help with that?

Thanks a million already!

$image_filename = $vin . $type;

( the . is the concat operator in php)

cheers,

k.