使用用户名而不是电子邮件laravel 5.2进行身份验证

Question

下面是我的AuthController 代码

<?php
namespace AppHttpControllersAuth;
use AppUser;
use Validator;
use AppHttpControllersController;
use IlluminateFoundationAuthThrottlesLogins;
use IlluminateFoundationAuthAuthenticatesAndRegistersUsers;
//use AppHttpRequestsRequest;
use Request;
use View;
use Hash;
use DB;
use Auth;
class AuthController extends Controller
{
    /*
    |--------------------------------------------------------------------------
    | Registration & Login Controller
    |--------------------------------------------------------------------------
    |
    | This controller handles the registration of new users, as well as the
    | authentication of existing users. By default, this controller uses
    | a simple trait to add these behaviors. Why don't you explore it?
    |
    */
    use AuthenticatesAndRegistersUsers, ThrottlesLogins;
    /**
     * Where to redirect users after login / registration.
     *
     * @var string
     */
    protected $redirectTo = '/home';
    protected $redirectAfterLogout = '/login';
    protected $username = 'user_name';
    /**
     * Create a new authentication controller instance.
     *
     * @return void
     */
    public function __construct()
    {
        $this->middleware($this->guestMiddleware(), ['except' => 'logout']);
    }
    /**
     * Get a validator for an incoming registration request.
     *
     * @param  array  $data
     * @return IlluminateContractsValidationValidator
     */
    protected function validator(array $data)
    {
        return Validator::make($data, [
            'name' => 'required|max:255',
            'email' => 'required|email|max:255|unique:users',
            'password' => 'required|min:6|confirmed',
        ]);
    }
    /**
     * Create a new user instance after a valid registration.
     *
     * @param  array  $data
     * @return User
     */
    protected function create(array $data)
    {
        return User::create([
            'name' => $data['name'],
            'email' => $data['email'],
            'password' => bcrypt($data['password']),
        ]);
    }
    public function showLogin()
    {
        if (Auth::check()) 
        {
            return redirect('/home');
        }
        else
        {
            return View::make('index');
        }
    }
    public function doLogin()
    {
        //echo 'test';
        $input = Request::all();
        $pass = Hash::make($input['password']);
        //print_r($input);exit;
        //echo $input['username'];exit;
        /*DB::table('admin_user')->insert(
            ['user_name' => $input['username'], 'password' => $pass]
        );*/
        if (Auth::attempt(['user_name' => $input['username'], 'password' => $input['password']])) {
            return redirect('/home');
            //return View::make('home');
        }
        else
        {
            return redirect('/');
        }

    }
    public function doLogout()
    {
        Auth::logout();
        return redirect('/');

    }
}

下面是我的路线代码

Route::get('/',array('uses'=>'AuthAuthController@showLogin') );
    Route::post('/login',array('uses'=>'AuthAuthController@doLogin'));

//Route::get('/login',array('uses'=>'Login@showLogin') );
Route::group(['middleware' => ['web', 'auth.basic']], function(){

    Route::get('/home',['uses'=>'Home@getHome']);
    Route::get('/logout',array('uses'=>'AuthAuthController@doLogout') );
});

我使用用户名而不是电子邮件id进行身份验证，但下面的错误显示为

SQLSTATE[42S22]：未找到列：1054中的未知列"电子邮件"where子句"（SQL：从admin_user中选择*，其中email=admin限制1）

下面是我的kernal.php代码

    <?php
namespace AppHttp;
use IlluminateFoundationHttpKernel as HttpKernel;
class Kernel extends HttpKernel
{
    /**
     * The application's global HTTP middleware stack.
     *
     * These middleware are run during every request to your application.
     *
     * @var array
     */
    protected $middleware = [
        IlluminateFoundationHttpMiddlewareCheckForMaintenanceMode::class,
    ];
    /**
     * The application's route middleware groups.
     *
     * @var array
     */
    protected $middlewareGroups = [
        'web' => [
            AppHttpMiddlewareEncryptCookies::class,
            IlluminateCookieMiddlewareAddQueuedCookiesToResponse::class,
            IlluminateSessionMiddlewareStartSession::class,
            IlluminateViewMiddlewareShareErrorsFromSession::class,
            AppHttpMiddlewareVerifyCsrfToken::class,
        ],
        'api' => [
            'throttle:60,1',
        ],
    ];
    /**
     * The application's route middleware.
     *
     * These middleware may be assigned to groups or used individually.
     *
     * @var array
     */
    protected $routeMiddleware = [
        'auth' => AppHttpMiddlewareAuthenticate::class,
        'auth.basic' => IlluminateAuthMiddlewareAuthenticateWithBasicAuth::class,
        'can' => IlluminateFoundationHttpMiddlewareAuthorize::class,
        'guest' => AppHttpMiddlewareRedirectIfAuthenticated::class,
        'throttle' => IlluminateRoutingMiddlewareThrottleRequests::class,
    ];
}

请帮我如何使用用户名登录。提前谢谢。

Answer 1

更新：

将auth中间件添加到特定路由

Route::group(['middleware' => ['web']], function(){
        Route::get('/',array('uses'=>'AuthAuthController@showLogin') );
        Route::post('/login',array('uses'=>'AuthAuthController@doLogin'));
        Route::get('/home',['uses'=>'Home@getHome'])->middleware('auth');//update
        Route::get('/logout',array('uses'=>'AuthAuthController@doLogout') );
    });

要在登录后重定向到预期页面，请用以下内容替换doLogin()功能：

public function doLogin()
    {
        $input = Request::all();
        $pass = Hash::make($input['password']);
        if (Auth::attempt(['user_name' => $input['username'], 'password' => $input['password']])) {
            return redirect()->intended('/home');//This line is changed
        }
        else
        {
            return redirect('/');
        }
    }

解释：intended()方法将用户重定向到上一个页面，用户从该页面重定向到登录页面。它需要一个默认路由作为参数，如果用户直接来到这里，就会将其发送到这里。

更新2:

在AuthController's构造函数中添加doLogout：

public function __construct()
{
$this->middleware($this->guestMiddleware(), ['except' => 'doLogout']);
}

Answer 2

您可以通过编写protected $username = 'username'来简单地覆盖AuthController中的$username。