Practical Name:- write a php code design a form and get multiple data feom user and store it into a database.
---------------------------------------------------------------------------------------------------------
Solution:
/* main.php*/
<?php include("connection.php");
?>
<html>
<head>
<style> #main{
border:solid 2px black; width:300px; height:500px; background:pink;
}
</style>
</head
<body>
<center>
<div id="main">
<form action="main.php" method="GET">
<h1>form Details</h1>
Firstname:- <input type="text" placeholder="Firstname" name="fname"/><br><br>
Lastname:- <input type="text" placeholder="Lastname" name="lname"/><br><br>
Email:<input type="text"placeholder="Enter Email Addrese" name="email"><br><br>
password:- <input type="password" placeholder="Enter a password" name="pass"><br><br>
confirmpass:_ <input type="password" placeholder="confirmpass" name="confirm"><br><br>
<input type="submit"/>
</form>
</div>
<?php
$fn=$_GET['fname'];
$ln=$_GET['lname'];
$em=$_GET['email'];
$pas=$_GET['pass'];
$co=$_GET['confirm'];
$query="INSERT INTO multiple_table VALUES('$fn','$ln','$em','$pas','$co')";
$data=mysqli_query($conn,$query); if($data){
echo "Data inserted into Database";
}
else{
echo "Failed to insert data inserted into Database";
}
?>
</body>
</html>
/* connection.php*/
<?php
$servername="localhost";
$username="root";
$password="";
$dbname="test";
$conn=mysqli_connect($servername,$username,$password,$dbname); if($conn){ echo"connecton ok";
}
else{
echo"connecton not";
}
?>