king

<!DOCTYPE html>
<html lang="en">
    <head>
        <title>ECA Consultant New User</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.jpg" 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>CODE ZERO</h1>
        <h2>Please log in to check your details</h2>

        <?php
        //declare all variables for db connection
            $dbserver="localhost:3307";
            $dbuser="root";
            $dbpassword="";
            $dbname="mydatabase";
        //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
                $id=$_POST['id'];
                $name=$_POST['name'];
                $city=$_POST['city'];
                $dob=$_POST['dob'];
                $phone=$_POST['phone'];
                $password=$_POST['password'];
                //create sql to update
                $sql="UPDATE CUSTOMER SET ".
                    "NAME='".$name."',".
                    "CITY='".$city."',".
                    "DOB='".$dob."',".
                    "PHONE='".$phone."',".
                    "PASSWORD='".$password."' ".
                    "WHERE ID=".$id;
                //execute query
                $result=$conn->query($sql);
                if($result==true){
                $conn->query($sql);
                echo "<h1>Hello $name your details have been updated</h1>";
                echo "<h2>Please log in again to confirm your changes</h2>";
                }else{
                    echo "<h1 class='fail'>Please contact admin your details have not been changed.</h1>";
                }
                //close db connection
                $conn->close();

        ?>
        <footer>
            <p>Copyright&copy; 2019 - All Rights Reserved</p>
            <p>Abhiman Basnet</p>
        </footer>
    </body>
</html>