อยากได้โค้ดพร้อมตัวอย่างทำหน้า logig โดยใช้ MSSQL

DB_CONNECTION=sqlsrv
DB_HOST=127.0.0.1
DB_PORT=1521
DB_DATABASE=mydatable
DB_USERNAME=sa
DB_PASSWORD=sqlsrv2014

    'default' => env('DB_CONNECTION', 'sqlsrv'),

    'connections' => [
            'driver' => 'sqlsrv',
            'host' => env('DB_HOST', 'localhost'),
            'port' => env('DB_PORT', '1521'),
            'database' => env('DB_DATABASE', 'forge'),
            'username' => env('DB_USERNAME', 'forge'),
            'password' => env('DB_PASSWORD', ''),
            'charset' => 'utf8',
            'collation' => 'utf8_unicode_ci',
            'prefix' => '',
            'strict' => false,
            'engine' => null,
    ],

<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateUsersTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('users', function (Blueprint $table) {
            $table->increments('id');
            $table->string('name');
            $table->string('email')->unique();
            $table->string('password');
            $table->rememberToken();
            $table->timestamps();
        });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('users');
    }
}

<?php

use Illuminate\Database\Seeder;

class DatabaseSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $this->call(UsersTableSeeder::class);
    }
}

<?php

use Illuminate\Database\Seeder;

class UsersTableSeeder extends Seeder
{
    /**
     * Run the database seeds.
     *
     * @return void
     */
    public function run()
    {
        $array = [
                ['name' => 'admin', 'email' => '[email protected]', 'password' => 'admin'],
            ];

        // Loop through each user above and create the record for them in the database
        foreach ($array as $user) {
            $obj = new App\User($user);
            $obj->save();
        }
    }
}

<?php

namespace App;

use Illuminate\Foundation\Auth\User as Authenticatable;

class User extends Authenticatable
{
    /**
     * The attributes that are mass assignable.
     *
     * @var array
     */
    protected $fillable = [
        'name', 'email', 'password',
    ];

    /**
     * The attributes that should be hidden for arrays.
     *
     * @var array
     */
    protected $hidden = [
        'password', 'remember_token',
    ];
}

    // Auth Route...
    Route::controller('/auth', 'AuthController');

    // Member Route...
    Route::group(['middleware' => 'auth'], function () {
        Route::get('/', function () {
            return view('welcome');
        });
    });

<?php

namespace App\Http\Controllers\Auth;

use App\User;
use App\Http\Controllers\Controller;

class AuthController extends Controller
{
    /**
     * Where to redirect users after login / registration.
     *
     * @var string
     */
    protected $redirectTo = '/';

    /**
     * Create a new authentication controller instance.
     *
     * @return void
     */
    public function __construct()
    {
        $this->middleware($this->guestMiddleware(), ['except' => 'logout']);
    }

    public function getLogin() {
        return view('webapp.login');
    }

    public function postLogin(Request $request) {
        // grab credentials from the request
        $credentials = $request->only('email', 'password');

        $rules = [
            'email' => 'required|exists:users,email,deleted_at,NULL', 
            'password' => 'required|min:6', 
        ];

        $attributeNames = [
            'email' => 'บัญชีผู้ใช้',
            'password' => 'รหัสผ่าน',
        ];

        $validator = Validator::make($credentials, $rules);
        $validator->setAttributeNames($attributeNames);

        if ($validator->fails()) {
            return redirect()->back()
                ->withErrors('ชื่อผู้ใช้หรือรหัสผ่านไม่ถูกต้อง')
                ->withInput($request->except('password'));
        }
        else {
            if (Auth::attempt($credentials, $request->has('remember'))) {

                return redirect()->route('index');
            }
            else {
                return redirect()->back()
                    ->withErrors('ชื่อผู้ใช้หรือรหัสผ่านไม่ถูกต้อง')
                    ->withInput($request->except('password'));
            }
        }
    }

    public function getLogout() {
        Auth::logout();
 
        return redirect()->route('auth.login');
    }
}

    <div class="container-fluid">
        <div class="row">
            {!! Form::open(array('url' => URL::to('auth/login'), 'method' => 'post', 'files'=> true)) !!}
            <div class="form-group  {{ $errors->has('email') ? 'has-error' : '' }}">
                {!! Form::label('email', "E-Mail Address", array('class' => 'control-label')) !!}
                <div class="controls">
                    {!! Form::text('email', null, array('class' => 'form-control')) !!}
                    <span class="help-block">{{ $errors->first('email', ':message') }}</span>
                </div>
            </div>
            <div class="form-group  {{ $errors->has('password') ? 'has-error' : '' }}">
                {!! Form::label('password', "Password", array('class' => 'control-label')) !!}
                <div class="controls">
                    {!! Form::password('password', array('class' => 'form-control')) !!}
                    <span class="help-block">{{ $errors->first('password', ':message') }}</span>
                </div>
            </div>
            <div class="form-group">
                <div class="col-md-6 col-md-offset-4">
                    <div class="checkbox">
                        <label>
                            <input type="checkbox" name="remember"> Remember Me
                        </label>
                    </div>
                </div>
            </div>

            <div class="form-group">
                <div class="col-md-6 col-md-offset-4">
                    <button type="submit" class="btn btn-primary" style="margin-right: 15px;">
                        Login
                    </button>

                    <a href="{{ URL::to('/password/email') }}">Forgot Your Password?</a>
                </div>
            </div>
            {!! Form::close() !!}
        </div>
    </div>