Skip to main content

Eloquent Relationship Explained (ONE TO MANY)

Suppose you have two tables:

users and posts tables.

users table includes:
id,name,email

posts table includes:
id,title,body,user_id

One to many relationship:

Go to User model and write:


public function posts(){
 return $this->hasMany('App\Post');
}

Look at the function naming convention. It's plural as it is one to many relationship.

Store:

$user->posts()->save($post);

Here, $user variable comes from findorfail($id). and $post variable has taken the
requested data from user. I haven't shown all of this in details here as it is only to
understand how one to many relationship actually works.


Show:
foreach($user->posts as $post){
   echo $post->title."<br>";
}

Update:
$user->posts()->where('id','=',2)->update(['title'=>'your updated title','body'=>'your updated body');

Delete:
$user->posts->whereId(1)->delete();

To delete all the users posts:
$user->posts->delete();


Thanks for reading.


Comments

Popular posts from this blog

Laravel Vuejs Basic Setup

In this article we will see how to setup vue with laravel. 1) Create a laravel project: laravel new laravue 2) In web.php create a temporary route:  Route :: get ( '/test' ,  function  () {      return   view ( 'welcome' ); }); So, when you will see the welcome page once you hit the  http://laravue.test/test  url. 2) In terminal run:  npm install 3) npm install vue (In package.json file you will see that vue dependency has been added successfully) 4) Now go to resources -> js -> app.js file. Here we will have to load the vue. write the following lines in app.js.  require ( './bootstrap' ); window . Vue  =  require ( 'vue' ); const   app  =  new   Vue ({      el :   '#app' }); (Here, vue js will execute and control anything that will be inside the app id. So, for our example  let's put the app id inside the welcome view). So, inside welcome.blade.php 's body...