最受欢迎

如何在Laravel5.2中使用不同的数据库表列名登录

How to get login with different database table column name in Laravel 5.2?

本文关键字：数据库 登录 Laravel5 | 更新日期: 2023-09-27

我必须在Laravel 5.2中实现登录功能。我已经使用官方的Laravel文档成功地做到了这一点，除了我不知道如何使用不同的数据库表列名（即st_username和st_password）对用户进行身份验证。

我在互联网上搜索了线索，但无济于事。我不知道我需要使用哪个类（例如，使用Illuminate...）进行身份验证。 如果有人知道答案，请告诉我。

这是我的代码：

登录视图

@extends('layouts.app')
@section('content')
<div class="contact-bg2">
    <div class="container">
        <div class="booking">
            <h3>Login</h3>
            <div class="col-md-4 booking-form" style="margin: 0 33%;">
                <form method="post" action="{{ url('/login') }}">
                    {!! csrf_field() !!}
                    <h5>USERNAME</h5>
                    <input type="text" name="username" value="abcuser">
                    <h5>PASSWORD</h5>
                    <input type="password" name="password" value="abcpass">
                    <input type="submit" value="Login">
                    <input type="reset" value="Reset">
                </form>
            </div>
        </div>
    </div>
</div>
<div></div>

@endsection

身份验证控制器

namespace App'Http'Controllers'Auth;
use App'User;
use Validator;
use App'Http'Controllers'Controller;
use Illuminate'Foundation'Auth'ThrottlesLogins;
use Illuminate'Foundation'Auth'AuthenticatesAndRegistersUsers;
class AuthController extends Controller
{
    use AuthenticatesAndRegistersUsers, ThrottlesLogins;
    protected $redirectTo = '/home';
    public function __construct()
    {
        $this->middleware('guest', ['except' => 'logout']);
        $this->username = 'st_username';
        $this->password = 'st_password';
    }
    protected function validator(array $data)
    {
        return Validator::make($data, [
                    'name' => 'required|max:255',
                    'email' => 'required|email|max:255|unique:users',
                    'password' => 'required|confirmed|min:6',
        ]);
    }

路由文件

Route::get('/', function () {
    return view('index');
});
Route::group(['middleware' => 'web'], function () {
    Route::auth();
    Route::get('/home', 'HomeController@index');
});

配置/身份验证.php

return [
    'defaults' => [
        'guard' => 'web',
        'passwords' => 'users',
    ],
    'guards' => [
        'web' => [
            'driver' => 'session',
            'provider' => 'users',
        ],
        'api' => [
            'driver' => 'token',
            'provider' => 'users',
        ],
    ],
    'providers' => [
        'users' => [
            'driver' => 'eloquent',
            'model' => App'User::class,
        ],
//        'users' => [
//            'driver' => 'database',
//            'table' => 'users',
//        ],
    ],
    'passwords' => [
        'users' => [
            'provider' => 'users',
            'email' => 'auth.emails.password',
            'table' => 'password_resets',
            'expire' => 60,
        ],
    ],
];

我搜索了很多如何自定义Laravel 5.2授权表格，这就是对我100%有用的东西。这是从下到上的解决方案。

此解决方案最初来自此处：https://laracasts.com/discuss/channels/laravel/replacing-the-laravel-authentication-with-a-custom-authentication

但我必须进行一些更改才能使其正常工作。

我的

网络应用程序适用于 DJ，因此我的自定义列名称带有"dj_"，例如名称为 dj_name

  1. 配置/身份验证.php

    // change this
'driver' => 'eloquent',
// to this
'driver' => 'custom',

  2. 在"配置/应用"中.php将自定义提供程序添加到列表中 ...

    'providers' => [
    ...
    // add this on bottom of other providers
    App'Providers'CustomAuthProvider::class,
    ...
],

  3. 创建自定义身份验证提供程序.php在文件夹应用''提供程序内 

