nprussell

function checkLogin(){

	if(isset($_SESSION['username'] && isset($_SESSION['password'])))
		return true;
	elseif (isset($_COOKIE['username']) && isset($_COOKIE['password']))
		{

		$username = $_COOKIE['username'];

		$query = $connection->prepare("

nprussell

function checkLogin(){

	$username = $_COOKIE['username'];

	$query = $connection->prepare("

		SELECT * FROM adminUsers WHERE username = :username

	");

nprussell

<?php include "db.php" ?>

<?php session_start(); ?>

<?php
if(isset($_POST['login'])){

	$username = $_POST['username'];
	$password = $_POST['password'];

nprussell

<?php

function findAllUsers(){

	global $connection;

	$query = $connection->prepare("

	SELECT users.username, users.display_name, users.id, users.email, tblCarriers.CarrierName
	FROM users, tblCarriers

nprussell

<?php session_start();?>

<?php

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

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

nprussell

function addUser(){

	global $connection;

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

		$username = $_POST['username'];
		$password = $_POST['password'];
		$display_name = $_POST['display_name'];
		$email = $_POST['email'];

nprussell

<select class="form-control" name="carrier">

									<?php
									$query = $connection->prepare("

										SELECT * FROM tblCarriers

									");

									$query->execute();

nprussell

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

									<?php
									$query = $connection->prepare("

										SELECT CarrierName FROM tblCarriers

									");

nprussell

function addUser(){

	global $connection;

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

		$username = $_POST['username'];
		$password = $_POST['password'];
		$display_name = $_POST['display_name'];
		$email = $_POST['email'];

nprussell

	SELECT users.display_name, serialNumbers.location, COUNT(serialNumbers.Location) AS cnt
	FROM tracking
	INNER JOIN users ON tracking.user=users.id
	LEFT JOIN serialNumbers ON serialNumbers.serial=tracking.computerSerial
	GROUP BY serialNumbers.location
	HAVING ( cnt > 0 )
	ORDER BY cnt DESC