Laravel 5.4，重命名用户表列

所以今天我试图在laravel项目中修改默认身份验证.

So today I tried to modify the default auth in my laravel project.

首先:Composer(1.4.2)和Laravel(5.4.27)(也意味着所有依赖项)是最新的.我用以下方法验证了这一点:

First of all: Composer (1.4.2) and Laravel (5.4.27) (meaning also all dependencies) are up to date. I verified this with:

composer self-update
composer update

然后我通过迁移更改了用户表:

Then I altered the users table via a migration:

Schema::table('users', function (Blueprint $users){
    $users->string('login', 16)->unique()->after('id');
    $users->string('real_name', 32)->after('email');
});

Schema::table('users', function(Blueprint $users){
    $users->dropColumn([
        'name'
    ]);
});

重要的是我要使用登录"而不是名称".

The important part of that is that I want to use 'login' instead of 'name'.

接下来我要做的就是修改User类，如下所示:

Next thing I did was modifying the User class as follows:

protected $fillable = [
    'login',
    'email',
    'real_name',
    'password'
];
protected $primaryKey = 'login';

public function getAuthIdentifierName()
{
    return 'login';
}

还有LoginController:

And also the LoginController:

public function username()
{
    return 'login';
}
protected function validateLogin(Request $request)
{
    $this->validate($request, [
        $this->username() => 'required|string',
        'password' => 'required|string',
        'g-recaptcha-response' => 'required|captcha'
    ]);
}

最后，我更改了登录视图:

Finally I changed the login view:

<div class="form-group{{ $errors->has('login') ? ' has-error' : '' }}">
    <label for="login" class="col-md-4 control-label">Login</label>

    <div class="col-md-6">
        <input id="login" type="text" class="form-control" name="login" value="{{ old('login') }}" required autofocus>

        @if ($errors->has('login'))
            <span class="help-block">
                <strong>{{ $errors->first('login') }}</strong>
            </span>
        @endif
      </div>
</div>

现在我应该具有有效的身份验证了，对吗?这就是我的想法.

Now I should have a working authentication, right? That's what I thought.

登录本身可以工作，但是在读取登录"字段的值时会失败-或类似的事情.

The login itself works but when it comes to reading the value of the field 'login' it fails - or something like this.

调试栏告诉我以下内容:

debug-bar told me the following:

将在登录时执行的查询为:

The query which will be executed on login is:

select * from `users` where `login` = 'admin' limit 1

除了登录"之外，哪个可以正确加载所有数据.由于某些原因，该字段保持为"0"(在身份验证网络中)

Which is loading all the data correctly except of 'login'. For some reason this field stays '0' (in auth web)

"user" => array:10 [
    "id" => 1
    "email" => "email@email.com"
    "created_at" => "2017-06-16 03:08:43"
    "updated_at" => "2017-06-16 03:08:43"
    "login" => 0
    "real_name" => "PolluX"

最后要显示默认主视图时，执行的查询为:

And when it finally comes to displaying the default home view the executed query is:

select * from `users` where `login` = '0' limit 1

我正在使用XAMPP v3.2.2，PHP 7.1.1和10.2.6-MariaDB作为Windows 10上的本地开发环境.我应该提一下，我用全新下载的XAMPP版本替换了该XAMPP版本的默认出厂MariaDB.最新的稳定MariaDB版本. (由于迁移的错误)

I'm using XAMPP v3.2.2, PHP 7.1.1 and 10.2.6-MariaDB as my local dev environment on Windows 10. I should mention that I replaced the default shipped MariaDB of this XAMPP version with a fresh download of the latest stable MariaDB version. (because of an error of the migration thing)

我还检查了关于StackOverflow，Laracasts等上的auth内容的多个帖子，但没有找到任何可以帮助我的帖子.

I also checked multiple posts on the auth thing on StackOverflow, Laracasts and so on but didn't find any post that could've helped me.

例如 https://laracasts.com/discuss/channel/laravel/更改名称列到身份验证中的用户名