Laravel 4 authentication with multi database table

Question

How can I do authentication with multiple database table in Laravel?

For example, I have 3 tables: 1. General User Login table 2. Membership detail table 3. CMS user detail table

When user login from the CMS or the member login, the Auth will go and verify from the "general user login" table. But how can I make the Auth function also getting info from the second or third table depend on the user type? Then, I can access those info via something like Auth::user()->address, which the address is stored in the membership detail table.

Thank you.

Did you define the relationships between the different models? laravel.com/docs/eloquent#relationships — JackPoint
– JackPoint, Commented Jan 8, 2014 at 9:02

Antonio Carlos Ribeiro · Accepted Answer · 2014-01-08 15:57:55Z

3

Create relationship columns, to relate your user to data in other tables:

<?php

use Illuminate\Auth\UserInterface;
use Illuminate\Auth\Reminders\RemindableInterface;

class User extends Eloquent implements UserInterface, RemindableInterface {

    public function membership()
    {
        return $this->belongsTo('Membership');
    }

    public function userDetails()
    {
        return $this->belongsTo('CmsDetail');
    }

}

class Membership extends Eloquent {

    protected $table = 'membership';

}

class CmsDetail extends Eloquent {

    protected $table = 'cms_details';

}

Then you can just

echo Auth::user()->membership->member_since;

echo Auth::user()->userDetails->address;

answered Jan 8, 2014 at 15:57

Antonio Carlos Ribeiro

87.9k22 gold badges220 silver badges205 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Laravel 4 authentication with multi database table

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related