<!DOCTYPE html>
<html>
<head>
<title>Hello World</title>
</head>
<body>

<form action="" method="POST">

<tr>
<td>
<label>USERNAME:</label>
<input type="text" name="name">
</td>
</tr>

<tr>
<td><br><br>
<label>LASTNAME:</label>
<input type="text" name="lname">
</td>
</tr>

<tr>
<td><br><br>
<label>MIDDELNAME:</label>
<input type="text" name="mname">
</td>
</tr>

<tr>
<td><br><br>
<label>EMAIL:</label>
<input type="text" name="email">
</td>
</tr>

<tr>
<td><br><br>
<label>MOBILE NO:</label>
<input type="number" name="mno">
</td>
</tr>

<tr>
<td><br><br>
<label>PASSWORD:</label>
<input type="password" name="pwd">
</td>
</tr>

<br><br>
<input type="submit" name="save" value="POST">
</form>

</body>
</html>


<?php

$server = "localhost";
$username = "root";
$password = "";
$database = "add";

$con = mysqli_connect($server,$username,$password,$database);

if ($con -> connect_error)
{
die ("connection failled :". $con -> connect_error);
}

date_default_timezone_set("asia/kolkata");


    if(isset($_POST['save'])){
   
    $name = $_POST['name'];
  $lname = $_POST['lname'];
  $mname = $_POST['mname'];
  $email = $_POST['email'];
  $mno = $_POST['mno'];
  $pwd = $_POST['pwd'];

  $sql = "INSERT INTO login (name, lname, mname, email, mobile, password) VALUES ('$name', '$lname', '$mname', '$email', '$mno', '$pwd')";

    $res = mysqli_query($con,$sql);
 
   if ($res > 0)
    {
    echo "Insert Successfully...";
  }

  else
 
  {
    echo "Insert Not Successfully";
  }
 }

?>

Comments

Popular posts from this blog