HTML Form Processing PHP help

[dhendler]

I'm having trouble processing an HTML form. I can't get the data to post into the mysql database and I keep getting a Parse ErrorParse Error in "file" on line 18.

 

Here's the code for the HTML form:

<form action="process.php" method="post">
        <table width="410" border="0" cellpadding="2">
          <tr>
            <td nowrap="nowrap"><div align="right">Trakker # </div></td>
            <td nowrap="nowrap"><INPUT TYPE= text NAME="idnum" ID="idnum" SIZE=30 MAXLENGTH=100 />            </td>
          </tr>
          <tr>
            <td nowrap="nowrap"><div align="right">Found By : </div></td>
            <td nowrap="nowrap"><INPUT TYPE=TEXT NAME="found_by" ID="found_by" SIZE=30 MAXLENGTH=100  /></td>
          </tr>
          <tr>
            <td nowrap="nowrap"><div align="right">Date Found : </div></td>
            <td nowrap="nowrap"><?php DateDropDown($size=90,$default="DropDate"); ?></td>
          </tr>
          <tr>
            <td nowrap="nowrap"><div align="right">City / Town : </div></td>
            <td nowrap="nowrap"><INPUT TYPE=TEXT NAME="city" ID="city" SIZE=30 MAXLENGTH=100 /></td>
          </tr>
          <tr>
            <td nowrap="nowrap"><div align="right">State / Province : </div></td>
            <td nowrap="nowrap"><INPUT TYPE=TEXT NAME="state" ID="state" SIZE=30 MAXLENGTH=100 />            </td>
          </tr>
          <tr>
            <td><div align="right">Country : </div></td>
            <td><select name="country" ID='country'>
              <option selected="selected" value="">(Select a Country) </option>
              <option value="USA">United States of America </option>
                   //bunch of countries listed
              <option value="UNK">Not Listed___________________________ </option>
            </select>            </td>
          </tr>
          <tr>
            <td nowrap="nowrap"> </td>
            <td nowrap="nowrap"><div align="left">
              <input type="submit" name="submit" value="submit" />
            </div></td>
          </tr>
        </table>
        </form>

 

The date field is a javascript drop down thing.

 

Here's the process.php code:

<?php
if(isset($_POST['submit']))
{
include 'config_dino.php';//connection info

mysql_connect($server, $db_user, $db_pass);
@mysql_select_db($database) or die( "Unable to select database");

/*Posted information from HTML (dinos.php) form*/
$idnum=$_POST['idnum'];
$found_by=$_POST['found_by'];
$city=$_POST['city'];
$state=$_POST['state'];
$country=$_POST['country'];

/*Insert posted information into bugz database - Table Dino*/
mysql_query("INSERT INTO 'dino' ('idnum', 'found_by', $city', 'state', 'country') VALUES ('$idnum', '$found_by', '$city', '$state', '$country')")
}
?>

 

I also want to redirect the user to "trakked.html" after the form has been processed, but I have no idea how.

 

I'm obviously very new to PHP, thank you in advance for your help.

 

 

[BlueSkyIS]

your parse error may be a missing semi-colon after mysql_query()

 

I also want to redirect the user to "trakked.html" after the form has been processed, but I have no idea how.

 

header("location: trakked.html");
exit;

[micah1701]

missing a ; after your mysql_query line.

 

does that help?

[steve448]

Change:

 

mysql_query("INSERT INTO 'dino' ('idnum', 'found_by', $city', 'state', 'country') VALUES ('$idnum', '$found_by', '$city', '$state', '$country')")

 

To:

 

mysql_query("INSERT INTO dino (idnum, found_by, city, state, country) VALUES ('$idnum', '$found_by', '$city', '$state', '$country')");

 

Basically you don't want the quotes around the table columns only the inserted variables.

 

 

To redirect the page you can use:

 

header("Location: trakked.html");

 

 

[BlueSkyIS]

oh yep good catch on the quoted table. if you really want something around the table name, use backticks ala: `tablename`

[dhendler]

Right on!  I'm not getting that Parse Error anymore, it was the semi-colon that fixed it

 

The data is being passed onto the database now too!  You guys/gals rock!

 

I am also having trouble trying to figure out how to reference the drop down date results with PHP since it's a custom function.

 

Here's the complete form with the function.

 

<script language="JavaScript" type="text/javascript">
<?php function DateDropDown($size=90,$default="DropDate") {
   // $size = the number of days to display in the drop down
   // $default = Todays date in m:d:Y format (SEE DATE COMMAND ON WWW.PHP.NET)
   // $skip = if set then the program will skip Sundays and Saturdays
   $skip=1;
   echo "<select name=dropdate STYLE=\"font-family: arial;\">\n";
   for ($i = 0; $i <= $size; $i++) {
      $theday = mktime (0,0,0,date("m") ,date("d")+$i ,date("Y"));
      $option=date("D M j, Y",$theday);
      $value=date("m:d:Y",$theday);
      $dow=date("D",$theday);
      if ($dow=="Sun") {
         echo "<option disabled> </option>\n";
      }
      if ($value == $default) {
         $selected="SELECTED";
      } else {
         $selected="";
      }
      if (($dow!="Sun" and $dow!="Sat") or !$skip) {
         echo "<option value=\"$value\" $selected>$option</option>\n";
      }
   }
   
   echo "</select>\n";
}
?>
<form action="process.php" method="post">
        <table width="410" border="0" cellpadding="2">
          <tr>
            <td nowrap="nowrap"><div align="right">Trakker # </div></td>
            <td nowrap="nowrap"><INPUT TYPE= text NAME="idnum" ID="idnum" SIZE=30 MAXLENGTH=100 />            </td>
          </tr>
          <tr>
            <td nowrap="nowrap"><div align="right">Found By : </div></td>
            <td nowrap="nowrap"><INPUT TYPE=TEXT NAME="found_by" ID="found_by" SIZE=30 MAXLENGTH=100  /></td>
          </tr>
          <tr>
            <td nowrap="nowrap"><div align="right">Date Found : </div></td>
            <td nowrap="nowrap"><?php DateDropDown($size=90,$default="DropDate"); ?></td>
          </tr>
          <tr>
            <td nowrap="nowrap"><div align="right">City / Town : </div></td>
            <td nowrap="nowrap"><INPUT TYPE=TEXT NAME="city" ID="city" SIZE=30 MAXLENGTH=100 /></td>
          </tr>
          <tr>
            <td nowrap="nowrap"><div align="right">State / Province : </div></td>
            <td nowrap="nowrap"><INPUT TYPE=TEXT NAME="state" ID="state" SIZE=30 MAXLENGTH=100 />            </td>
          </tr>
          <tr>
            <td><div align="right">Country : </div></td>
            <td><select name="country" ID='country'>
              <option selected="selected" value="">(Select a Country) </option>
              <option value="USA">United States of America </option>
                   //bunch of countries listed
              <option value="UNK">Not Listed___________________________ </option>
            </select>            </td>
          </tr>
          <tr>
            <td nowrap="nowrap"> </td>
            <td nowrap="nowrap"><div align="left">
              <input type="submit" name="submit" value="submit" />
            </div></td>
          </tr>
        </table>
        </form>