Form post problem

PHP programming forum. Ask questions or help people concerning PHP code. Don't understand a function? Need help implementing a class? Don't understand a class? Here is where to ask. Remember to do your homework!

Moderator: General Moderators

Post Reply
JammeH
Forum Newbie
Posts: 3
Joined: Thu Aug 07, 2008 4:21 am

Form post problem

Post by JammeH »

Hi guys,

Firstly I'd like to say that this forum looks awesome and a really great idea for php developers to share their knowledge.

Unfortunate I'm rather inexperienced and could do with a pointer in the right direction.

I'm starting to write code myself (without the help of books etc.) and failing miserably...

I was wondering if anybody could help me with the following code. It does direct to adduserdone.php but it doesnt input the data into mysql database.

Cheers,
Jamie

Code: Select all

<?
include("dbstuff.inc");
    $cxn = mysql_connect($host,$user,$password,$database)
    or die("Couldn't connect to server");
    mysql_select_db($database);
if($_POST['formid'] != "true")
    {   
        echo '
        <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Untitled Document</title><style type="text/css">
<!--
body {
    margin-left: 0px;
    margin-top: 0px;
    margin-right: 0px;
    margin-bottom: 0px;
}
.style1 {
    font-family: tahoma;
    color: #0F7D04;
    font-size: 10px;
}
.style2 {font-size: 12px}
.style4 {font-family: tahoma; color: #0F7D04; font-size: 14px; font-weight: bold; }
.style5 {
    font-family: tahoma;
    color: #0F7D04;
    font-size: 12px;
    font-weight: bold;
}
.style8 {color: #0F7D04; font-size: 12px; font-family: tahoma;}
-->
</style></head>
 
<body>
<form id="form" name="form" method="post" action="">
<table width="788" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td><div align="center"><img src="http://www.lsrag.co.uk/images/admin/adduser.jpg"></div></td>
  </tr>
  <tr>
    <td><table width="788" border="0" cellspacing="0" cellpadding="0">
      <tr>
        <td colspan="3">
            <label></label>
            <div align="center"><span class="style5">Account Information</span><br />
              <br />
            </div>        </td>
      </tr>
      <tr>
        <td width="40"><p align="center" class="style4">1</p></td>
        <td width="214"><span class="style1"><span class="style2">Username</span><br />
          Enter the desired username to be created</span></td>
        <td width="534">
            <label>
            <input name="addusername" type="text" id="addusername" size="45" maxlength="45" />
            </label>        </td>
      </tr>
      <tr>
        <td><p align="center" class="style4">2</p></td>
        <td><span class="style1"><span class="style2">Name</span><br />
          Enter the users\' first name</span></td>
        <td>
            <label>
            <input name="addfirstname" type="text" id="addfirstname" size="45" maxlength="45" />
            </label>        </td>
      </tr>
      <tr>
        <td><p align="center" class="style4">3</p></td>
        <td><span class="style1"><span class="style2">Surname</span><br />
          Enter the users\' surname</span></td>
        <td>
            <label>
            <input name="addsurname" type="text" id="addsurname" size="45" maxlength="45" />
            </label>        </td>
      </tr>
      <tr>
        <td><p align="center" class="style4">4</p></td>
        <td><span class="style1"><span class="style2">Email Address</span><br />
          Enter the users\' email address</span></td>
        <td>
            <label>
            <input name="addemail" type="text" id="addemail" size="45" maxlength="45" />
            </label>        </td>
      </tr>
      <tr>
        <td><p align="center" class="style4">5</p></td>
        <td><span class="style1"><span class="style2">Mobile Number</span><br />
          Enter the users\' mobile number</span></td>
        <td>
            <label>
            <input name="addmobile" type="text" id="addmobile" size="45" maxlength="45" />
            </label>        </td>
      </tr>
      <tr>
        <td><p align="center" class="style4">6</p></td>
        <td><span class="style1"><span class="style2">Hall</span><br />
          Select the users\' hall</span></td>
        <td>
            <label>
            <select name="addhall" id="addhall">
              <option selected="selected">Butler Court</option>
              <option value="Cayley">Cayley</option>
              <option value="David Collett">David Collett</option>
              <option value="Elvyn Richards">Elvyn Richards</option>
              <option value="Falkner Eggington">Falkner Eggington</option>
              <option value="Faraday">Faraday</option>
              <option value="Harry French">Harry French</option>
              <option value="Hazlerigg Rutland">Hazlerigg Rutland</option>
              <option value="Royce">Royce</option>
              <option value="Rutherford">Rutherford</option>
              <option value="Telford">Telford</option>
              <option value="The Holt">The Holt</option>
              <option value="Towers">Towers</option>
              <option value="William Morris">William Morris</option>
              <option value="Towles Mill">Towles Mill</option>
              <option value="Community">Community</option>
            </select>
            </label>          </td>
      </tr>
      <tr>
        <td><p align="center" class="style4">7</p></td>
        <td><span class="style1"><span class="style2">Password</span><br />
          Enter a password for the user</span></td>
        <td><label>
          <input name="addpassword" type="password" id="addpassword" size="45" maxlength="45" />
          </label>
        </td>
      </tr>
      <tr>
        <td><p align="center" class="style4">8</p></td>
        <td><span class="style1"><span class="style2">ID Number</span><br />
          Users ID Number (Exclude the A)</span></td>
        <td>
            <label>
            <input name="addidnumber" type="text" id="addidnumber" size="45" maxlength="45" />
            </label>        </td>
      </tr>
      <tr>
        <td colspan="3">
              <label></label>        </td>
        </tr>
      <tr>
        <td colspan="3">
              <label></label>
                  <div align="center">
                    <p><span class="style5">Permissions</span><br />  
                    </p>
                    <table width="788" border="0" cellspacing="0" cellpadding="0">
                      <tr>
                        <td width="39">&nbsp;</td>
                        <td width="280" class="style8">Add User</td>
                        <td width="50" class="style5"><label>
                          <input type="checkbox" name="adduser" id="adduser" />
                        </label></td>
                        <td width="50" class="style5">&nbsp;</td>
                        <td width="280" class="style8">Edit Forum</td>
                        <td width="50"><input type="checkbox" name="editforum" id="editforum" /></td>
                        <td width="39">&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Edit User</td>
                        <td class="style5"><input type="checkbox" name="edituser" id="edituser" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">Delete Forum</td>
                        <td><input type="checkbox" name="deleteforum" id="deleteforum" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Delete User</td>
                        <td class="style5"><input type="checkbox" name="deleteuser" id="deleteuser" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">Add Raid</td>
                        <td><input type="checkbox" name="addraid" id="addraid" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">List User</td>
                        <td class="style5"><input type="checkbox" name="listuser" id="listuser" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">Edit Raid</td>
                        <td><input type="checkbox" name="editraid" id="editraid" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Find User</td>
                        <td class="style5"><input type="checkbox" name="finduser" id="finduser" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">Delete Raid</td>
                        <td><input type="checkbox" name="deleteraid" id="deleteraid" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Add Main News</td>
                        <td class="style5"><input type="checkbox" name="addmainnews" id="addmainnews" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">Add Marshalling</td>
                        <td><input type="checkbox" name="addmarshalling" id="addmarshalling" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Edit Main News</td>
                        <td class="style5"><input type="checkbox" name="editmainnews" id="editmainnews" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">Edit Marshalling</td>
                        <td><input type="checkbox" name="editmarshalling" id="editmarshalling" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Delete Main News</td>
                        <td class="style5"><input type="checkbox" name="deletemainnews" id="deletemainnews" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">Delete Marshalling</td>
                        <td><input type="checkbox" name="deletemarshalling" id="deletemarshalling" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Add Event News</td>
                        <td class="style5"><input type="checkbox" name="addeventnews" id="addeventnews" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">Add Main Calendar Event</td>
                        <td><input type="checkbox" name="addmaincalendarevent" id="addmaincalendarevent" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Edit Event News</td>
                        <td class="style5"><input type="checkbox" name="editeventnews" id="editeventnews" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">Add Hall Calendar Event</td>
                        <td><input type="checkbox" name="addhallcalendarevent" id="addhallcalendarevent" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Delete Event News</td>
                        <td class="style5"><input type="checkbox" name="deleteeventnews" id="deleteeventnews" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">Edit Main Calendar Event</td>
                        <td><input type="checkbox" name="editmaincalendarevent" id="editmaincalendarevent" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Add Hall News</td>
                        <td class="style5"><input type="checkbox" name="addhallnews" id="addhallnews" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">Edit Hall Calendar Event</td>
                        <td><input type="checkbox" name="edithallcalendarevent" id="edithallcalendarevent" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Edit Hall News</td>
                        <td class="style5"><input type="checkbox" name="edithallnews" id="edithallnews" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">Delete Main Calendar Event</td>
                        <td><input type="checkbox" name="deletemaincalendarevent" id="deletemaincalendarevent" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Delete Hall News</td>
                        <td class="style5"><input type="checkbox" name="deletehallnews" id="deletehallnews" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">Delete Hall Calendar Event</td>
                        <td><input type="checkbox" name="deletehallcalendarevent" id="deletehallcalendarevent" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Add Forum Posts</td>
                        <td class="style5"><input type="checkbox" name="addforumposts" id="addforumposts" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">View Administration Control Panel</td>
                        <td><input type="checkbox" name="viewadministrationcontrolpanel" id="viewadministrationcontrolpanel" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Edit Forum Posts</td>
                        <td class="style5"><input type="checkbox" name="editforumposts" id="editforumposts" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">View User Administration</td>
                        <td><input type="checkbox" name="viewuseradministration" id="viewuseradministration" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Add Important Forum Posts</td>
                        <td class="style5"><input type="checkbox" name="addimportantforumposts" id="addimportantforumposts" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">View News Administration</td>
                        <td><input type="checkbox" name="viewnewsadministration" id="viewnewsadministration" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Edit Important Forum Posts</td>
                        <td class="style5"><input type="checkbox" name="editimportantforumposts" id="editimportantforumposts" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">View Forum Administration</td>
                        <td><input type="checkbox" name="viewforumadministration" id="viewforumadministration" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Delete Forum Posts</td>
                        <td class="style5"><input type="checkbox" name="deleteforumposts" id="deleteforumposts" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">View Raid Administration</td>
                        <td><input type="checkbox" name="viewraidadministration" id="viewraidadministration" /></td>
                        <td>&nbsp;</td>
                      </tr>
                      <tr>
                        <td>&nbsp;</td>
                        <td class="style8">Add Forum</td>
                        <td class="style5"><input type="checkbox" name="addforum" id="addforum" /></td>
                        <td class="style5">&nbsp;</td>
                        <td class="style8">View Calendar Administration</td>
                        <td><input type="checkbox" name="viewcalendaradministration" id="viewcalendaradministration" /></td>
                        <td>&nbsp;</td>
                      </tr>
                    </table>
                    <p>
                      <input type="hidden" name="formid" value="true" /><input type="submit" name="Add User" id="Add User" value="Add User" />
                    </p>
              </div>        </td>
        </tr>
 
    </table></td>
  </tr>
  <tr>
    <td><div align="center">
      
      
      </div></td>
  </tr>
</table></form></body></html>';
    }
else
    {
$addusername = $_POST["username"];
$addfirstname = $_POST["firstname"];
$addsurname = $_POST["surname"];
$addemail = $_POST["email"];
$addmobile = $_POST["mobile"];
$addhall = $_POST["hall"];
$addpassword = $_POST["password"];
$addidnumber = $_POST["idnumber"];
$adduser = $_POST["adduser"];
$edituser = $_POST["edituser"];
$deleteuser = $_POST["deleteuser"];
$listuser = $_POST["listuser"];
$finduser = $_POST["finduser"];
$addmainnews = $_POST["addmainnews"];
$editmainnews = $_POST["editmainnews"];
$deletemainnews = $_POST["deletemainnews"];
$addeventnews = $_POST["addeventnews"];
$editeventnews = $_POST["editeventnews"];
$deleteeventnews = $_POST["deleteeventnews"];
$addhallnews = $_POST["addhallnews"];
$edithallnews = $_POST["edithallnews"];
$deletehallnews = $_POST["deletehallnews"];
$addforumposts = $_POST["addforumposts"];
$editforumposts = $_POST["editforumposts"];
$addimportantforumposts = $_POST["addimportantforumposts"];
$editimportantforumposts = $_POST["editimportantforumposts"];
$deleteforumposts = $_POST["deleteforumposts"];
$addforum = $_POST["addforum"];
$editforum = $_POST["editforum"];
$deleteforum = $_POST["deleteforum"];
$addraid = $_POST["addraid"];
$editraid = $_POST["editraid"];
$deleteraid = $_POST["deleteraid"];
$addmarshalling = $_POST["addmarshalling"];
$editmarshalling = $_POST["editmarshalling"];
$deletemarshalling = $_POST["deletemarshalling"];
$addmaincalendarevent = $_POST["addmaincalendarevent"];
$addhallcalendarevent = $_POST["addhallcalendarevent"];
$editmaincalendarevent = $_POST["editmaincalendarevent"];
$edithallcalendarevent = $_POST["edithallcalendarevent"];
$deletemaincalendarevent = $_POST["deletemaincalendarevent"];
$deletehallcalendarevent = $_POST["deletehallcalendarevent"];
$viewadministrationcontrolpanel = $_POST["viewadministrationcontrolpanel"];
$viewuseradministration = $_POST["viewuseradministration"];
$viewnewsadministration = $_POST["viewnewsadministration"];
$viewforumadministration = $_POST["viewforumadministration"];
$viewraidadministration = $_POST["viewraidadministration"];
$viewcalendaradministration = $_POST["viewcalendaradministration"];
    $sql = "INSERT INTO User (username,firstname,surname,email,mobile,hall,password,idnumber,adduser,edituser,deleteuser,listuser,finduser,addmainnews,editmainnews,deletemainnews,addeventnews,editeventnews,deleteeventnews,addhallnews,edithallnews,deletehallnews,addforumposts,editforumposts,addimportantforumposts,editimportantforumposts,deleteforumposts,addforum,editforum,deleteforum,addraid,editraid,deleteraid,addmarshalling,editmarshalling,deletemarshalling,addmaincalendarevent,addhallcalendarevent,editmaincalendarevent,edithallcalendarevent,deletemaincalendarevent,deletehallcalendarevent,viewadministrationcontrolpanel,viewuseradministration,viewnewsadministration,viewforumadministration,viewraidadministration,viewcalendaradministration) VALUES ('$addusername','$addfirstname','$addsurname','$addemail','$addmobile','$addhall','$addpassword','$addidnumber','$adduser','$edituser','$deleteuser','$listuser','$finduser','$addmainnews','$editmainnews','$deletemainnews','$addeventnews','$editeventnews','$deleteeventnews','$addhallnews','$edithallnews','$deletehallnews','$addforumposts','$editforumposts','$addimportantforumposts','$editimportantforumposts','$deleteforumposts','$addforum','$editforum','$deleteforum','$addraid','$editraid','$deleteraid','$addmarshalling','$editmarshalling','$deletemarshalling','$addmaincalendarevent','$addhallcalendarevent','$editmaincalendarevent','$edithallcalendarevent','$deletemaincalendarevent','$deletehallcalendarevent','$viewadministrationcontrolpanel','$viewuseradministration','$viewnewsadminsitration','$viewforumadministration','$viewraidadministration','$viewcalendaradministration')";
$result = mysql_query($sql);
header("Location: adduserdone.php");
    }
 ?>
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Form post problem

Post by jaoudestudios »

What error are you getting? Make sure all errors are turn on for testing.

Echo out one of the POST to make sure it is coming through.

Change your sql query too...

Code: Select all

 
...VALUES ('".$addusername."','".$addfirstname."','".$addsurname."'...
 
NB: on your production server make sure you filter all data coming in before you send it to the database otherwise people can delete your entire database!
JammeH
Forum Newbie
Posts: 3
Joined: Thu Aug 07, 2008 4:21 am

Re: Form post problem

Post by JammeH »

Sorry can you explain in simple "dumbass" terms as I'm really inexperienced.

Not getting an error at all.
Just its not writing data to mysql.
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Form post problem

Post by jaoudestudios »

Sure no problem.

Dont send the sql query to the database.

echo it out to the screen and copy and paste it here, so I cant take a look and see what is going wrong.
JammeH
Forum Newbie
Posts: 3
Joined: Thu Aug 07, 2008 4:21 am

Re: Form post problem

Post by JammeH »

Meh :( Still no clue, can you tell me what code to put where :(
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Form post problem

Post by jaoudestudios »

Comment out the $result line and the header line. Above this add echo $sql.

Example below...

Code: Select all

 
.....
$viewraidadministration = $_POST["viewraidadministration"];
$viewcalendaradministration = $_POST["viewcalendaradministration"];
$sql = "INSERT INTO User (username,firstname,surname,email,mobile,hall,password,idnumber,adduser,edituser,deleteuser,listuser,finduser,addmainnews,editmainnews,deletemainnews,addeventnews,editeventnews,deleteeventnews,addhallnews,edithallnews,deletehallnews,addforumposts,editforumposts,addimportantforumposts,editimportantforumposts,deleteforumposts,addforum,editforum,deleteforum,addraid,editraid,deleteraid,addmarshalling,editmarshalling,deletemarshalling,addmaincalendarevent,addhallcalendarevent,editmaincalendarevent,edithallcalendarevent,deletemaincalendarevent,deletehallcalendarevent,viewadministrationcontrolpanel,viewuseradministration,viewnewsadministration,viewforumadministration,viewraidadministration,viewcalendaradministration) VALUES ('$addusername','$addfirstname','$addsurname','$addemail','$addmobile','$addhall','$addpassword','$addidnumber','$adduser','$edituser','$deleteuser','$listuser','$finduser','$addmainnews','$editmainnews','$deletemainnews','$addeventnews','$editeventnews','$deleteeventnews','$addhallnews','$edithallnews','$deletehallnews','$addforumposts','$editforumposts','$addimportantforumposts','$editimportantforumposts','$deleteforumposts','$addforum','$editforum','$deleteforum','$addraid','$editraid','$deleteraid','$addmarshalling','$editmarshalling','$deletemarshalling','$addmaincalendarevent','$addhallcalendarevent','$editmaincalendarevent','$edithallcalendarevent','$deletemaincalendarevent','$deletehallcalendarevent','$viewadministrationcontrolpanel','$viewuseradministration','$viewnewsadminsitration','$viewforumadministration','$viewraidadministration','$viewcalendaradministration')";
echo $sql;
# $result = mysql_query($sql);
# header("Location: adduserdone.php");
.....
 
Post Reply