How to insert data from one form in different database table in Laravel

Question

I am new to Laravel. I want to register the account so I have one form that has the details about the username, email, password, company name, and other company details. I got 2 tables in my database. Table 1 is the user table which is used to store the user details to log in like userID, email, password, and companyID (from table 2). Table 2 is the company table that stores company details. Table 2 has companyID, companyName, and so on. I want to ask how can I use one form to save my data in two different tables.

Here is the code from RegisterController

protected function create(array $data)
{
    return User::create([
        'username' => $data['name'],
        'email' => $data['email'],
        'password' => bcrypt($data['password']),
    ]);

}

Jignesh Joisar · Accepted Answer · 2021-12-13 12:29:34Z

1

First You Need To Insert In Company Table Then User Table Like This .

protected function create(array $data)
{
   $company=Company::create([
       'companyName'=>$data['companyName']
   ]);

    User::create([
        'username' => $data['name'],
        'email' => $data['email'],
        'password' => bcrypt($data['password']),
        'companyID'=>$company->id
    ]);
 }

edited Dec 13, 2021 at 12:29

Jignesh Joisar

15.4k6 gold badges69 silver badges61 bronze badges

answered Dec 13, 2021 at 7:26

vivek vaghela

1391 silver badge7 bronze badges

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

1 Comment

dipgirl Over a year ago

@Vivel vaghela, thank you for your reply. I will try with your answer

Maik Lowrey · Accepted Answer · 2021-12-13 07:46:09Z

0

Laravel has a very elegant solution for this. First you have to set the relations between both models. As it happens, your example can now cover both directions. That's why I now assume: a user can have many companies and a company only one user.

This means that in the user model you set the relation

protected function companies() {
    return $this->hasMany(Company::class);
}

And in the Company Model you set this method:

protected function user() {
    return $this->belongsTo(User::class);
}

Then in your controller, service etc. you can call the following:

$user = User::create([
        'username' => $data['name'],
        'email' => $data['email'],
        'password' => bcrypt($data['password']),
    ]);

$company = [
    'companyName' => 'fooBar',
];

$user->companies()->save($company);

Link to the doc: https://laravel.com/docs/5.1/eloquent-relationships#inserting-related-models

answered Dec 13, 2021 at 7:46

Maik Lowrey

17.8k8 gold badges55 silver badges101 bronze badges

5 Comments

dipgirl Over a year ago

thank you for your reply, after I follow your code, I get this error Call to undefined method App\User::companies()

Maik Lowrey Over a year ago

@dipgirl this error means that the componies() method is missing in the user model

dipgirl Over a year ago

after I change to $user->User::companies()->save($company); it work then come out this error : Class name must be a valid object or a string

Maik Lowrey Over a year ago

@dipgirl this error means that you dont have Company as model in your application. or he didnt find it. you have these file under `app/models/Company.php? and the class name is Company.

dipgirl Over a year ago

ok I check again

Collectives™ on Stack Overflow

How to insert data from one form in different database table in Laravel

2 Answers 2

1 Comment

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related