Untitled

<?php

// sql to delete a record
$sql = "DELETE FROM student_form WHERE id='$_GET[id]'";

if (mysqli_query($conn, $sql)) {
    echo "Record deleted successfully";
} else {
    echo "Error deleting record: " . mysqli_error($conn);
}


if(isset($_POST['submit']));
{
$servername = "localhost";
$username = "root";
$password = "";
$dbname = "data";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$name = $_POST['studentname'];
$fname = $_POST['fathername'];
$pdadd = $_POST['paddress'];
$psadd = $_POST['personaladdress'];
$sex = $_POST['sex'];
$city = $_POST['city'];
$course = $_POST['course'];
$district = $_POST['district'];
$state = $_POST['state'];
$pincode = $_POST['pincode'];
$emailid = $_POST['emailid'];
$dob = $_POST['dob'];
$mobileno = $_POST['mobileno'];

$sql = "INSERT INTO student_form (name, father_name, postal_address, personal_address, sex, city, course, district, state, pincode, email_id, dob, mobile_no)
VALUES ('$name','$fname', '$pdadd', '$psadd', '$sex', '$city', '$course', '$district', '$state', '$pincode', '$emailid', '$dob', '$mobileno')";

if ($conn->query($sql) === TRUE) {
echo "New record created successfully";

} else
{
echo "Error: " . $sql . "<br>" . $conn->error;
}


?>

 <html>
<head>
	<title>Student Registration Form</title>
</head>
<body>
<form action="" method="post" name="StudentRegistration" >

	<table cellpadding="2" width="20%" bgcolor="99FFFF" align="center"
	cellspacing="2">

		<tr>
			<td colspan=2>
			<center><font size=4><b>Student Registration Form</b></font></center>
			</td>
		</tr>

		<tr>
			<td>Name</td>
			<td><input type="text" name="studentname" id="studentname" size="30"></td>
		</tr>

		<tr>
			<td>Father Name</td>
			<td><input type="text" name="fathername" id="fathername"
			size="30"></td>
		</tr>

		<tr>
			<td>Postal Address</td>
			<td><input type="text" name="paddress" id="paddress" size="30"></td>
		</tr>

		<tr>
			<td>Personal Address</td>
			<td><input type="text" name="personaladdress"id="personaladdress" size="30">
			</td>
		</tr>

		<tr>
			<td>Sex</td>
			<td>
				<input type="radio" name="sex" value="male" size="10">Male
				<input type="radio" name="sex" value="Female" size="10">Female
			</td>
		</tr>

		<tr>
		<td>City</td>
			<td>
			<select name="city">
				<option value="-1" selected>select..</option>
				<option value="New Delhi">NEW DELHI</option>
				<option value="Mumbai">MUMBAI</option>
				<option value="Goa">KHARAR</option>
				<option value="Patna">CHANDIGARH</option>
			</select></td>
		</tr>

		<tr>
			<td>Course</td>
			<td><select name="course">
			<option value="-1" selected>select..</option>
			<option value="B.Tech">B.TECH</option>
			<option value="MCA">MCA</option>
			<option value="MBA">MBA</option>
			<option value="BCA">BCA</option>
			</select></td>
		</tr>

		<tr>
			<td>District</td>
			<td><select name="district">
			<option value="-1" selected>select..</option>

			<option value="Nalanda">NALANDA</option>
			<option value="UP">UP</option>
			<option value="Goa">MOHALI</option>
			<option value="Patna">PATNA</option>
		</select></td>

		</tr>

		<tr>
		<td>State</td>
			<td><select Name="state">
			<option value="-1" selected>select..</option>
			<option value="New Delhi">NEW DELHI</option>
			<option value="Mumbai">MUMBAI</option>
			<option value="Goa">PUNJAB</option>
			<option value="Bihar">BIHAR</option>
			</select></td>
		</tr>

		<tr>
			<td>PinCode</td>
			<td><input type="text" name="pincode" id="pincode" size="30"></td>
		</tr>
		<tr>
			<td>EmailId</td>
			<td><input type="text" name="emailid" id="emailid" size="30"></td>
		</tr>

		<tr>
			<td>DOB</td>
			<td><input type="text" name="dob" id="dob" size="30"></td>
		</tr>

		<tr>
			<td>MobileNo</td>
			<td><input type="text" name="mobileno" id="mobileno" size="30"></td>
		</tr>
		<tr>
			<td>
				<input type="reset">
			</td>
			<td colspan="2">
				<input type="submit" name="name" value="Submit Form" />
			</td>
		</tr>

	</table>

</form>

<table border="1" width="80">
<tr>
<td>Name</td>
<td>Fathers Name</td>
<td>Postal Address</td>
<td>Personal Address</td>
<td>Sex</td>
<td>City</td>
<td>Course</td>
<td>District</td>
<td>State</td>
<td>Pincode</td>
<td>Email id</td>
<td>D.O.B</td>
<td>Mobile no</td>
<td>Button</td>
</tr>
<?php $sql = "SELECT * FROM `student_form` "; $result = $conn->query($sql);
if ($result->num_rows > 0)
{
// output data of each row
while($row = $result->fetch_assoc())
{
?>
<tr>
<td><?php  echo $row['name']; ?></td>
<td><?php  echo $row['father_name']; ?></td>
<td><?php  echo $row['postal_address']; ?></td>
<td><?php  echo $row['personal_address']; ?></td>
<td><?php  echo $row['sex']; ?></td>
<td><?php  echo $row['city']; ?></td>
<td><?php  echo $row['course']; ?></td>
<td><?php  echo $row['district']; ?></td>
<td><?php  echo $row['state']; ?></td>
<td><?php  echo $row['pincode']; ?></td>
<td><?php  echo $row['email_id']; ?></td>
<td><?php  echo $row['dob']; ?></td>
<td><?php  echo $row['mobile_no']; ?></td>
<td><a href="st_form.php?id=<?php $row['id']; ?>"><input type="button" name="delete" value="Delete"></a></td>
</tr>
<?php  }?>
</table>
<?php
} else {
echo "0 results";
}

$conn->close();

}?>
</body>
</html>