Untitled

<?php include "db.php"?>
<?php include "functions.php" ?>
<?php

if (isset($_POST['submit'])){
    $first_name = $_POST['fname'];
    $last_name = $_POST['lname'];
    $phone_number = $_POST['phone_number'];
    $username = $_POST ['username'];
    $password = $_POST ['password'];
    $id = $_POST ['id'];

    $query =  "UPDATE users SET ";
    $query .= "first_name = '$first_name',";
    $query .= "last_name = '$last_name',";
    $query .= "Phone_number = '$phone_number',";
    $query .= "username = '$username',";
    $query .= "Password = '$username',";
    $query .= "WHERE id = $id";

$result = mysqli_query ($connection , $query);
    if (!$result) {
        die("Query failed".mysqli_query());
    }
}
    ?>

<!DOCTYPE html>
<html>
<head>
    <meta charset="utf-8" />
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <title>Page Title</title>
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <link rel="stylesheet" type="text/css" media="screen" href="main.css" />
    <link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/css/bootstrap.min.css" integrity="sha384-MCw98/SFnGE8fJT3GXwEOngsV7Zt27NXFoaoApmYm81iuXoPkFOJwJ8ERdknLPMO" crossorigin="anonymous">
    <link rel="stylesheet" href="style.css">
    <link rel="stylesheet" href="maim.css">
    <script src="https://stackpath.bootstrapcdn.com/bootstrap/4.1.3/js/bootstrap.min.js" integrity="sha384-ChfqqxuZUCnJSK3+MXmPNIyE6ZbWh2IMqE241rYiqJxyMiZ6OW/JmZQ5stwEULTy" crossorigin="anonymous"></script>
    <script src="main.js"></script>
</head>
<body class="dev">

    <div class="container" class ="cont">
          <div class="jumbotron">
        <div class="row">

            <div class="col-md-6">

             <form action="update.php" method="POST"  class="form-group">

                    <label for="First name"> First Name</label>
                    <input type="text" placeholder="enter your first name" class="form-control" required name="fname"> <br>
                    <label for="last name"> Last Name</label>
                    <input type="text" placeh older="enter your last name" class="form-control" required name="lname"> <br>
                    <label for="phone_number"> Phone Number</label>
                    <input type="text" placeholder="enter your phone number" class="form-control" required name="phone_number"> <br>
                    <label for="username"> Username</label>
                    <input type="text" class="form-control" placeholder="Enter username" name="username" required> <br>
                    <label for="password"> Password</label>
                    <input type="password" class="form-control"placeholder= "Enter your password" required name="password"> <br>

                    <select name="id" id="id">
                        <?php
                        showalldata();

                        ?>
                    </select> <br>

                    <button type="submit" class="btn btn-primary" name="submit">Update</button>
                     <h4>verify your <a href="check.php">Name here!</a></h4>


                </form>


            </div>


            </div>

            </div>

        </div>

    </div>

</body>
</html>