Code: Select all
<html>
<head>
<title> Enrollment form </title>
<body>
</head>
<form method="get" action="course.php" >
<table bgcolor="#00CCFF" align="center" border="0" cellpadding="5" cellspacing="0">
<tr><td colspan="6">
<center><hr><h2> Add student </h2></hr> Please fill up all information required.</center>
</td></tr>
<tr><td colspan="6">
<center><h3><hr>STUDENT INFORMATION</hr></h3></center>
</td></tr>
<tr>
<td><input type="hidden" name="stdnum"></td>
</tr>
<tr>
<td align=right> Student Name:</td>
<td><input type=text name="stdname"></td>
</tr>
<tr>
<td align=right> Email Adress:</td>
<td><input type=text name="stdemail"></td>
</td>
</tr>
<tr>
<td align=right> Cellphone #:</td>
<td><input type=text name="stdcp"></td>
</tr>
<tr>
<td align=right> Age:</td>
<td><input type=text name="stdage"></td>
</td>
</tr>
<tr>
<td align=right valign="top">Boarding Address:</td>
<td>
<textarea rows="5" cols="18" name="stdbaddress">
</textarea>
</td>
</tr>
<tr>
<td align=right valign="top">Permanent Address:</td>
<td>
<textarea rows="5" cols="18" name="stdpaddress">
</textarea>
</td>
</tr>
<tr>
<td align=right> Religion:</td>
<td><input type=text name="stdreli"></td>
</td>
</tr>
<tr>
<td align=right valign=top> Gender:</td>
<td>
<select name="stdgender">
<option value=Male> Male </option>
<option value=Male> Female </option>
</td>
</tr>
<tr>
<td align=right valign=top> Civil Status: </td>
<td >
<select name="stdstat" >
<option value=Single> Single </option>
<option value=Married> Married </option>
<option value=Widow> Widow </option>
<option value=Separated> Separated </option>
</select>
</td >
</tr >
<tr><td colspan="6">
<hr></hr><h3><center>EDUCATIONAL BACKGROUND</center></h3></td>
</tr>
<tr>
<td align=right>Elementary School:</td>
<td><input type=text name="stdelem"></td>
<td>School Address:</td>
<td><input type=text name="stdelema"></td>
<td>Year of Graduate:</td>
<td><input type=text name="stdelemg"></td>
</tr>
<tr>
<td align=right>HighSchool:</td>
<td><input type=text name="stdhs"></td>
<td>School Address:</td>
<td><input type=text name="stdhsa"></td>
<td>Year of Graduate:</td>
<td><input type=text name="stdhsg"></td>
</tr>
<tr>
<td align=right>College:</td>
<td><input type=text name="stdcol"></td>
<td>School Address:</td>
<td><input type=text name="stdcola"></td>
<td>Year of Graduate:</td>
<td><input type=text name="stdcolg"></td>
</tr>
</select>
</td>
</tr>
<tr>
<td align=right> <input type=Submit value="Submit" name="stdsubmit"></td>
<td><input type=reset value="Reset" name="stdreset"></td>
</tr>
</table>
</form>
<body>
</body>
</html>
<?
if(isset($_GET["stdnum"]))
{
$database="stdrecords";
$host="localhost";
$allan="root";
$infra="";
$stdname=$_GET['stdname'];
$stdbaddress=$_GET['stdbaddress'];
$stdpaddress=$_GET['stdpaddress'];
$stdcp=$_GET['stdcp'];
$stdemail=$_GET['stdemail'];
$stdgender=$_GET['stdgender'];
$stdstat=$_GET['stdstat'];
$stdage=$_GET['stdage'];
$stdreli=$_GET['stdreli'];
$stdelem=$_GET['stdelem'];
$stdelema=$_GET['stdelema'];
$stdelemg=$_GET['stdelemg'];
$stdhs=$_GET['stdhs'];
$stdhsa=$_GET['stdhsa'];
$stdhsg=$_GET['stdhsg']
$stdcol=$_GET['stdcol'];
$stdcola=$_GET['stdcola'];
$stdcolg=$_GET['stdcolg'];
mysql_connect("$host","$allan","$infra");
@mysql_select_db($database) or die( "NO DATABASE");
if ($stdname == '' OR $stdpaddress == '' OR $stdemail == '' OR $stdcp == '' OR $stdage == '' )
{
Echo "Some values are not inserted!";
Exit;
}
$query = "INSERT INTO stdinfo VALUES('','$stdname','$stdemail','$stdcp','$stdage','$stdbaddress','$stdpaddress','$stdreli','$stdgender','$stdstat','$stdelem','$stdelema','$stdelemg','$stdhs','$stdhsa','$stdhsg','$stdcol','$stdcola','$stdcolg')";
mysql_query($query);
Echo "Records Saved!";
mysql_close();
}
?>