Practical Name:- write a php program to get email from user and store it in database.
---------------------------------------------------------------------------------------------------------
Solution:
/* main.php*/
<?php include("connection.php");
?>
<html>
<head>
</head>
<body>
<form action="main.php" method="GET">
Email:-<input type="text" placeholder="Enter a Email" name="email">
<input type="submit"/>
</form>
<?php
$ok=$_GET['email'];
$query="INSERT INTO gmail VALUES('$ok')";
$data=mysqli_query($conn,$query);
if($data){
echo "Data inserted into Database";
}
else{
echo "Failed to insert dat inserted into sDatabase";
}
?>
</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";
}
?>