content

<?php session_start();?>

<?php

if(!isset($_SESSION['display_name'])) {

	header("Location: please_login.php");
	die();
}


?>


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

	<div class="form-group">

		<?php

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

			$user_id = $_GET['edit'];

			$query = $connection->prepare("

					SELECT users.username, users.display_name, users.id, users.email, tblCarriers.CarrierName, tblCarriers.CarrierID
					FROM users, tblCarriers
					WHERE tblCarriers.CarrierID = users.carrierID AND 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'];
				$carrier = $row['CarrierName'];

				?>
				<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>

					<div class="form-group">
						<label for="carrier">Carrier</label>
						<select class="form-control" name="carrier">

							<?php

					while($row = $query->fetch(PDO::FETCH_ASSOC)){
						echo '<option value="'.$row['CarrierID'].'">'.$row['CarrierName'].'</option>';
					}
							?>
						</select>
					</div>

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

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

		$query = $connection->prepare("

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

		");

		$query->execute([

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

		]);


		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>