PROGRAM
FORM1.PHP
<html>
<body>
<form method="POST" action="form1.php">
<h2>enter student id number</h2>
STUDENT ID=<input type="text" name="id">
<input type="submit" name="submit" value="check">
</form>
</body>
</html>
FORM 2.PHP
<html>
<head>
<?php
$s_id =$_POST['id'];
$connection=mysqli_connect('localhost','root','','experiment');
$query="select * from student where s_id=$s_id";
$result=mysqli_query($connection,$query);
$usrcount = mysqli_num_rows($result);
if($usrcount==0)
{
echo "<Script>alert('m_id not allowed')</script>";
echo "<script>document.location.href='into form.php'</script>";
}
while($row = mysqli_fetch_array($result))
{
?>
<h2>Ente student detail for update</h2>
<?PHP
echo "ID :" . $s_id;
?>
<PRE>
NAME :<input type='text' name='name' value="<?php echo $row['name']; ?>"; >
LAST_NAME :<input type='text' name='last_name' value="<?php echo $row['lastname'];?>";>
DEPARTMENT :<input type='text' name='department' value="<?php echo $row['department'];?>";>
SUBJECT :<input type='text' name='subject' value="<?php echo $row['subject'];?>";>
PHONE :<input type='text' name='phone' value="<?php echo $row['phone'];?>";>
</PRE>
<?PHP
}
?>
</head>
<body>
</html>
OUTPUT
No comments:
Post a Comment