Reply to thread

Message

<blockquote data-quote="JayC" data-source="post: 254760" data-attributes="member: 36373">Hey guys I am trying to create a Job Application page so when people fill it out it will go directly into the database. I heavily edited someones release to look like this:<img src="http://img547.imageshack.us/img547/4540/u1ix.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /> This is my TPL code:[CODE]&lt;div class=&quot;habblet-container &quot;&gt;&nbsp; &nbsp; &nbsp;&nbsp; &lt;div class=&quot;cbb clearfix pixellightblue &quot;&gt;&lt;h2 class=&quot;title&quot;&gt;%shortname% Trial Apps&lt;/h2&gt;&lt;div class=&quot;box-content&quot;&gt;&lt;center&gt;&lt;b&gt;&lt;h2&gt;%shortname% Hotel Moderator&lt;/b&gt;&lt;/h2&gt;&lt;/center&gt;&lt;div style=&quot;text-align: right;&quot;&gt;&lt;/div&gt;&lt;br /&gt;%shortname% Hotel is run by highly trained staff, and we're always hiring staff so that the hotel is always safe and having fun! You may apply for staff below, but you need to fill in the information truthfuly, else your application will be denied! Also, please make sure you're at least &lt;b&gt;13&lt;/b&gt; years of age before you apply for staff!&lt;br /&gt;&lt;br /&gt;&lt;center&gt;You must also meet the following requirements:&lt;/center&gt;&lt;br /&gt;&lt;br /&gt; &lt;i&gt;&amp;bull; Able to moderate the hotel for at least 3 hours a day or 10 hours a week!&lt;/i&gt;&lt;br&gt;&lt;i&gt;&amp;bull; Advertise and host events frequently!&lt;/i&gt;&lt;br&gt;&lt;i&gt;&amp;bull; Have read the rules and understand them entirely!&lt;/i&gt;&lt;br&gt;&lt;i&gt;&amp;bull; Will advertise to help gain users!&lt;/i&gt;&lt;br&gt;&lt;i&gt;&amp;bull; Invite your friends and help people understand what %shortname% is!&lt;/i&gt;&lt;br&gt;&nbsp; &lt;hr&gt;&nbsp; &lt;br /&gt;&nbsp; &lt;?php$name = USER_NAME;if(isset($_POST['apply'])){&nbsp; // Post the inputs&nbsp; &nbsp; $username&nbsp; = mysql_real_escape_string($_POST['username']);&nbsp; &nbsp; $useremail&nbsp; = mysql_real_escape_string($_POST['email']);&nbsp; &nbsp; $date&nbsp; &nbsp; &nbsp; = mysql_real_escape_string($_POST['date']);&nbsp; &nbsp; $month&nbsp; &nbsp; &nbsp; = mysql_real_escape_string($_POST['month']);&nbsp; &nbsp; $year&nbsp; &nbsp; &nbsp; = mysql_real_escape_string($_POST['year']);&nbsp; &nbsp; $why&nbsp; &nbsp; &nbsp; &nbsp; = mysql_real_escape_string($_POST['why']);&nbsp; &nbsp; $exp&nbsp; &nbsp; &nbsp; &nbsp; = mysql_real_escape_string($_POST['exp']);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; // Insert the application to database&nbsp;&nbsp; mysql_query(&quot;INSERT INTO jobapps (username, email, dob, why, exp) VALUES ('$username', '$useremail', '$date/$month/$year', '$why', '$exp')&quot;);&nbsp; &nbsp; &nbsp;&nbsp; // Echo a success message 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; else{&nbsp; &nbsp; $email = (&quot;SELECT * FROM users WHERE username='$name'&quot;);&nbsp; $run&nbsp; = mysql_query($email)or die(mysql_error());&nbsp; $array = mysql_fetch_array($run);?&gt;&lt;center&gt;&lt;form method=&quot;post&quot;&gt;&nbsp;&nbsp; &lt;strong&gt;Your Hotel username&lt;/strong&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;&nbsp; &nbsp; &lt;br /&gt;&nbsp; &nbsp; &lt;strong&gt;A active email address&lt;/strong&gt;&nbsp; &nbsp; &lt;br&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; value=&quot;&lt;?php echo $array['mail']; ?&gt;&quot; name=&quot;email&quot; /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;strong&gt;Position you're applying for&lt;/strong&gt;&nbsp; &nbsp; &lt;br&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;input type=&quot;text&quot; disabled value=&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Trial Mod&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot; name=&quot;email&quot; /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;strong&gt;Real date of birth Example: 12/01/1990&lt;/strong&gt;&nbsp; &nbsp; &lt;br&gt;&nbsp;&nbsp; &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; &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; &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;&nbsp;&nbsp; &nbsp; &nbsp; &lt;br /&nbsp; &nbsp; &gt;&lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;strong&gt;Why would we choose you to become staff here at our hotel?&lt;/strong&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp; &nbsp; &lt;textarea style=&quot;width: 250px; margin-left: 15px;&quot; name=&quot;why&quot;&gt;&nbsp; &nbsp; &lt;/textarea&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;strong&gt;What past experience have you had?&lt;/strong&gt; (&lt;i&gt;If any&lt;/i&gt;)&nbsp;&nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;textarea style=&quot;width: 250px; margin-left: 15px;&quot; name=&quot;exp&quot;&gt;&lt;/textarea&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;br /&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;input type=&quot;submit&quot; name=&quot;apply&quot; value=&quot;Submit your application now!&quot;&nbsp; /&gt;&nbsp;&nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &lt;?php&nbsp; }&nbsp; ?&gt;&lt;/center&gt;&nbsp; &nbsp; &lt;/div&gt;&lt;/div&gt;&lt;/div&gt;&lt;/div&gt;[/CODE]and This is the error:[CODE]Notice: Undefined variable: username in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27Notice: Undefined variable: useremail in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27Notice: Undefined variable: date in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27Notice: Undefined variable: month in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27Notice: Undefined variable: year in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27Notice: Undefined variable: why in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27Notice: Undefined variable: exp in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27Thank you very much for submitting your staff application, you'll be notified through email if you are considered![/CODE]I appreciate all the help you guys provide <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" /> Hopefully someone can help with this! Thanks</blockquote>

