checkboxes
Posted: Sat Dec 09, 2006 6:55 am
ok i have built this script and i want the check boxes if checked to add Yes to the data base and No if it asant how could i do this
thansk for the help 
Code: Select all
<?php
include("./dbconnect.php");//include the file that connects to the database
if(!empty($name)) {
$name = addslashes($name);
$user = addslashes($user);
$usernumber = addslashes($usernumber);
$year = addslashes($year);
$interviewed = addslashes($interviewed);
$accepted = addslashes($accepted);
$trial = addslashes($trial);
$course = addslashes($course);
$warnings = addslashes($warnings);
$comments = addslashes($comments);
$date = date("F j, Y");//set up the date format
$date2 = mktime();
$sql = "INSERT INTO manager (id, name, user, usernumber, year, date, interviewed, accepted, trial, course, warnings, comments ) VALUES ('NULL', '$name', '$user', '$usernumber', '$year', '$date', '$interviewed', '$accepted', '$trial', '$course', '$warnings', '$comments')";
$query = mysql_query($sql) or die("Cannot query the database.<br>" . mysql_error());
echo "Database Updated <br /> <a href=viewmanager.php> Go Back! </a>.";
} else {
?>
<form name="manager" method="post" action="<?php echo $PHP_SELF; ?>">
<p>Please fill out all of the following fields:</p>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="117"><font size="1">Name*: </font> </td>
<td width="577">
<font size="1">
<input type="text" name="name" size="50">
</font></td>
</tr>
<tr>
<td width="117"><font size="1">Username*:</font></td>
<td width="577">
<font size="1">
<input type="text" name="user" size="50">
</font></td>
</tr>
<tr>
<td width="117"><font size="1">User Number*:</font></td>
<td width="577">
<font size="1">
<input type="text" name="usernumber" size="5">
</font></td>
</tr>
<td width="117"><font size="1">year*:</font></td>
<td width="577">
<font size="1">
<select name="year">
<option value="07">7</option>
<option value="08">8</option>
<option value="09">9</option>
<option value="10">10</option>
<option value="11">11</option>
</select>
</font></td>
</tr>
<tr>
<td width="117"><font size="1">interviewed*:</font></td>
<td width="577"><input name="interviewed" type="checkbox" value="" /></td>
</tr>
<tr>
<td width="117"><font size="1">Accepted*:</font></td>
<td width="577"><input name="accepted" type="checkbox" value="" /></td>
</tr>
<tr>
<td width="117"><font size="1">Trial*:</font></td>
<td width="577">
<input name="trial" type="checkbox" value="" /></td>
</tr>
<tr>
<td width="117"><font size="1">Course*:</font></td>
<td width="577">
<input name="course" type="checkbox" value="" /></td>
</tr>
<td width="117"><font size="1">Comments*:</font></td>
<td width="577"><textarea name="comments" cols="43" rows="10" id="comments"></textarea></td>
</tr>
</table>
<input name="warnings" type="hidden" value="0" />
<p>
<font size="1">
<input type="submit" name="Submit" value="Submit"></font>
</p>
</form> <?php
}//end this function
?>