Reply to thread

Message

<blockquote data-quote="Nehalem" data-source="post: 254940" data-attributes="member: 37120">I found multiple things in the original code that doesn't even make any sense.But here you go, replace the whole FORM and PHP SCRIPT with this:[PHP]&lt;?php$name = USER_NAME;if(isset($_POST['apply'])) {&nbsp; &nbsp; $job_username = mysql_real_escape_string($_POST['username']);&nbsp; &nbsp; $job_email = mysql_real_escape_string($_POST['useremail']);&nbsp; &nbsp; $job_date = mysql_real_escape_string($_POST['date']);&nbsp; &nbsp; $job_month = mysql_real_escape_string($_POST['month']);&nbsp; &nbsp; $job_year = mysql_real_escape_string($_POST['year']);&nbsp; &nbsp; $job_why = mysql_real_escape_string($_POST['why']);&nbsp; &nbsp; $job_exp = mysql_real_escape_string($_POST['exp']);&nbsp; &nbsp; $job_do = mysql_query(&quot;INSERT INTO jobapps (username, email, dob, why, exp) VALUES ('&quot;.$job_username.&quot;', '&quot;.$job_email.&quot;', '&quot;.$job_date/$job_month/$job_year.&quot;', '&quot;.$job_why.&quot;', '&quot;.$job_exp.&quot;')&quot;);&nbsp; &nbsp; if($job_do) {&nbsp; &nbsp; &nbsp; &nbsp; echo &quot;&lt;strong&gt;Thank you very much for submitting your staff application, you'll be notified through email if you are considered!&lt;/strong&gt;&quot;;&nbsp; &nbsp; } else {&nbsp; &nbsp; &nbsp;&nbsp; die(mysql_error());&nbsp; &nbsp; }}?&gt;&lt;form method=&quot;post&quot; action=&quot;&quot;&gt;&nbsp; &nbsp; &lt;b&gt;Your hotel username&lt;/b&gt;&lt;br /&gt;&nbsp; &nbsp; &lt;input type=&quot;text&quot; readonly value=&quot;&lt;?php echo $name; ?&gt;&quot; name=&quot;username&quot;&gt;&lt;br /&gt;&nbsp; &nbsp; &lt;b&gt;An active email address&lt;/b&gt;&lt;br /&gt;&nbsp; &nbsp; &lt;input type=&quot;text&quot; name=&quot;useremail&quot;&gt;&lt;br /&gt;&nbsp; &nbsp; &lt;b&gt;Position your applying for&lt;/b&gt;&lt;br /&gt;&nbsp; &nbsp; &lt;input type=&quot;text&quot; disabled value=&quot;Trial Mod&quot;&gt;&lt;br /&gt;&nbsp; &nbsp; &lt;b&gt;Real deate of birth&lt;/b&gt;&lt;br /&gt;&nbsp; &nbsp; &lt;input type=&quot;text&quot; style=&quot;width: 40px;&quot; name=&quot;date&quot; placeholder=&quot;Date&quot; maxlength=&quot;2&quot; /&gt;&nbsp; &nbsp; &lt;input type=&quot;text&quot; style=&quot;width: 40px;&quot; name=&quot;month&quot; placeholder=&quot;Month&quot; maxlength=&quot;2&quot; /&gt;&nbsp; &nbsp; &lt;input type=&quot;text&quot; style=&quot;width: 80px;&quot; name=&quot;year&quot; placeholder=&quot;Year&quot; maxlength=&quot;4&quot; /&gt;&lt;br /&gt;&nbsp; &nbsp; &lt;b&gt;Why would we choose you?&lt;/b&gt;&lt;br /&gt;&nbsp; &nbsp; &lt;textarea style=&quot;width: 250px; margin-left: 15px;&quot; name=&quot;why&quot;&gt;&lt;/textarea&gt;&lt;br /&gt;&nbsp; &nbsp; &lt;b&gt;What experience have you had?&lt;/b&gt;&lt;br /&gt;&nbsp; &nbsp; &lt;textarea style=&quot;width: 250px; margin-left: 15px;&quot; name=&quot;exp&quot;&gt;&lt;/textarea&gt;&lt;br /&gt;&nbsp; &nbsp; &lt;input type=&quot;submit&quot; name=&quot;apply&quot; value=&quot;Submit&quot;&gt;&lt;/form&gt;[/PHP]Tell me if it works or not.</blockquote>

[QUOTE="Nehalem, post: 254940, member: 37120"] I found multiple things in the original code that doesn't even make any sense. But here you go, replace the [B]whole FORM and PHP SCRIPT[/B] with this: [PHP]<?php $name = USER_NAME; if(isset($_POST['apply'])) { $job_username = mysql_real_escape_string($_POST['username']); $job_email = mysql_real_escape_string($_POST['useremail']); $job_date = mysql_real_escape_string($_POST['date']); $job_month = mysql_real_escape_string($_POST['month']); $job_year = mysql_real_escape_string($_POST['year']); $job_why = mysql_real_escape_string($_POST['why']); $job_exp = mysql_real_escape_string($_POST['exp']); $job_do = mysql_query("INSERT INTO jobapps (username, email, dob, why, exp) VALUES ('".$job_username."', '".$job_email."', '".$job_date/$job_month/$job_year."', '".$job_why."', '".$job_exp."')"); if($job_do) { echo "Thank you very much for submitting your staff application, you'll be notified through email if you are considered!"; } else { die(mysql_error()); } } ?> <form method="post" action=""> Your hotel username <input type="text" readonly value="<?php echo $name; ?>" name="username"> An active email address <input type="text" name="useremail"> Position your applying for <input type="text" disabled value="Trial Mod"> Real deate of birth <input type="text" style="width: 40px;" name="date" placeholder="Date" maxlength="2" /> <input type="text" style="width: 40px;" name="month" placeholder="Month" maxlength="2" /> <input type="text" style="width: 80px;" name="year" placeholder="Year" maxlength="4" /> Why would we choose you? <textarea style="width: 250px; margin-left: 15px;" name="why"></textarea> What experience have you had? <textarea style="width: 250px; margin-left: 15px;" name="exp"></textarea> <input type="submit" name="apply" value="Submit"> </form>[/PHP] Tell me if it works or not. [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members