log in system in php and html

Log in system in php and html

step1 :- create a form for user information used to store

<form action="" metho="post">
<table> 
<tr><td>Name</td><td><input type='text' name='name'></td></tr>
<tr><td>Email</td><td><input type='text' name='email'></td></tr>
<tr><td>Address</td><td><input type='text' name='address'></td></tr>
<tr><td colspan='2'><input type="submit"  value="submit" > </td> </tr>
</table>
</form>
step2:- php code top of the page 
  
if(isset($_REQUEST['submit']))
{
 
$name=$_REQUEST['name'];
$email=$_REQUEST['email'];
$address=$_REQUEST['address'];
//validation in php
if(!empty($name))
{
if(!empty($email))
{ if(filter_var($email , FILTER_VALIDATE_EMAIL))
{ if(!empty($address))
{


 //now create a connection in mysql database
$con=mysqli_connect("localhost","root","","saddam");
$sql="insert into user (name,email,addres)value('$name','$email','$address')";
$query=mysqli_query($con,$sql);
 if($query)
{
mysqli_query("COMMIT");
 
}
else
{
mysqli_query("ROLBACK");

}
echo mysql_affected_rows($con);


$sql1="select * from user";
$query1=mysqli_query($con,$sql1);
 ?>


<table> 
<tr><td>Name</td><td>Email</td><td>Address </td></tr>
 <?php while($row=mysqli_fetch_array($query1)){?>
<tr><td><?php $row['name'];?></td><td><?php $row['email'];?></td><td><?php $row['address'];?></td></tr> <?pgp }?>
 </table>
<?php }


}else{
echo "enter your  address ";
 }

}else{
echo "enter valid  email address ";
 }
 
}else{
echo "enter your email address ";
 }

}else{
echo "enter your name ";
 }

?>