Untitled

<!DOCTYPE html>
<html>
<head>
<style>
div.container {
 width: 50%;
 border: 1px solid gray;
 border-radius: 25px;
}

header{
 border-radius: 15px 15px 0px 0px;
 padding: 1em;
 color: white;
 background-color: black;
 clear: left;
 text-align: center;
}
footer {
 border-radius: 0px 0px 15px 15px;
 padding: 1em;
 color: white;
 background-color: black;
 clear: left;
 text-align: center;
}

th {
    display: table-cell;
    vertical-align: inherit;
    font-weight: bold;
    text-align: center;
}
nav {
 float: left;
 width: 80px;
 padding: 1em;
}

nav ul {
 list-style-type: none;
 padding: 0;
}

nav ul a {
 text-decoration: none;
}

article {
 border-left: 1px solid gray;

 padding: 1em;
 overflow: hidden;
}
</style>
</head>
<body>

<div class="container">

<header>
 <h1>Insurance</h1>
</header>

<!DOCTYPE html>
<html>
<body>


<body>
<form action="insertion.php" method="POST">


 <table style="width:100%">
  <tr>
    <th><h1>Agent</h1></th>
   </tr>


 <tr>
    <td colspan="1"><label for="i1" class="col-lg-2 control-label">First Name</label></td>
 <td><input id="i1" type="text" name="fname" required></td>
</tr>
 <tr>
    <td colspan="1"><label for="i2" class="col-lg-2 control-label">Last name</label></td>
 <td><input id="i2" type="text" name="lname" required></td>
 </tr>
 <tr>
<td colspan="1"> <label for="i3" class="col-lg-2 control-label">Agent Id</label></td>
 <td><input id="i3" type="text" name="aid" required></td>
 </tr>
 <tr>
<td colspan="1"> <label for="i4" class="col-lg-2 control-label">User name</label></td>
<td> <input id="i4" type="text" name= "uname" required></td>
 </tr>
 <td colspan="1"> <label for="i4" class="col-lg-2 control-label">Phone</label></td>
<td> <input id="i4" type="text" name= "phone" required></td>
 </tr>


<td></td><td>
 <input type="submit" value="submit"></td>
 </tr>
 </table>

<br>

</br>


 <script>
 </script>

<?php

$fname=filter_input(INPUT_POST,'fname');
$lname=filter_input(INPUT_POST,'lname');
$aid=filter_input(INPUT_POST,'aid');
$uname=filter_input(INPUT_POST,'uname');
$phone=filter_input(INPUT_POST,'phone');


if (!empty($fname) || !empty(lname) || !empty($aid) || !empty($uname) || !empty($phone))
{
$host = "localhost";
$dbusername="root";
$dbpassword="";
$dbname = "insurance";

$conn = new mysqli ($host,$dbusername,$dbpassword,$dbname);

if (mysqli_connect_error()){
  die('Connect Error ('. mysqli_connect_errno() .') '
    . mysqli_connect_error());
}
else{
  $sql = "INSERT INTO Agent (First_name, Last_name, Agent_id, User_name, Phone)
  values ('$fname', '$lname', '$aid', '$uname', '$phone')";
  if ($conn->query($sql)){
    echo "new record is inserted sucessfully";
  }
  else{
    echo "Error: ". $sql ."<br>". $conn->error;
  }

}
}

?>
<?php

$host = "localhost";
$dbusername="root";
$dbpassword="";
$dbname = "insurance";

$conn = new mysqli ($host,$dbusername,$dbpassword,$dbname);


?>


</div>

</body>

    <footer>Copyright &copy; fintech.gitam.edu</footer>
</html>