Laravel custom columns login authentication

no comments
6 Oct 2017 1:43 am

Laravel provide a great solution for login authentication, in sometimes we have typically a database table with custom table name  eg: student, customer, employee, and custom login columns eg:student_id, customer_id, employee_id but the default in Laravel authentication only use id, login and password columns.

To get install laravel from composer if you don’t have composer, Download Composer

After the Installation of composer go to your projects directory eg www for wamp or htdocs for xampp
Shift+click to open cmd from open command prompt from right click menu

Shift+click to open cmd from open command prompt from right click menu

composer create-project –prefer-dist laravel/laravel studentlogin

laravel remove public from url

Add student guard for authentication in config/auth.php

'guards' => [
	'student' => [
		'driver' => 'session',
		'provider' => 'student',
	//web and api guards are already added in file.
	'web' => [
		'driver' => 'session',
		'provider' => 'users',
	'api' => [
		'driver' => 'token',
		'provider' => 'users',

Add student provider in config/auth.php

'providers' => [
	'student' => [
		'driver' => 'eloquent',
		'model' => App\Model\StudentLoginModel::class,
		'table' => 'student',
	//Below user provide is already added in your auth.php code
	'users' => [
		'driver' => 'eloquent',
		'model' => App\User::class,

Create Student Login Model

Create Model folder in following directory App/Model and Create Student Login Model file name it as StudentLoginModel.php and write the following code in student model file.

namespace App\Model;
use Illuminate\Foundation\Auth\User as Authenticatable;

class StudentLoginModel extends Authenticatable{
    protected $table = 'student';
    protected $primaryKey = 'stdnt_id';
    protected $fillable = ['stdnt_id', 'stdnt_email','stdnt_password'];

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

Create Controller to authenticate the student

Create file named it StudentController.php in app/Http/Controllers

namespace App\Http\Controllers;
use Illuminate\Support\Facades\Input;
use Illuminate\Routing\Controller as BaseController;

class StudentController extends BaseController{
	public function LoginActionHandler(){
			$credentials = ['stdnt_email'=>Input::get('loginemail'),'password'=>Input::get('loginpassword')];
			$studentAuth = auth()->guard('student');
			if($studentAuth->attempt($credentials)) {
				return back();
			} else {
				return redirect()->back()->withErrors('Invalid Login, please try again');

Create Logout method add into StudentController

public function logout(){
	return back();

Create database sdtuts_studentlogin
In database we’ll create table with _prefix and add shortprefix for columns
Open PhpMyAdmin from your localhost url http://localhost/phpmyadmin

Create database

Create database

Create sdtuts_student table with the with following columns
stdnt_id ( PK, int(255) ), stdnt_emailaddress (varchar(255) ),stdnt_password(varchar(255))
Enter 1 into stdnt_id
Enter for student
Enter $2y$10$DLRX5faT0c6uxkwnoFtT7.Jd/vJeuOzkYhKKfnlTHgVuf0mgxODpS password for stdnt_password “studentPassword”

Or Generate your own password quickly by go to routes/web.php and put the following code

Route::get('/', function () {
    //return view('welcome');

Create Routes for Login, Logout, and Showing logged in data(id)

Route::get('/', function () {


Add database configuration in .env

go to installed directory and open .env file with any notepad and add the database information


Create LoginViewHandler, LoginStatusHandler methods in StudentController file.

Add Facades of View for using losing template define it before controller class start

use Illuminate\Support\Facades\View;
//define the above line in before controller start
public function LoginViewHandler(){
    return View::make('loginview');

Create login loginview.blade.php in resources/views I have copied default welcome.blade.php file and modify it. I am just simple html for quick purpose and skip the Laravel Collective html library if you want to Laravel’s Forms & HTML following the link I will also create next tutorial for Laravel Forms & HTML with validation
here is the login code of html.

<!doctype html>
<html lang="{{ config('app.locale') }}">
        <meta charset="utf-8">
        <meta http-equiv="X-UA-Compatible" content="IE=edge">
        <meta name="viewport" content="width=device-width, initial-scale=1">
        <!-- Fonts -->
        <link href=",600" rel="stylesheet" type="text/css">
        <!-- Styles -->
            html, body {
                background-color: #fff;
                color: #636b6f;
                font-family: 'Raleway', sans-serif;
                font-weight: 100;
                height: 100vh;
                margin: 0;

            .full-height {
                height: 100vh;

            .flex-center {
                align-items: center;
                display: flex;
                justify-content: center;

            .position-ref {
                position: relative;

            .top-right {
                position: absolute;
                right: 10px;
                top: 18px;

            .content {
                text-align: center;

            .title {
                font-size: 84px;

            .links > a {
                color: #636b6f;
                padding: 0 25px;
                font-size: 12px;
                font-weight: 600;
                letter-spacing: .1rem;
                text-decoration: none;
                text-transform: uppercase;;

            .m-b-md {
                margin-bottom: 30px;
        <div class="flex-center position-ref full-height">
            <div class="content">
			<form method="post" action="/sdtutslogin/login_action">
				<div class="title m-b-md">
                    Student Login
				<input type="hidden" name="_token" value="{{csrf_token()}}" />
				<input type="text" name="loginemail" placeholder="Enter your email" />
				<input type="password" name="loginpassword" placeholder="Enter your password" />
				<input type="submit" value="Student Login" />

laravel login view blade template

laravel login view blade template

by default DB_PREFIX not added in .env file so first defined it in .env file and use in config/database.php file

Preview of logged in session

session print preview

NOTE:Your Email Address will be not shown and please do not add spamming comments because here is REL="NOFOLLOW" on your links and comments also moderated shown.
<code>Put html css or any language code under this tag</code>