jedney Posted February 20, 2008 Share Posted February 20, 2008 Hello. I have ran into a problem, but I dont know where the problem is. I have a form, and the data in the form I would like to post to my database. After I submit the form it says my thank you message, but nothing adds to the table. Here is my coding Coding for my Form <? // DISPLAY RECRUITMENT STATUS INFORMATION $query = "SELECT * FROM about"; $result = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_array($result)) { ?> <form method="post" action="processapp.php"><td valign="top\" class="NewsHeader"> Recruitment Application</td> </tr> <tr> <td class="norm">Recruitment Status: <span class="normbold"><?php echo"". $row['recruitment'] ."" ?><?php } ?></span></td> </tr> <tr> <td class="norm">Thank you for showing interest in joining Next Level Gaming. Please complete the below recruitment application. Sending this application is an acknowledgement that you have read our guidelines.</td> </tr> <tr> <td class="norm"> </td> </tr> <tr> <td class="normbold">Personal Information</td> </tr> <tr> <td class="norm">Your Real First Name: <label> <input name="rlname" type="text" class="datetime" id="rlname" size="15" maxlength="15" /> </label></td> </tr> <tr> <td class="norm">Birthdate: <input name="dob" type="text" class="datetime" id="dob" size="10" maxlength="10" /> (ex. 01-01-2008)</td> </tr> <tr> <td class="norm">Location: <input name="location" type="text" class="datetime" id="location" size="15" maxlength="50" /></td> </tr> <tr> <td class="norm">Connection: <label> <select name="connection" class="datetime" id="connection"> <option value=" "> </option> <option value="T1" selected="selected">T1 or Higher</option> <option value="Cable">Cable</option> <option value="DSL">DSL</option> <option value="Dial-Up">Dial-Up</option> </select> </label></td> </tr> <tr> <td class=\"norm\"> </td> </tr> <tr> <td class="normbold">Contact Information</td> </tr> <tr> <td class="norm">Email: <input name="email" type="text" class="datetime" id="email" size="25" maxlength="25" /></td> </tr> <tr> <td class="norm">AIM: <input name="aim" type="text" class="datetime" id="aim" size="25" maxlength="25" /></td> </tr> <tr> <td class="norm">MSN: <input name="msn" type="text" class="datetime" id="msn" size="25" maxlength="25" /></td> </tr> <tr> <td class="norm">Yahoo: <input name="yahoo" type="text" class="datetime" id="yahoo" size="25" maxlength="25" /></td> </tr> <tr> <td class="norm">Xfire: <input name="xfire" type="text" class="datetime" id="xfire" size="25" maxlength="25" /></td> </tr> <tr> <td class="norm">GSC: <input name="gsc" type="text" class="datetime" id="gsc" size="25" maxlength="25" /></td> </tr> <tr> <td class="norm">Steam: <input name="steam" type="text" class="datetime" id="steam" size="25" maxlength="50" /></td> </tr> <tr> <td class="norm"> </td> </tr> <tr> <td class="normbold">Game Information</td> </tr> <tr> <td class="norm">In-Game Name: <input name="name" type="text" class="datetime" id="name" size="25" maxlength="25" /></td> </tr> <tr> <td class="norm"><p>Experience: <label> <select name="exp" class="datetime" id="exp"> <option selected="selected"> </option> <option value="DoDb">Day of Defeat Beta</option> <option value="DoD 1.0">Day of Defeat 1.0 (Retail)</option> <option value="DoD 1.1">Day of Defeat 1.1 (Steam)</option> <option value="DoD 1.2">Day of Defeat 1.2</option> <option value="DoD 1.3">Day of Defeat 1.3 (Current)</option> </select> </label> </p> </td> </tr> <tr> <td class="norm">Allied Class: <select name="allies" class="datetime" id="allies"> <option value=" " selected="selected"> </option> <option value="Rifleman">Rifleman</option> <option value="Staff Sergeant">Staff Sergeant</option> <option value="Sergeant">Sergeant</option> <option value="Master Sergeant">Master Sergeant</option> <option value="Sniper">Sniper</option> <option value="Support Infantry">Support Infantry</option> <option value="Machine Gunner">Machine Gunner</option> </select></td> </tr> <tr> <td class="norm">Axis Class: <select name="axis" class="datetime" id="axis"> <option value=" " selected="selected"> </option> <option value="Grenadier">Grenadier</option> <option value="Stosstrupe">Stosstrupe</option> <option value="Unteroffizier">Unteroffizier</option> <option value="Sturmtrupe">Sturmtrupe</option> <option value="Scharfshutze">Scharfshutze</option> <option value="MG-34">MG-34</option> <option value="MG-42">MG-42</option> </select></td> </tr> <tr> <td class="norm">Map: <input name="map" type="text" class="datetime" id="map" size="25" maxlength="25" /></td> </tr> <tr> <td class="norm">Game Type: <select name="playertype" class="datetime" id="playertype"> <option value=" "> </option> <option value="Camper">Camper</option> <option value="Pace Controlling">Pace Controlling</option> <option value="All-Around">All-Around</option> <option value="Rusher">Rusher</option> </select></td> </tr> <tr> <td class="norm"> </td> </tr> <tr> <td class="normbold">League Experience</td> </tr> <tr> <td class="norm"><label> <textarea name="leagueexp" id="leagueexp" cols="45" rows="5"></textarea> </label></td> </tr> <tr> <td class="norm">Clan Experience</td> </tr> <tr> <td class="norm"><textarea name="clanexp" id="clanexp" cols="45" rows="5"></textarea></td> </tr> <tr> <td class=\"norm\"> </td> </tr> <tr> <td class="normbold">Account Information</td> </tr> <tr> <td class="norm">Perferred Password: <input name="map2" type="password" class="datetime" id="map2" size="12" maxlength="12" /> (Max 12)</td> </tr> <tr> <td class="norm"><label> <input name="submit" type="submit" class="datetime" id="submit" value="Submit" /> </label></td> </tr> </form> PHP Form Handler Code <? // ADD SLASHES TO FORM OUTPUT SO PHP UNDERSTANDS IT $as_name = addslashes($_POST['name']); $as_allies = addslashes($_POST['allies']); $as_axis = addslashes($_POST['axis']); $as_steamid = addslashes($_POST['steamid']); $as_email = addslashes($_POST['email']); $as_dob = addslashes($_POST['dob']); $as_aol = addslashes($_POST['aol']); $as_yahoo = addslashes($_POST['yahoo']); $as_msn = addslashes($_POST['msn']); $as_xfire = addslashes($_POST['xfire']); $as_gsc = addslashes($_POST['gsc']); $as_steam = addslashes($_POST['steam']); $as_favmap = addslashes($_POST['favmap']); $as_location = addslashes($_POST['location']); $as_connection = addslashes($_POST['connection']); $as_rlname = addslashes($_POST['rlname']); $as_exp = addslashes($_POST['exp']); $as_playertype = addslashes($_POST['playertype']); $as_leagueexp = addslashes($_POST['leagueexp']); $as_clanexp = addslashes($_POST['clanexp']); $as_pass = addslashes($_POST['pass']); //TRIM RESULTS $tr_name = trim('$as_name') ; $tr_allies = trim('$as_allies') ; $tr_axis = trim('$as_axis') ; $tr_steamid = trim('$as_steamid') ; $tr_email = trim('$as_email') ; $tr_dob = trim('$as_dob') ; $tr_aol = trim('$as_aol') ; $tr_yahoo = trim('$as_yahoo') ; $tr_msn = trim('$as_msn') ; $tr_xfire = trim('$as_xfire') ; $tr_gsc = trim('$as_gsc') ; $tr_steam = trim('$as_steam') ; $tr_favmap = trim('$as_favmap') ; $tr_location = trim('$as_location') ; $tr_connection = trim('$as_connection') ; $tr_rlname = trim('$as_rlname') ; $tr_exp = trim('$as_exp') ; $tr_playertype = trim('$as_playertype') ; $tr_leagueexp = trim('$as_leagueexp') ; $tr_clanexp = trim('$as_clanexp') ; $tr_pass = trim('$as_pass') ; $querey = "INSERT INTO roster (ID, name, rank, allies, axis, joindate, steamid, email, aim, yahoo, msn, steam, favmap, rlname, dob, location, connection, xfire, gsc, playertype, leagueexp, clanexp, user, pass) VALUES ('NULL', '$tr_name', 'Recruit', '$tr_allies', '$tr_aaxis', 'NULL', '$tr_steamid', '$tr_email', '$tr_aim', '$tr_yahoo', '$tr_msn', '$tr_steam', '$tr_favmap', '$tr_rlname', '$tr_dob', '$tr_location', '$tr_connection', '$tr_xfire', '$tr_gsc', '$tr_exp', '$tr_playertype', '$tr_leagueexp', '$tr_clanexp', 'NULL', '$tr_pass')"; $result = mysql_query($query); if (mysql_affected_rows()) { echo " Recruitment Application Processed"; echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td class=\"norm\">Thank you, we have recieved your recruitment application and you will recieve a response within 2-3 days. Good luck.</td></td>"; echo "</tr>"; echo "<tr>"; echo "<td></td>"; } else { echo " Recruitment Application Error"; echo "</td>"; echo "</tr>"; echo "<tr>"; echo "<td class=\"norm\">There was a problem processing your application. Please go back and send another one, or email [email protected] with your inquiry to join Next Level Gaming. We have been notified of this error. Error:"; ?> <?php mysql_error(); ?> <?php echo "</td></td>"; echo "</tr>"; echo "<tr>"; echo "<td></td>"; }?> If you need to see this page live, it is at http://www.nlgaming.net/nlgb1/recruitment.php Link to comment https://forums.phpfreaks.com/topic/92161-addint-data-to-mysql-from-form/ Share on other sites More sharing options...
sKunKbad Posted February 20, 2008 Share Posted February 20, 2008 use spell check $querey in your PHP Form Handler Code Link to comment https://forums.phpfreaks.com/topic/92161-addint-data-to-mysql-from-form/#findComment-472102 Share on other sites More sharing options...
jedney Posted February 20, 2008 Author Share Posted February 20, 2008 I caught that, still the same result. Link to comment https://forums.phpfreaks.com/topic/92161-addint-data-to-mysql-from-form/#findComment-472108 Share on other sites More sharing options...
sKunKbad Posted February 20, 2008 Share Posted February 20, 2008 remove $result = and see what happens Link to comment https://forums.phpfreaks.com/topic/92161-addint-data-to-mysql-from-form/#findComment-472117 Share on other sites More sharing options...
revraz Posted February 20, 2008 Share Posted February 20, 2008 Don't rely on this: if (mysql_affected_rows()) It will return -1 if it's an error, which means your IF is true. Get rid of the ID and NULL for the VALUE of the ID, you don't need it since it's set to auto_increment. Echo your query to see what is actually being done. Use mysql_error() after your query to see where it's failing. Link to comment https://forums.phpfreaks.com/topic/92161-addint-data-to-mysql-from-form/#findComment-472121 Share on other sites More sharing options...
jedney Posted February 20, 2008 Author Share Posted February 20, 2008 I have done this and I still get nothing, mysql error gives me nothing. Link to comment https://forums.phpfreaks.com/topic/92161-addint-data-to-mysql-from-form/#findComment-472129 Share on other sites More sharing options...
sKunKbad Posted February 20, 2008 Share Posted February 20, 2008 If you can test your sql directly on the database, from either the command line or phpMyAdmin, it may give you a clue as to why it's not working. If you can't do this, isolate your insert query and check it that way (with mysql_error()) Link to comment https://forums.phpfreaks.com/topic/92161-addint-data-to-mysql-from-form/#findComment-472133 Share on other sites More sharing options...
revraz Posted February 20, 2008 Share Posted February 20, 2008 Post the echo of the query. I have done this and I still get nothing, mysql error gives me nothing. Link to comment https://forums.phpfreaks.com/topic/92161-addint-data-to-mysql-from-form/#findComment-472140 Share on other sites More sharing options...
jedney Posted February 20, 2008 Author Share Posted February 20, 2008 SOLVED I failed to include a field from the DB in my query, so it was trying to enter too many values. Link to comment https://forums.phpfreaks.com/topic/92161-addint-data-to-mysql-from-form/#findComment-472152 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.