Example #1
0
if (empty($_POST['username'])) {
    header("Location: index?e=un");
    exit;
}
if (empty($_POST['password'])) {
    header("Location: index?e=pw");
    exit;
}
$ADK_USER_USERNAME = $_POST['username'];
$ADK_USER_PASSWORD = md5($_POST['password']);
$page = $_POST['page'];
if ($page === 'index' || $page === 'login') {
    $page = '';
}
$con = connect_db();
$sql_query = sql_login_check($con, $ADK_USER_USERNAME, $ADK_USER_PASSWORD);
if ($sql_query->execute()) {
    $sql_query->store_result();
    $result = sql_get_assoc($sql_query);
    foreach ($result as $row) {
        $ADK_USER = new User();
        $ADK_USER->id = $row['ADK_USER_ID'];
        $ADK_USER->username = $row['ADK_USER_USERNAME'];
        $ADK_USER->usernameusergroupid = $row['ADK_USERGROUP_ID'];
        $ADK_USER->name = $row['ADK_USER_NAME'];
        $ADK_USER->email = $row['ADK_USER_EMAIL'];
        $ADK_USER->usergroupcde = $row['ADK_USERGROUP_CDE'];
    }
} else {
    die('There was an error running the query [' . $con->error . ']');
}
Example #2
0
//Imports
require_once 'db.php';
require_once 'User.php';
if (empty($_POST['un'])) {
    header("Location: ../?e=un");
    exit;
}
if (empty($_POST['pw'])) {
    header("Location: ../?e=pw");
    exit;
}
$un = $_POST['un'];
$pw = md5($_POST['pw']);
$con = connect_db();
$sql_query = sql_login_check($con, $un, $pw);
if ($sql_query->execute()) {
    $sql_query->store_result();
    $result = sql_get_assoc($sql_query);
    foreach ($result as $row) {
        $user = new User();
        $user->id = intval($row['USER_ID']);
        $user->grp = intval($row['USER_GRP']);
        $user->name = $row['USER_NAME'];
        $user->un = $row['USER_UN'];
    }
} else {
    die('There was an error running the query [' . $con->error . ']');
}
$con->close();
//If no user, exit