prepare("SELECT user_id FROM hotspot_users WHERE 1");
$stmt->execute(array());
}
catch(PDOException $e) {
try {
include('database.php');
$stmt = $DB_con->prepare("SELECT user_id FROM hotspot_users WHERE 1");
$stmt->execute(array());
}
catch(PDOException $e) {
echo "Error Accessing Data: " . $e->getMessage();
}
}
$count = $stmt->rowCount();
if( $count == 0 ) {
$password = sha1('admin');
$stmt = $DB_con->prepare("insert into hotspot_users (date_added, firstname, username, password, user_level, status, user_group, created_at)
values(CURDATE(), 'Administrator', :username, :password, :level, 'Active', 1, NOW())");
$stmt->execute(array(':username' => 'admin', ':password' => $password, ':level' => 1));
}
try
{
$stmt = $DB_con->prepare("SELECT * FROM hotspot_users WHERE username=:username AND password =:password AND status =:status");
$stmt->execute(array(':username' => $username, ':password' => $password, ':status' => 'Active'));
$count = $stmt->rowCount();
}
catch(PDOException $e) {
echo "Error: " . $e->getMessage();
}
if( $count == 1 ) {
$row=$stmt->fetch(PDO::FETCH_ASSOC);
$_SESSION['id']=$row['user_id'];
$_SESSION['username']=$row['firstname'].' '.$row['lastname'];
$_SESSION['user_level']= $row['user_level'];
echo '';
}
else
{
echo '';
}
}
?>