Untitled

<html>
<head>
<title>GTA V Mission Info - Database Insert</title>
</head>
<body>
<?php
            //Variables for connecting to your database.
            //These variable values come from your hosting account.
            $hostname = "HIDDEN";
            $username = "HIDDEN";
            $dbname = "GTAVMissions";

            //These variable values need to be changed by you before deploying
            $password = "HIDDEN";
            $usertable = "Missions";

            //Connecting to your database
            mysql_connect($hostname, $username, $password) OR DIE ("Unable to
            connect to database! Please try again later.");
            mysql_select_db($dbname);

        $MissionName=$_POST['MissionName'];
            $Contact=$_POST['Contact'];
            $Rank=$_POST['Rank'];
            $CashPayout=$_POST['CashPayout'];
            $RPPayout=$_POST['RPPayout'];
            $MinPlayers=$_POST['MinPlayers'];
        $MaxPlayers=$_POST['MaxPlayers'];
            $Desc=$_POST['Desc'];
            $Tips=$_POST['Tips'];

    if(isset($_GET['process']))
    {
        $query = "INSERT INTO `Missions` (MissionName, Contact, Rank, CashPayout, RPPayout, MinPlayers, MaxPlayers, Desc, Tips) VALUES ('$MissionName', '$Contact', '$Rank', '$CashPayout', '$RPPayout', '$MinPlayers', '$MaxPlayers', '$Desc', '$Tips')";
        //echo $query; exit;
        $result = mysql_query($query) or die(mysql_error());
        if(!$result)
        {
        $msg = "Failed to add mission to database. Please check your information and try again.";
        }
        else
        {
        $msg = "Successfully added mission to database!";
        header("location:ClientList.php?m=".$msg);
        }
    }
?>

<table width="700" border="1">
<form id="MissionForm" name="MissionForm" method="post" action="insert.php?process">
  <tr>
    <td>Mission Name</td>
    <td><label>

      <input name="MissionName" type="text" id="MissionName" />
    </label></td>
  </tr>
  <tr>
    <td>Contact</td>
    <td>
      <label width=100%>
        <select name="Contact" type="text" id="Contact">
        <option value="Gerald">Gerald</option>
        <option value="Lamar">Lamar</option>
        <option value="Lester">Lester</option>
        <option value="Martin">Martin</option>
        <option value="Ron">Ron</option>
        <option value="Simeon">Simeon</option>
        <option value="Trevor">Trevor</option>
    </select>
        </label>
        </td>
  </tr>
  <tr>
    <td>Rank Required</td>
    <td>
      <label>
        <input name="Rank" type="text" id="Rank" />
        </label>
        </td>
  </tr>
  <tr>
    <td>Cash Payout (After First Attempt)</td>
    <td>
      <label>
      $<input name="CashPayout" type="text" id="CashPayout" />
      </label>
        </td>
  </tr>
  <tr>
    <td>Base RP Payout</td>
    <td>
      <label>
        <input name="RPPayout" type="text" id="RPPayout" />
        </label>
       </td>
  </tr>
  <tr>
    <td>Minimun Players</td>
    <td>
      <label>
        <input name="MinPlayers" type="text" id="MinPlayers" />
        </label>
        </td>
  </tr>
  <tr>
    <td>Maximun Players</td>
    <td>
      <label>
        <input name="MaxPlayers" type="text" id="MaxPlayers" />
        </label>
        </td>
  </tr>
<tr>
    <td>Mission Description</td>
    <td>
      <label>
        <input name="Desc" type="text" id="Desc" />
        </label>
        </td>
  </tr>
  <tr>
    <td>Mission Tips</td>
    <td>
      <label>
        <input name="Tips" type="text" id="Tips" />
        </label>
        </td>
  </tr>
  <tr>
    <td>
      <label>
      <input type="submit" name="Submit" value="Submit" />
        </label>
    </form>    </td>
  </tr>
</table>
</body>
</html>