Mysql - Radio buttons - Server Side

August 1, 201115 yr
Hello viewer.
I am trying to make a script so people can insert a job into a database but nothing is going into the 'contract' field. There are two radio buttons: 1 yes and 1 no. Can someone please correct my code so that either "Yes" or "No" will go into the field instead of nothing. Thank you.
<?php
include ('header.php');
include ('connect.php');
//checks cookies to make sure they are logged in 
if(isset($_COOKIE['ID_my_site'])) 
{ 
$username = $_COOKIE['ID_my_site']; 
$pass = $_COOKIE['Key_my_site']; 
$check = mysql_query("SELECT * FROM accounts WHERE username = '$username'")or die(mysql_error()); 
while($info = mysql_fetch_array( $check )) 	 
{ 
$company = mysql_query("SELECT company FROM accounts WHERE username = '$username'")or die(mysql_error()); 
$company = mysql_result($company,"company");
//This code runs if the form has been submitted
if (isset($_POST['submit'])) { 
//This makes sure they did not leave any fields blank
if (!$_POST['jobtitle'] | !$_POST['jobtype'] | !$_POST['location'] | !$_POST['information'] ) {
echo('You did not complete all of the required fields, please go back and try again.');
include ("footer.php");
die(' ');
}
// here we encrypt the password and add slashes if needed
if (!get_magic_quotes_gpc()) {
$_POST['sector'] = addslashes($_POST['sector']);
$_POST['jobtitle'] = addslashes($_POST['jobtitle']);
$_POST['jobtype'] = addslashes($_POST['jobtype']);
$_POST['location'] = addslashes($_POST['location']);
$_POST['salary'] = addslashes($_POST['salary']);
$_POST['information'] = addslashes($_POST['information']);
}
switch($contract) 
{ 
  case "yes": $checkyes = "checked"; break; 
  case "no": $checkno = "checked"; break;  
} 
$closingdateday = $_POST['closingdateday'];
$closingdatemonth = $_POST['closingdatemonth'];
$closingdateyear = $_POST['closingdateyear'];
$closing = '' . $closingdateday . ' ' . $closingdatemonth . ' ' . $closingdateyear . ' ';
$startdateday = $_POST['startdateday'];
$startdatemonth = $_POST['startdatemonth'];
$startdateyear = $_POST['startdateyear'];
$start = '' . $startdateday . ' ' . $startdatemonth . ' ' . $startdateyear . ' ';
$company = mysql_query("SELECT company FROM accounts WHERE username = '$username'")or die(mysql_error()); 
$company = mysql_result($company,"company");
// now we insert it into the database
$insert = "INSERT INTO jobs (employer, sector, title, type, location, salary, information, startdate, closingdate, duration, contract, hours)
VALUES ('$company', '".$_POST['category_id1']."', '".$_POST['jobtitle']."', '".$_POST['jobtype']."', '".$_POST['location']."', '".$_POST['salary']."', '".$_POST['information']."', '$start', '$closing', '".$_POST['duration']."', '$contract', '".$_POST['hours']."')";
$add_member = mysql_query($insert) or die(mysql_error());
header("Location: members.php"); 
}
echo '<h1>Advertise a new job:</h1>';
echo '<form action="' . $_SERVER['PHP_SELF'] . '" method="post" enctype="multipart/form-data">';
echo '<table border="0">
<tr>
<td class="label">Job Title:</td>
<td class="star"><strong>*</strong></td>
<td><input name="jobtitle" type="text" id="jobtitle" maxlength="30" /></td>
</tr>
<tr>
<td class="label">Job Sector:</td>
<td class="star"><strong>*</strong></td>
<td><select name="category_id1" onChange="populate_jobtypes()"> 
								<option value="0">Any</option> 
								<option value="0"></option> 
																		<option value="15">Accountancy</option> 
																		<option value="16">Admin / Secretarial / PA</option> 
																		<option value="17">Agriculture / Fishing / Forestry</option> 
																		<option value="19">Architecture</option> 
																		<option value="70">Automotive</option> 
																		<option value="262">Aviation</option> 
																		<option value="21">Call / Contact Centres</option> 
																		<option value="23">Cleaning / Domestic</option> 
																		<option value="24">Construction / Trades / Property</option> 
																		<option value="259">Consultancy</option> 
																		<option value="263">Creative / Arts</option> 
																		<option value="25">Customer Services</option> 
																		<option value="260">Education</option> 
																		<option value="261">Emergency / Military / Security</option> 
																		<option value="29">Engineering / Technical</option> 
																		<option value="299">Environmental</option> 
																		<option value="30">Executive / Management</option> 
																		<option value="264">Facilities Management</option> 
																		<option value="31">Financial Services / Banking / Investment</option> 
																		<option value="294">Graduate / Trainee</option> 
																		<option value="33">Hairdressing / Beauty</option> 
																		<option value="286">Healthcare</option> 
																		<option value="35">Hospitality / Catering / Tourism</option> 
																		<option value="36">HR / Training / Recruitment</option> 
																		<option value="37">Insurance</option> 
																		<option value="67">IT / Telecoms</option> 
																		<option value="39">Legal</option> 
																		<option value="40">Leisure / Sport / Entertainment</option> 
																		<option value="41">Logistics / Distribution</option> 
																		<option value="42">Manufacturing / Production</option> 
																		<option value="308">Marine </option> 
																		<option value="43">Marketing / PR / Advertising</option> 
																		<option value="44">Media / Design</option> 
																		<option value="45">Medical / Dental </option> 
																		<option value="46">Oil / Gas</option> 
																		<option value="256">Part Time</option> 
																		<option value="50">Procurement</option> 
																		<option value="295">Public Sector</option> 
																		<option value="258">Quantity Surveyors</option> 
																		<option value="52">Retail</option> 
																		<option value="53">Sales</option> 
																		<option value="56">Scientific</option> 
																		<option value="255">Self Employed</option> 
																		<option value="55">Social Services / Housing / Childcare</option> 
																		<option value="257">Temporary / Contract</option> 
																		<option value="254">Work from Home</option> 
																</select></td>
</tr>
<tr>
<td class="label">Job Type:</td>
<td class="star"></td>
<td><input name="jobtype" type="text" id="jobtype" maxlength="200" /></td>
</tr>
<tr>
<td class="label">Location:</td>
<td class="star"><strong>*</strong></td>
<td><input name="location" type="text" id="location" maxlength="200" /></td>
</tr>
<tr>
<td class="label">Salary:</td>
<td class="star"><strong>*</strong></td>
<td><select name="salary"> 
								<option value="">Any</option> 
																													<option value=""></option> 
										<option value="">== Per Hour ==</option> 
																			<option value="Per Hour:6">£6+</option> 
																												<option value="Per Hour:8">£8+</option> 
																												<option value="Per Hour:10">£10+</option> 
																												<option value="Per Hour:12">£12+</option> 
																													<option value=""></option> 
										<option value="">== Per Day ==</option> 
																			<option value="Per Day:100">£100+</option> 
																												<option value="Per Day:200">£200+</option> 
																												<option value="Per Day:300">£300+</option> 
																												<option value="Per Day:400">£400+</option> 
																												<option value="Per Day:500">£500+</option> 
																													<option value=""></option> 
										<option value="">== Annual ==</option> 
																			<option value="Annual:12000">£12,000+</option> 
																												<option value="Annual:14000">£14,000+</option> 
																												<option value="Annual:16000">£16,000+</option> 
																												<option value="Annual:18000">£18,000+</option> 
																												<option value="Annual:20000">£20,000+</option> 
																												<option value="Annual:25000">£25,000+</option> 
																												<option value="Annual:30000">£30,000+</option> 
																												<option value="Annual:40000">£40,000+</option> 
																												<option value="Annual:45000">£45,000+</option> 
																												<option value="Annual:50000">£50,000+</option> 
																												<option value="Annual:75000">£75,000+</option> 
														</select></td>
</tr>
<tr>
<tr>
<td class="label">Start Date:</td>
<td class="star"><strong>*</strong></td>
<td><label>
   <select name="startdateday" id="startdateday">
     <option>1</option>
     <option>2</option>
     <option>3</option>
     <option>4</option>
     <option>5</option>
     <option>6</option>
     <option>7</option>
     <option>8</option>
     <option>9</option>
     <option>10</option>
     <option>11</option>
     <option>12</option>
     <option>13</option>
     <option>14</option>
     <option>15</option>
     <option>16</option>
     <option>17</option>
     <option>18</option>
     <option>19</option>
     <option>20</option>
     <option>21</option>
     <option>22</option>
     <option>23</option>
     <option>24</option>
     <option>25</option>
     <option>26</option>
     <option>27</option>
     <option>28</option>
     <option>29</option>
     <option>30</option>
     <option>31</option>
   </select>
   <select name="startdatemonth" id="startdatemonth">
     <option>January</option>
     <option>February</option>
     <option>March</option>
     <option>April</option>
     <option>May</option>
     <option>June</option>
     <option>July</option>
     <option>August</option>
     <option>September</option>
     <option>October</option>
     <option>November</option>
     <option>December</option>
   </select>
   <input name="startdateyear" type="text" id="startdateyear" value="2012" size="8" maxlength="4">
 </label></td>
</tr>
<tr>
<td class="label">Closing Date:</td>
<td class="star"><strong>*</strong></td>
<td><label>
   <select name="closingdateday" id="closingdateday">
     <option>1</option>
     <option>2</option>
     <option>3</option>
     <option>4</option>
     <option>5</option>
     <option>6</option>
     <option>7</option>
     <option>8</option>
     <option>9</option>
     <option>10</option>
     <option>11</option>
     <option>12</option>
     <option>13</option>
     <option>14</option>
     <option>15</option>
     <option>16</option>
     <option>17</option>
     <option>18</option>
     <option>19</option>
     <option>20</option>
     <option>21</option>
     <option>22</option>
     <option>23</option>
     <option>24</option>
     <option>25</option>
     <option>26</option>
     <option>27</option>
     <option>28</option>
     <option>29</option>
     <option>30</option>
     <option>31</option>
   </select>
   <select name="closingdatemonth" id="closingdatemonth">
     <option>January</option>
     <option>February</option>
     <option>March</option>
     <option>April</option>
     <option>May</option>
     <option>June</option>
     <option>July</option>
     <option>August</option>
     <option>September</option>
     <option>October</option>
     <option>November</option>
     <option>December</option>
   </select>
   <input name="closingdateyear" type="text" id="closingdateyear" value="Year" size="8" maxlength="4">
 </label></td>
<td>



</td>
</tr>
<tr>
<td class="label">Duration:</td>
<td class="star"></td>
<td><input name="duration" type="text" id="duration" maxlength="200" /></td>
</tr>
<td class="label">Contract:</td>
<td class="star">*</td>
<td>
<input type="radio" name="contract" value="yes" ' . $checkyes . '>Yes 
<input type="radio" name="contract" value="no" ' . $checkno . '>No 
</td>
</tr>
<tr>
<td class="label">Hours:</td>
<td class="star"><strong>*</strong></td>
<td><input name="hours" type="text" id="hours" maxlength="200" /> - Per Week</td>
</tr>
<td class="label">Information:</td>
<td class="star"><strong>*</strong></td>
<td><textarea name="information" id="information"></textarea></td>
</tr>
  <tr><td><input type="submit" id="submit" name="submit" value="Add Job" /></td><td></td><td>*Required Fields</td>
</tr>
</table></form>';
}
} 
else 
//if the cookie does not exist, they are taken to the login screen 
{			 
header("Location: login.php"); 
} 
include ("footer.php");
?>
Mysql - Radio buttons

Featured Replies

Create an account or sign in to comment

Recently Browsing 0

Member Statistics

Forum Statistics

Join WDF

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)

Chrome (Desktop)

Safari (iOS 16.4+)

Safari (macOS)

Edge (Android)

Edge (Desktop)

Firefox (Android)

Firefox (Desktop)