[QUOTE="JayC, post: 254760, member: 36373"] Hey guys I am trying to create a Job Application page so when people fill it out it will go directly into the database. I heavily edited someones release to look like this: [IMG]http://img547.imageshack.us/img547/4540/u1ix.png[/IMG] This is my TPL code: [CODE]<div class="habblet-container "> <div class="cbb clearfix pixellightblue "> <h2 class="title">%shortname% Trial Apps</h2> <div class="box-content"> <center><h2>%shortname% Hotel Moderator</h2> </center> <div style="text-align: right;"> </div> %shortname% Hotel is run by highly trained staff, and we're always hiring staff so that the hotel is always safe and having fun! You may apply for staff below, but you need to fill in the information truthfuly, else your application will be denied! Also, please make sure you're at least 13 years of age before you apply for staff! <center>You must also meet the following requirements:</center> • Able to moderate the hotel for at least 3 hours a day or 10 hours a week! • Advertise and host events frequently! • Have read the rules and understand them entirely! • Will advertise to help gain users! • Invite your friends and help people understand what %shortname% is! <hr> <?php $name = USER_NAME; if(isset($_POST['apply'])){ // Post the inputs $username = mysql_real_escape_string($_POST['username']); $useremail = mysql_real_escape_string($_POST['email']); $date = mysql_real_escape_string($_POST['date']); $month = mysql_real_escape_string($_POST['month']); $year = mysql_real_escape_string($_POST['year']); $why = mysql_real_escape_string($_POST['why']); $exp = mysql_real_escape_string($_POST['exp']); // Insert the application to database mysql_query("INSERT INTO jobapps (username, email, dob, why, exp) VALUES ('$username', '$useremail', '$date/$month/$year', '$why', '$exp')"); // Echo a success message echo "Thank you very much for submitting your staff application, you'll be notified through email if you are considered!"; } else{ $email = ("SELECT * FROM users WHERE username='$name'"); $run = mysql_query($email)or die(mysql_error()); $array = mysql_fetch_array($run) ;?><center> <form method="post"> Your Hotel username <input type="text" readonly value="<?php echo $name ?>" name="username" /> A active email address <input type="text" value="<?php echo $array['mail']; ?>" name="email" /> Position you're applying for <input type="text" disabled value=" Trial Mod " name="email" /> Real date of birth Example: 12/01/1990 <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 to become staff here at our hotel? <textarea style="width: 250px; margin-left: 15px;" name="why"> </textarea> What past experience have you had? (If any) <textarea style="width: 250px; margin-left: 15px;" name="exp"></textarea> <input type="submit" name="apply" value="Submit your application now!" /> <?php } ?></center> </div> </div> </div> </div>[/CODE] and This is the error: [CODE] Notice: Undefined variable: username in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27 Notice: Undefined variable: useremail in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27 Notice: Undefined variable: date in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27 Notice: Undefined variable: month in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27 Notice: Undefined variable: year in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27 Notice: Undefined variable: why in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27 Notice: Undefined variable: exp in C:\xampp\htdocs\includes\tpl\mod-form.tpl on line 27 Thank you very much for submitting your staff application, you'll be notified through email if you are considered![/CODE] I appreciate all the help you guys provide :) Hopefully someone can help with this! Thanks [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members