content

<form action="" method="post">

	<div class="form-group">

		<?php

		if(isset($_GET['edit'])){

			$user_id = $_GET['edit'];

			$query = $connection->prepare("

				SELECT * FROM users WHERE ID = :user_id

			");

			$query->execute([
				'user_id'=>$user_id
			]);


				while($row = $query->fetch(PDO::FETCH_ASSOC)){
				$user_id = $row['id'];
				$username = $row['username'];
				$display_name = $row['display_name'];
				$email = $row['email'];

		?>
		<div class="col-xs-6">
		<h3>Edit User</h3><br>
			<div class="form-group">
			<label for="username">Username</label>
			<input value="<?php if(isset($username)){echo $username;} ?>"class="form-control" type="text" name="username">
			</div>

			<div class="form-group">
			<label for="display_name">Display Name</label>
			<input value="<?php if(isset($display_name)){echo $display_name;} ?>"class="form-control" type="text" name="display_name">
			</div>

			<div class="form-group">
			<label for="email">Email Address</label>
			<input value="<?php if(isset($email)){echo $email;} ?>"class="form-control" type="text" name="email">
			</div>

		<?php
			}
		}
		//UPDATE QUERY
		if(isset($_POST['update_users'])){

			$get_user = $_POST['username'];
			$get_display_name = $_POST['display_name'];
			$get_email = $_POST['email'];

			$query = $connection->prepare("

				UPDATE users SET username = :username, display_name = :display_name, email = :email
				WHERE id = :id

			");

			$query->execute([

				'username'=>$get_user,
				'display_name'=>$get_display_name,
				'email'=>$get_email,
				'id'=>$user_id

			]);
			header("Location: users.php");
		}
		?>

	<div class="form-group">
		<input class="btn btn-primary" type="submit" name="update_users" value="Update User">
		<a href="users.php"><input class="btn btn-primary pull-right" value="Cancel"></a>
	</div>

	</div>
</div>
</form>