    namespace App'Providers;
use Illuminate'Support'Facades'Auth;
use App'Providers'CustomUserProvider;
use Illuminate'Support'ServiceProvider;
class CustomAuthProvider extends ServiceProvider {
    /**
     * Bootstrap the application services.
     *
     * @return void
     */
    public function boot()
    {
        Auth::provider('custom', function($app, array $config) {
       // Return an instance of             Illuminate'Contracts'Auth'UserProvider...
        return new CustomUserProvider($app['custom.connection']);
        });
    }
    /**
     * Register the application services.
     *
     * @return void
     */
    public function register()
    {
        //
    }
}

  4. 创建自定义用户提供程序.php也在文件夹应用程序''提供程序中

    <?php
namespace App'Providers;
use App'User; use Carbon'Carbon;
use Illuminate'Auth'GenericUser;
use Illuminate'Contracts'Auth'Authenticatable;
use Illuminate'Contracts'Auth'UserProvider;
use Illuminate'Support'Facades'Hash;
use Illuminate'Support'Facades'Log;
class CustomUserProvider implements UserProvider {
/**
 * Retrieve a user by their unique identifier.
 *
 * @param  mixed $identifier
 * @return 'Illuminate'Contracts'Auth'Authenticatable|null
 */
public function retrieveById($identifier)
{
    // TODO: Implement retrieveById() method.

    $qry = User::where('dj_id','=',$identifier);
    if($qry->count() >0)
    {
        $user = $qry->select('dj_id', 'dj_name', 'first_name', 'last_name', 'email', 'password')->first();
        $attributes = array(
            'id' => $user->dj_id,
            'dj_name' => $user->dj_name,
            'password' => $user->password,
            'email' => $user->email,
            'name' => $user->first_name . ' ' . $user->last_name,
        );
        return $user;
    }
    return null;
}
/**
 * Retrieve a user by by their unique identifier and "remember me" token.
 *
 * @param  mixed $identifier
 * @param  string $token
 * @return 'Illuminate'Contracts'Auth'Authenticatable|null
 */
public function retrieveByToken($identifier, $token)
{
    // TODO: Implement retrieveByToken() method.
    $qry = User::where('dj_id','=',$identifier)->where('remember_token','=',$token);
    if($qry->count() >0)
    {
        $user = $qry->select('dj_id', 'dj_name', 'first_name', 'last_name', 'email', 'password')->first();
        $attributes = array(
            'id' => $user->dj_id,
            'dj_name' => $user->dj_name,
            'password' => $user->password,
            'email' => $user->email,
            'name' => $user->first_name . ' ' . $user->last_name,
        );
        return $user;
    }
    return null;

}
/**
 * Update the "remember me" token for the given user in storage.
 *
 * @param  'Illuminate'Contracts'Auth'Authenticatable $user
 * @param  string $token
 * @return void
 */
public function updateRememberToken(Authenticatable $user, $token)
{
    // TODO: Implement updateRememberToken() method.
    $user->setRememberToken($token);
    $user->save();
}
/**
 * Retrieve a user by the given credentials.
 *
 * @param  array $credentials
 * @return 'Illuminate'Contracts'Auth'Authenticatable|null
 */
public function retrieveByCredentials(array $credentials)
{
    // TODO: Implement retrieveByCredentials() method.
    $qry = User::where('email','=',$credentials['email']);
    if($qry->count() > 0)
    {
        $user = $qry->select('dj_id','dj_name','email','password')->first();

        return $user;
    }
    return null;

}
/**
 * Validate a user against the given credentials.
 *
 * @param  'Illuminate'Contracts'Auth'Authenticatable $user
 * @param  array $credentials
 * @return bool
 */
public function validateCredentials(Authenticatable $user, array $credentials)
{
    // TODO: Implement validateCredentials() method.
    // we'll assume if a user was retrieved, it's good
    // DIFFERENT THAN ORIGINAL ANSWER
    if($user->email == $credentials['email'] && Hash::check($credentials['password'], $user->getAuthPassword()))//$user->getAuthPassword() == md5($credentials['password'].'Config::get('constants.SALT')))
    {

        //$user->last_login_time = Carbon::now();
        $user->save();
        return true;
    }
    return false;

}
}

