<?php
if(!$_SESSION){
    session_start();

}

$hostName='157.201.194.254';
$userName  = "jdoggett";
$password = '';


if(!($db = mysql_connect($hostName, $userName, $password))) {
    print"<br> Can't connect";
}
else
{
}

$database = 'jdoggett';

if(!(mysql_select_db($database))) {
    print "Error could not select database";
}
else
{
    $username = $_POST['username'];
    $passWord = $_POST['password'];


//////////////////////////////////////////////////////

    $user = "SELECT user_id FROM user WHERE username='$username' and password='$passWord'";
    $user_id = mysql_query($user);

    $users = mysql_fetch_assoc($user_id);

    $theUser = $users['user_id'];



///////////////////////////////////////////////////////

$role = "SELECT role_id FROM user WHERE username='$username' and password='$passWord'";
    $role_id = mysql_query($role);

    $roles = mysql_fetch_assoc($role_id);

    //echo "role_id" .$roles['role_id'];

///////////////////////////////////////////////////////
$sql = "SELECT * FROM user WHERE username='$username' and password='$passWord'";


    $result = mysql_query($sql);
    $row = mysql_fetch_array($result);
//  //$active = $row['active'];
    $count = mysql_num_rows($result);
//  //echo " count " + $count;

 if($count == 1 && $roles['role_id'] == 1){

 $_SESSION['user'] = $theUser;
    header('Location: teacher.php');
 } else if($count == 1 && $roles['role_id'] == 2) {
    header('Location: adminHome.html');
 }else{
    //echo $_POST['password'];
    echo "Wrong Username or Password";
    //echo $_POST['password'];
 }
}

?>