public static function Login ($login_name, $pass, $redirect) { $md5pass = md5($pass); $user_exists = DataBase::ExecuteScalar("SELECT count(1) FROM users WHERE login = '******' AND password = '******'"); if($user_exists == 1){ $qry = "SELECT * FROM users WHERE login = '******' AND password = '******'"; //echo $qry; $row = DataBase::ExecuteQuery($qry); $_SESSION["user"] = new User($row[0][0], $row[0][1], $row[0][2], $row[0][3], $row[0][4], $row[0][5]); //print_r($row); #----------------------------- echo "<script>window.location = '$redirect'</script>"; }else{ echo "Nombre de Usuario y Contraseña no coinciden, Favor de reintentar."; } }
function getProfileName($profileID) { $sql = "SELECT nombre FROM security_profiles WHERE id=" . $profileID; return DataBase::ExecuteScalar($sql); }