  5. 在 App/Http/Controllers/Auth/AuthController 中.php更改所有"名称"到"dj_name"并添加您的自定义字段（如果有的话）...您还可以将"电子邮件"更改为电子邮件列名称

  6. 在"照亮''基础''身份验证''用户"中.php添加

    protected $table = 'djs';
protected $primaryKey  = 'dj_id';

  7. 在"应用/用户"中.php将"名称"更改为"dj_name"并添加自定义字段。要将"密码"列更改为自定义列名称，请添加

    public function getAuthPassword(){
    return $this->custom_password_column_name;
}

  8. 现在后端已经全部完成，所以你只需要改变布局login.blade.php，register.blade.php，app.blade.php...在这里，您只需要将"名称"更改为"dj_name"，电子邮件或自定义字段...!!密码字段需要保持命名密码!!

此外，要进行唯一的电子邮件验证，请更改身份验证控制器.php

'custom_email_field' => 'required|email|max:255|unique:users',
to
'custom_email_field' => 'required|email|max:255|unique:custom_table_name',

此外，如果要将自定义created_at设置为updated_at字段，请更改"照明''数据库''雄辩''模型"中的全局变量.php

const CREATED_AT = 'dj_created_at';
const UPDATED_AT = 'dj_updated_at';

自定义身份验证：：try（）通过更改身份验证中的模型对我不起作用.php如下所示： 

'providers' => [
    'users' => [
        'driver' => 'eloquent',
        'model' => App'Person::class,
    ],
],

如果我尝试通过 Auth：：try 中的自定义列名称对人员进行身份验证： 

if (Auth::attempt(['persUsername' => $request->user, 'persPassword' => $request->pass])) {
    return redirect()->intended('/');
}

我得到同样的错误：

EloquentUserProvider 中的 ErrorException .php第 112 行：未定义的索引： 密码

但是我可以像这样验证一个人： 

$person = Person
    ::where('persUsername', $request->user)
    ->where('persPassword', $request->pass)
    ->first();
if (! is_null($person)) {
    if ($person->persUsername === $request->user && $person->persPassword === $request->pass) {
        Auth::login($person, false);
        return redirect()->intended('/');
    }
}

但我想这不是它应该的方式。

在提到的文件（EloquentUserProvider.php）中，我看到"密码"是硬编码的。 

public function retrieveByCredentials(array $credentials)
{
    $query = $this->createModel()->newQuery();
    foreach ($credentials as $key => $value) {
        if (! Str::contains($key, 'password')) {
            $query->where($key, $value);
        }
    }
    return $query->first();
}
public function validateCredentials(UserContract $user, array $credentials)
{
    $plain = $credentials['password'];
    return $this->hasher->check($plain, $user->getAuthPassword());
}

所以实际上没有办法简单地使用自定义列名作为密码？

这很容易，只需在 Auth：：try（）/method 中使用所需的列名，如下所示：

if (Auth::attempt(['st_username' =>$username,'st_password' => $password])) { 
    // Authentication passed... 
    return redirect()>intended('dashboard'); 
}

更新：如果您还希望更改默认users的默认身份验证表或更改默认情况下的模型名称或路径App'User，则可以在config'auth.php中找到这些设置 

/*
|--------------------------------------------------------------------------
| Authentication Table
|--------------------------------------------------------------------------
|
| When using the "Database" authentication driver, we need to know which
| table should be used to retrieve your users. We have chosen a basic
| default value but you may easily change it to any table you like.
|
*/
//'table' => 'users', 
'table' => 'new_tables_for_authentication',

/*
|--------------------------------------------------------------------------
| Authentication Model
|--------------------------------------------------------------------------
|
| When using the "Eloquent" authentication driver, we need to know which
| Eloquent model should be used to retrieve your users. Of course, it
| is often just the "User" model but you may use whatever you like.
|
*/
//'model' => App'User::class,
'model' => App'Models'User::class,
相关文章：
最新更新
www.56WenDa.com 2012-2023 | php问答网 | php学习