DEV Community

Cover image for How to insert data in one to one relationship in database?
Mahmoud Adel
Mahmoud Adel

Posted on • Originally published at laravelspa.site on

How to insert data in one to one relationship in database?

After we created a one-to-one relationship between the users table and the profiles table, and added the hasOne() method to the User model, and the belongsTo() method to the Profile model, it's time to find out how the data is saved in the database when we use this relationship. And what are the methods used for that?

These methods are divided into three main ways:

  1. Without using method profile.
  2. By using method profile.
  3. By using the inverse method user.

The best method to use depends on the specific needs of your application.
If you only need to save the profile associated with the user, then the first method is the simplest option.
If you need to get, update, or delete the profile, then the second method is a better option.
If you need to get, update, or delete the user, then the third method is a better option.

1. Without using method profile.

  • We first go to the routes/web.php file and add a new route so that we can test these method.
use App\Models\Profile;
use App\Models\User;
---
Route::get('/one-to-one', method () {
    $user = User::create(['username' => 'John Doe']);
    Profile::create([
        'user_id' => $user->id,
        'firstname' => 'John',
        'lastname' => 'Doe',
        'birthday' => '08-11-1991'
    ]);
    return response()->json([
        'username' => $user->username,
        'firstname' => $user->profile->firstname,
        'lastname' => $user->profile->lastname,
    ]);
});
Enter fullscreen mode Exit fullscreen mode
  • We opened the browser and went to the link http://127.0.0.1:8000/one-to-one. To our satisfaction, the user had been created successfully.
{
  "username": "John Doe",
  "firstname": "John",
  "lastname": "Doe"
}
Enter fullscreen mode Exit fullscreen mode

2. By using method profile.

  • We first go to the routes/web.php file and edit this route.
Route::get('/one-to-one', method () {
    $user = User::create(['username' => 'Tom Cruz']);
    $user->profile()->create([
      'firstname' => 'Tom',
      'lastname' => 'Cruz',
      'birthday' => '01-02-2000'
    ]);
    return response()->json([
        'username' => $user->username,
        'firstname' => $user->profile->firstname,
        'lastname' => $user->profile->lastname,
    ]);
});
Enter fullscreen mode Exit fullscreen mode
  • We open the browser again and go to this link: http://127.0.0.1:8000/one-to-one to find that the user has been created successfully.
{
  "username": "Tom Cruz",
  "firstname": "Tom",
  "lastname": "Cruz"
}
Enter fullscreen mode Exit fullscreen mode

3. By using the inverse method user.

  • We first go to the routes/web.php file and update this route.
Route::get('/one-to-one', method () {
    $user = User::create(['username' => 'Adam Smith']);
    $profile = new Profile([
        'firstname' => 'Adam',
        'lastname' => 'Smith',
        'birthday' => '01-01-1999'
    ]);

    $profile->user()->associate($user)->save();
    return response()->json([
        'username' => $profile->user->username,
        'firstname' => $profile->firstname,
        'lastname' => $profile->lastname,
    ]);
});
Enter fullscreen mode Exit fullscreen mode
  • We open the browser again and go to this link: http://127.0.0.1:8000/one-to-one to find that the user has been created successfully.
{
  "username": "Adam Smith",
  "firstname": "Adam",
  "lastname": "Smith"
}
Enter fullscreen mode Exit fullscreen mode
  • You can find the repo of this series on github here

Do your career a big favor. Join DEV. (The website you're on right now)

It takes one minute, it's free, and is worth it for your career.

Get started

Community matters

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more

👋 Kindness is contagious

Discover a treasure trove of wisdom within this insightful piece, highly respected in the nurturing DEV Community enviroment. Developers, whether novice or expert, are encouraged to participate and add to our shared knowledge basin.

A simple "thank you" can illuminate someone's day. Express your appreciation in the comments section!

On DEV, sharing ideas smoothens our journey and strengthens our community ties. Learn something useful? Offering a quick thanks to the author is deeply appreciated.

Okay