<?php
 	$db = mysqli_connect('localhost','root','','person');

    if(isset($_POST['submit'])){

        $name = mysqli_real_escape_string($db,$_POST['name']);
        $id = mysqli_real_escape_string($db,$_POST['id']);
        $age = mysqli_real_escape_string($db,$_POST['age']);
        $username = mysqli_real_escape_string($db,$_POST['username']);
        $password = mysqli_real_escape_string($db,$_POST['password']);




        $password = md5($password);
        $sql="insert into user values('$name','$id','$age','$username','$password')";
        $result = mysqli_query($db,$sql);



}

$sql1 = "SELECT name,id, age, username,password FROM user";
$result = $db->query($sql1);

if ($result->num_rows > 0) {

    while($row = $result->fetch_assoc()) {
        echo "<b>Name</b>: " . $row["name"]. " <b> ID: </b>" .$row["id"]." <b> Age :</b> " .$row["age"]. " <b> UserName : </b>" . $row["username"]."  <b>password :</b> ".$row["password"]. "<br>";
    }
} else {
    echo "0 results";
}
$db->close();




?>