over

<?php
if(isset($_SESSION['username'])){

$the_user_id = $_SESSION['username'];

$query = "SELECT id,firstname,lastname,username,email,password,user_avatar FROM users WHERE username = '{$the_user_id}' ";
$select_users_query= mysqli_query($connection,$query);
if(!$select_users_query){

  die('rip'.mysqli_error($connection));
}
while($row = mysqli_fetch_assoc($select_users_query)) {
$id = $row['id'];
$username= $row['username'];
$password= $row['password'];
$firstname= $row['firstname'];
$lastname= $row['lastname'];
$email= $row['email'];
$user_avatar = $row['user_avatar'];

}

}




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

$firstname = $_POST['firstname'];
$lastname = $_POST['lastname'];
$username = $_POST['username'];
$email = $_POST['email'];
$password = $_POST['password'];
$user_avatar = $_FILES ['user_avatar']['name'];
$user_avatar_temp = $_FILES['user_avatar']['tmp_name'];

    move_uploaded_file($user_avatar_temp, "./user_avatar/$user_avatar");

if(empty($user_avatar)){


       $query = "SELECT user_avatar FROM users WHERE username = '{$the_user_id}' ";

       $select_image = mysqli_query($connection,$query);
       if(!$select_image){

         die('rip'.mysqli_error($connection));
       }
       while($row = mysqli_fetch_assoc($select_image)){

           $user_avatar = $row['user_avatar'];
       }

             }

             $param_password = password_hash($password,PASSWORD_DEFAULT);
             $error = NULL;
             if (empty($password)) {
                 $error = 'You forgot to choose a password!';
             }
             if (!$error) {

    $query = "UPDATE users SET ";
    $query .= "firstname = '{$firstname}', ";
    $query .= "lastname = '{$lastname}', ";
    $query .= "username = '{$username}', ";
    $query .= "email = '{$email}', ";
    $query .= "user_avatar = '{$user_avatar}', ";
    $query .= "password = '{$param_password}', ";
    $query .= "WHERE username = '{$the_user_id}' ";
}



    $edit_user_query =mysqli_query($connection,$query);

if(!$edit_user_query){

  die('rip'.mysqli_error($connection));
}


     echo "<div class='alert alert-success fade in'>
  <a href='#' class='close' data-dismiss='alert' aria-label='close'>&times;</a>
  <strong>Success!</strong> Your profile has been edited
</div>";


}
?>

<div class="block-content block-content-narrow">
    <form class="js-validation-bootstrap form-horizontal push-10-t" action=""  method="post" enctype="multipart/form-data">

    <div class="form-group">
            <div class="col-xs-12">
                <div class="form-material">
                    <input class="form-control" type="text"  name="firstname" value="<?php echo $firstname; ?>">
                    <label for="firstname">first name</label>
                </div>
            </div>
        </div>

        <div class="form-group">
                <div class="col-xs-12">
                    <div class="form-material">
                        <input class="form-control" type="text"  name="lastname" value="<?php echo $lastname; ?>">
                        <label for="material-email">last name  </label>
                    </div>
                </div>
            </div>

            <div class="form-group">
                    <div class="col-xs-12">
                        <div class="form-material">
                            <input class="form-control" type="text"  name="username" value="<?php echo $username; ?>">
                            <label for="material-email"> username</label>
                        </div>
                    </div>
                </div>
                <div class="form-group">
                        <div class="col-xs-12">
                            <div class="form-material">
                              <img width="100"src="./user_avatar/<?php echo $user_avatar;?>" alt="">
                              <input type="file" name="user_avatar" accept="image/*" class="form-control">
                                <label for="material-email">profiel pic</label>
                            </div>
                        </div>
                    </div>
                <div class="form-group">
                        <div class="col-xs-12">
                            <div class="form-material">
                                <input class="form-control" type="text"  name="email" value="<?php echo $email; ?>"required>
                                <label for="material-email">email</label>
                            </div>
                        </div>
                    </div>
                    <div class="form-group">
                            <div class="col-xs-12">
                                <div class="form-material">
                                    <input class="form-control" type="password"  name="password" value="" placeholder="if you want to change">
                                    <label for="material-email">new password</label>
                                </div>
                            </div>
                        </div>
        <div class="form-group">
            <div class="col-sm-9">
                <input class="btn btn-sm btn-primary" name="edit_profile" Value="submit" type="submit" >
            </div>
        </div>
    </form>
</div>
</div>