Untitled


<HTML>
<BODY>
<?php

$sid=$_GET['sid'];
echo "<br> Student id is ".$sid;
$username="u216";
$password="Rohini123?";
$dbname="u216";
$conn=mysqli_connect('localhost',$username,$password,$dbname);
$query="SELECT * FROM student WHERE sid='$sid'";
$result=mysqli_query($conn,$query);
$row=mysqli_fetch_array($result);
?>
<form name="f2" method="POST" action="">
<br> Name
<input type="text" name="name" value=<?php echo $row['name'];?> >
<br>
Gender
<input type="radio" name="gender" value="male"
<?php if($row['gender']=="male") echo "CHECKED";?>
 > Male
<input type="radio" name="gender" value="female"
<?php if($row['gender']=="female") echo "CHECKED";?>
> Female
<br> Department<br>
<select name="dept">
<option value="IT"
<?php if($row['dept']=="IT") echo "SELECTED";?>
>
Information Technology</option>
<option value="Business"
 <?php if($row['dept']=="Business") echo "SELECTED";?>

>Business Department</option>
<option value="Engineering"
<?php if($row['dept']=="Engineering") echo "SELECTED";?>

>Engineering Department</option>
</select>
<br>Information<br>
<textarea name="info">
<?php echo $row['info'];?>
</textarea>
<br>
<input type="submit" name="update1" value="Update ">
</form>
<?php
if(isset($_POST['update1']))
{
	$name=$_POST['name'];
	$gender=$_POST['gender'];
	$dept=$_POST['dept'];
	$info=$_POST['info'];
	$sql="update student set name ='$name',gender='$gender', dept='$dept'
    ,info='$info' where sid='$sid'";
	echo "<br>".$sql;
	$result=mysqli_query($conn,$sql);


}


?>
</body>
</html>