slesh

<!DOCTYPE html>
<html lang="en">
    <head>
        <title>Your Details</title>
        <meta charset="utf-8">
        <link rel="stylesheet" href="css/common.css" type="text/css">
        <script src="script/myscript.js"></script>
     </head>
    <body onload="pload()">
        <img src="img/logo.png" alt="logo">
        <p id="date1">DATE</p>
        <p id="time1">TIME</p>
        <h3>Navigation</h3>
        <nav>
            <ul>
                <li><a href="home.html">Home</a></li>
                <li><a href="login.html">Login</a></li>
                <li><a href="addedit.php">New User</a></li>
                <li><a href="aboutus.html">About Us</a></li>
                <li><a href="contactus.html">Contact Us</a></li>

            </ul>
        </nav>
        <h1>Welcome to Shailesh Insurance</h1>
        <h2>Place to order </h2>

        <?php
        //declare all variables for db connection
            $dbserver="localhost:3307";
            $dbuser="root";
            $dbpassword="";
            $dbname="sbdb2019";
        //create connection
            $conn=new mysqli($dbserver,$dbuser,$dbpassword,$dbname);
        //check connection error
            if($conn->connect_error==true){
                die("connection failed error description $conn->Connect_error");
            }else{
                echo "<p class='success'>Connection Success</p>";
            }
                //read login from values
                $name=$_POST['name'] ;
                $password=$_POST['password'] ;
                //create sql statement
                $sql="SELECT * FROM CUSTOMER WHERE NAME='".$name."' and PASSWORD='".$password."'";
                //execute sql and assign to result
                $result = $conn->query($sql);
                if($result->num_rows>0){
                    //display welcome
                    echo "<h1>Welcome $name your details are below</h1>";
                    echo "<h2>Please enter new details except id if you need changes</h2>";
                    echo "<form method = 'post' action = 'update.php'>";
                    //create table to display information
                    echo "<table>";
                    while($row=$result->fetch_assoc()){
                        echo "<tr><td>ID:</td><td><input type='number' id='box' name='id' readonly value=".$row['ID']."></td></tr>";
                        echo "<tr><td>Name:</td><td><input type='text' id='box' name='name' value=".$row['NAME']."></td></tr>";
                        echo "<tr><td>City:</td><td><input type='text' id='box' name='city' value=".$row['CITY']."></td></tr>";
                        echo "<tr><td>DOB:</td><td><input type='date' id='box' name='dob' value=".$row['DOB']."></td></tr>";
                        echo "<tr><td>Phone:</td><td><input type='phone' id='box' name='phone' value=".$row['PHONE']."></td></tr>";
                        echo "<tr><td>Password:</td><td><input type='text' id='box' name='password' value=".$row['PASSWORD']."></td></tr>";
                        echo "<tr><td colspan=2><input type=submit value=UPDATE class=btn></td></tr>";
                    }
                    echo "</table>";
                    echo "</form>";
                    //close db connection
                    $conn->close();
                }else{
                    echo "<p class='fail'>You are not authorised to access this information</p>";
                }
        ?>
        <footer>
            <p>Copyright&copy; 2019 - All Rights Reserved</p>
            <p>Shailesh Bhandari</p>
        </footer>
    </body>
</html>