PHP clsDBConnSIKP::ToSQL Examples

Example #1

File: Common.php Project: rayminami/mpd-online

function CCLoginUser($login, $password)
{
    CCLogoutUser();
    $db = new clsDBConnSIKP();
    $SQL = "SELECT p_app_user_id, p_user_status_id, user_pwd FROM p_app_user WHERE app_user_name=" . $db->ToSQL($login, ccsText) . " AND user_pwd=" . $db->ToSQL($password, ccsText);
    $db->query($SQL);
    $Result = $db->next_record();
    if ($Result) {
        CCSetSession("UserID", $db->f("p_app_user_id"));
        CCSetSession("UserLogin", $login);
        CCSetSession("GroupID", $db->f("p_user_status_id"));
    }
    return $Result;
}