laravel-auth | Complete Build of Laravel | Authentication library

I am trying to implement a simple role-based authentication system in Laravel 7, where I have an additional field on user table named 'role' of integer type, which can have two values - 0 for general users and 5 for the admins.

Any logged in user should be able to access the '/railway' page. Only admins should be able to access the '/admin' page. Admins should also be able to access the '/railway' page.

I am following this article and getting 'too many redirect' error: https://dev.to/kaperskyguru/multiple-role-based-authentication-in-laravel-30pc

Edit:

Sorry forgot to mention!

Everything is working perfectly for the non-admin users. They are being redirected to the '/railway' page after logging in alright, and also being redirected to this page if they try to access the '/admin page'.

The error is happening for the admins only. It is redirecting them to the '/admin' page after logging in alright, but showing the 'too many redirection' error. But admins can access the '/railway' page which is perfect.

Edit-3 I've added this on a git repository, if anyone is interested to reproduce the issue: https://github.com/rawhasan/laravel-auth-bug.git

Here is what I've done so far:

web.php

I have accounts table in which I want to be Authenticatable and I done to this, already did the answer of @PintuKumar in this stackoverflow-link and it's working fine.

My issue here, the line below is working

I am currently developing a simple Bookstore application with a few numbers of users on which sending emails are not needed because it will be implemented in the local system so is there any way to customize laravel-auth for password reset function by adding a few security questions fields where user can reset his/her password without sending reset links via email.

Any kind of help will be highly appreciated.

here I tried the below code but id did not work

Code in web.php

Problem

I have added the Auth scaffolding to an existing project.

I keep getting the error

"SQLSTATE[42S22]: Column not found: 1054 Unknown column '' in 'where clause' "

with the sql output:

So for some reason I thought I came across the answer to this question before, but for the life of me I can't find the answer again, either through Google or StackOverflow. This might just be a rubber duck question and I'm sorry if it is, but I hope this question will be of some use to someone someday with this same issue.

Let's assume we're starting with a fresh installation of Laravel 5.4. I run the php artisan make:auth command in my terminal and it sets up the Authentication Scaffolding for me. Now in my /routes/web.php file I see the following line:

Auth::routes();

Which is awesome and the route list has all the Authentication routes listed including the logout route defined. (Typed php artisan r:l to double check) Now I want to set a custom logout route for the user using the a custom Logout Controller. Now, I thought that there was a method you could chain onto a group of resource routes called 'except()' but for the life of me I can't find any information in the documentation about this method. I don't know if this method even exists let alone know what to pass it.

I'm assuming that the Auth::routes() generation can use the except method like in a resource route, but I'm not entirely sure how to implement it?

So the question is simple. How do I include all authentication routes except the logout route, and then i'll define the logout route using the following line.

Route::get('logout', 'LogoutController@userLogout')->name('logout');

Sorry if this is a duplicate entry, I've used the search bar for the past hour and nothing is answering my question.

Edit: I did more research into Resource Routes and realized that it's not a method that I chain onto the route, but rather an array with a key value pair. See code below (Ripped from laravel docs).

Here is an "update" In the previous version of my project we didn't have any proper hashing on password. So I want to use Laravel's hashing, and invite the users to make a new password.

What I have is a new password column in my User table. If when the user tries to log in, the new password doesn't exist (empty column), we automatically do a "reset password." I would like to know where to do this verification:

I am 2-week-old to Laravel. I am using 5.8. I've planned to take the project from (https://github.com/jeremykenedy/laravel-auth) for learning purpose. I use sublime to track the functionalities or keywords and to look how it's defined in src. I can't track some words anywhere in the file. Sorry in advance if this question was too dumb.

I created a policy for authorization, so I faced with this problem.

I have seen these solutions, but my problem didn't solve yet:

Solution 1

Solution 2

Solution 3

Here are the Codes:

Function used in ArticalesController Class: