<!DOCTYPE html">
<html>
<head>
<title>Create Html Form</title>
</head>
<body bgcolor="pink">
<form action="UpdateForm.php" method="post">
<table border="2" cellpadding="2" align="center">
<tr align="center"><td colspan="3"><u><i><b>Registration Page</b></i></u></td></tr>
<tr><td><b>User ID:</b></td><td> <input type="text" name="userid" placeholder="Enter UserID" value=""/><input type="submit" name="submit" value="UserId"/></td></tr><br/>
<tr><td><b>User Name:</b></td><td> <input type="text" name="username" placeholder="Enter User Name" value=""/></td></tr><br/>
<tr><td><b>State:</b></td><td> <input type="text" name="state" placeholder="Enter State" value=""/></td></tr><br/>
<tr><td><b>City:</b></td><td> <input type="text" name="city" placeholder="Enter City" value=""/></td></tr><br/>
<tr><td><b>Phone no:</b></td><td><input type="text" name="phoneno" placeholder="Enter Phone No" value=""/></td></tr><br/>
<tr><td><b>Pin:</b></td><td><input type="text" name="pin" placeholder="Enter Pin No" value=""/></td></tr></br>
<tr><td><b>Gender</b></td></tr><br/>
<tr><td><b>Male:</b></td><td><input type="radio" name="gender" value="Male" checked/></td></tr><br/>
<tr><td><b>Female:</b></td><td><input type="radio" name="gender" value="Female" /></td></tr><br/>
<tr align="center"><td colspan="2"><b><input type="submit" name="submit" value="Insert"/><input type="submit" name="submit" value="Update"/><input type="submit" name="submit" value="Delete"/><a href="ShowForm.php" >ShowData</a><input type="button" onClick="location.href='ShowForm.php';" value="ShowData"/></b></td></tr><br/>
</table>
</form>
</body>
</html>
UpdateForm.php
<?php
$con=mysqli_connect("localhost", "root", "", "mydatabase");
if(isset($_POST['submit']))
{
$userid=$_POST['userid'];
$username=$_POST['username'];
$state=$_POST['state'];
$city=$_POST['city'];
$phoneno=$_POST['phoneno'];
$pin=$_POST['pin'];
$gender=$_POST['gender'];
$sql = "Update registration set UserName='$username',State='$state',City='$city',PhoneNo='$phoneno',Pin='$pin',Gender='$gender' where UserId='$userid'";
$result = mysqli_query($con, $sql);
//while($contact = mysql_fetch_assoc($result))
if($result===true)
{
echo "Record Updated successfully";
}
else
{
echo "Error: " .$sql. "<br>" .$con->error;
}
}
mysqli_close($con);
?>
https://www.youtube.com/channel/UCKLRUr6U5OFeu7FLOpQ-FSw/videos
0 comments
Post a Comment