How to populate multiple database tables form a single form

You'll want some relationships on those so you can automatically create them both and assign them to each other.

Have you got any code done so far? Relationships?

Hi bashy my models are defined as follows currently.

Company model:

<?php

class Company extends Eloquent {

public function Users() { return $this->hasMany('User'); }

}

User model:

<?php

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

class User extends Eloquent implements UserInterface, RemindableInterface {

use UserTrait, RemindableTrait;

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

/** * The database table used by the model. * * @var string */ protected $table = 'users';

/** * The attributes excluded from the model's JSON form. * * @var array */ protected $hidden = array('password', 'remember_token');

}

I'm not sure on this but you may need to tweak it a little

$company = Company::create(['name' => Input::get('company_name')]);

$company->user()->insert(['username' => Input::get('username')]);

Never inserted two models and related them before.

There's also some other methods like $user->push()

No problem. Lets say for now that they arent related and i just need to populate two database tables with specifics fields of the same form.

Can you advise on a way to do that?

Thanks.

In that case, just copy the first line and do the same for the User model :)

$company = Company::create(['name' => Input::get('company_name')]);

$user = User::create(['username' => Input::get('username')]);

Or

$company = new Company;
$company->name = Input:get('company_name');
$company->save();

$user = new User;
$user->username = Input:get('username');
$user->save();

// If you need to access the IDs
// $user->id;
// $company->id;

This was my query really. isnt using

$company = new Company; $company->name = Input:get('company_name'); $company->save();

within joinController bad practice? shouldnt that be taken care of by CompanyController and UserController?

Oh I understand the last bit in your question now.

It depends what joinController is for and what Laravel version

JoinController is basically for handling the form, for displaying and capturing the data input into it. Im using laravel 4.2

you can use repositories to keep your controller clean.

I'll look into that. I don't suppose you have an example based around my issue?

a very simple example would be something like this for the controller:

class CompanyController extends Controller {

 private $companyRepository;
 private $userRepository;

 public function __construct(ICompanyRepository $companyRepository,
        IUserRepository $userRepository)
 {
  $this->companyRepository = $companyRepository;
  $this->userRepository = $userRepository;
 }

 public function store()
 {
  $company = $this->companyRepository->add(Input::only('company_name'));
  $user = $this->userRepository->add(Input::only('username'));
 }
}

and for the repo:

class CompanyRepository implements IRepository {

    private $company;

    function __construct(Company $company)
    {
        $this->company = $company;
    }

    public function add(array $input)
    {
        return $this->company->create($input);
    }
} 

of course you need to define the Interfaces and the binding with IoC container as well.

Thanks looking into it now.