PROGRAM ====>
registration.php ====>
<!DOCTYPE html>
<html>
<head>
<title>Registration</title>
<style>
div {
background-color: lightgrey;
width: 350px;
border: 15px solid green;
padding: 50px;
margin: 20px;
}
</style>
</head>
<body>
<div align="center">
<h1 align="center"> My Personal Information </h1>
<form action="confirm.php" method="post" >
<label>First Name</label><br>
<input type="text" name="fname"><br>
<label>Middle Name</label><br>
<input type="text" name="mname"><br>
<label>Last Name</label><br>
<input type="text" name="lname"><br>
<label>Username</label><br>
<input type="text" name="user"><br>
<label>Password</label><br>
<input type="text" name="pword"><br>
<label>Confirm Password</label><br>
<input type="text" name="Cpass"><br>
<label>Birthday</label><br>
<input type="text" name="bday"><br>
<label>Email</label><br>
<input type="text" name="email"><br>
<label>Contact Number</label><br>
<input type="text" name="Cnumber"><br>
<br><br>
<input type="submit" name="Submit">
</form>
</div>
</body>
</html>
confirm.php ====>
<?php
include "db.php";
if (isset($_POST["Submit"]))
{
$fname = $_POST["fname"];
$Mname = $_POST["mname"];
$Lname = $_POST["lname"];
$user = $_POST["user"];
$Pass = $_POST["pword"];
$Cpass = $_POST["Cpass"];
$Bday = $_POST["bday"];
$Email = $_POST["email"];
$Cnum = $_POST["Cnumber"];
if($Pass == $Cpass)
{
$sql = "INSERT INTO
registration
(
Fname
,
Mname
,
Lname
,
user
,
password
,
bday
,
email
,
Cnum
) VALUES ('$fname','Mname','$Lname','$user','$Pass','$Bday','$Email','$Cnum'); ";
$result = mysqli_query( $conn , $sql ) ;
if ($result === TRUE) {
?>
<script type="text/javascript">
alert("submit successfully");
window.location.href='registration.php';
</script>
<?php
}
else
{
echo "Error: " . $sql . "<br>" . $conn->error;
}
}
else
{
?>
<script type="text/javascript">
alert("Passwords didn't match . Please try again !");
window.location.href='registration.php';
</script>
<?php
}
}
?>
db.php ====>
<?php
// connect database to php
$dbs ="registration";
$user ="root";
$pwd="";
$host="localhost";
$conn= mysqli_connect($host , $user , $pwd , $dbs);
if(!$conn) {
die("Connection failed :" .mysqli_connect_error());
}
?>
OUTPUT SCREENSHOT ====>