Eloquent relationships: one-to-one, one-to-many, many-to-many, and how to fetch and display related data

-

 To create a Laravel project with various relationships (one-to-one, one-to-many, hasManyThrough, belongsTo, and many-to-many), we can create a simple scenario involving `User`, `Profile`, `Post`, `Comment`, and `Role` models.


### Step 1: Create a New Laravel Project


If you haven't already, create a new Laravel project:


```bash

composer create-project --prefer-dist laravel/laravel RelationshipDemo

cd RelationshipDemo

```


### Step 2: Set Up the Models and Migrations


We'll create the following models and migrations:


1. **User**: Has a one-to-one relationship with `Profile`, one-to-many with `Post`, and a many-to-many relationship with `Role`.

2. **Profile**: Belongs to `User`.

3. **Post**: Belongs to `User` and has many `Comment`s.

4. **Comment**: Belongs to `Post`.

5. **Role**: Belongs to many `User`s.


Run the following commands to create the models and migrations:


```bash

php artisan make:model User -m

php artisan make:model Profile -m

php artisan make:model Post -m

php artisan make:model Comment -m

php artisan make:model Role -m

php artisan make:migration create_role_user_table --create=role_user

```


### Step 3: Define the Relationships in Models and Migrations


#### User Model


```php

// app/Models/User.php

namespace App\Models;


use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Foundation\Auth\User as Authenticatable;


class User extends Authenticatable

{

    use HasFactory;


    public function profile()

    {

        return $this->hasOne(Profile::class);

    }


    public function posts()

    {

        return $this->hasMany(Post::class);

    }


    public function roles()

    {

        return $this->belongsToMany(Role::class);

    }

}

```


#### Profile Model


```php

// app/Models/Profile.php

namespace App\Models;


use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;


class Profile extends Model

{

    use HasFactory;


    public function user()

    {

        return $this->belongsTo(User::class);

    }

}

```


#### Post Model


```php

// app/Models/Post.php

namespace App\Models;


use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;


class Post extends Model

{

    use HasFactory;


    public function user()

    {

        return $this->belongsTo(User::class);

    }


    public function comments()

    {

        return $this->hasMany(Comment::class);

    }

}

```


#### Comment Model


```php

// app/Models/Comment.php

namespace App\Models;


use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;


class Comment extends Model

{

    use HasFactory;


    public function post()

    {

        return $this->belongsTo(Post::class);

    }

}

```


#### Role Model


```php

// app/Models/Role.php

namespace App\Models;


use Illuminate\Database\Eloquent\Factories\HasFactory;

use Illuminate\Database\Eloquent\Model;


class Role extends Model

{

    use HasFactory;


    public function users()

    {

        return $this->belongsToMany(User::class);

    }

}

```


#### Migrations


Edit the migration files to define the schema for the tables.


##### Users Migration


```php

// database/migrations/xxxx_xx_xx_create_users_table.php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;


class CreateUsersTable extends Migration

{

    public function up()

    {

        Schema::create('users', function (Blueprint $table) {

            $table->id();

            $table->string('name');

            $table->string('email')->unique();

            $table->string('password');

            $table->timestamps();

        });

    }


    public function down()

    {

        Schema::dropIfExists('users');

    }

}

```


##### Profiles Migration


```php

// database/migrations/xxxx_xx_xx_create_profiles_table.php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;


class CreateProfilesTable extends Migration

{

    public function up()

    {

        Schema::create('profiles', function (Blueprint $table) {

            $table->id();

            $table->foreignId('user_id')->constrained()->onDelete('cascade');

            $table->string('bio')->nullable();

            $table->string('address')->nullable();

            $table->timestamps();

        });

    }


    public function down()

    {

        Schema::dropIfExists('profiles');

    }

}

```


##### Posts Migration


```php

// database/migrations/xxxx_xx_xx_create_posts_table.php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;


class CreatePostsTable extends Migration

{

    public function up()

    {

        Schema::create('posts', function (Blueprint $table) {

            $table->id();

            $table->foreignId('user_id')->constrained()->onDelete('cascade');

            $table->string('title');

            $table->text('content');

            $table->timestamps();

        });

    }


    public function down()

    {

        Schema::dropIfExists('posts');

    }

}

```


##### Comments Migration


```php

// database/migrations/xxxx_xx_xx_create_comments_table.php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;


class CreateCommentsTable extends Migration

{

    public function up()

    {

        Schema::create('comments', function (Blueprint $table) {

            $table->id();

            $table->foreignId('post_id')->constrained()->onDelete('cascade');

            $table->text('body');

            $table->timestamps();

        });

    }


    public function down()

    {

        Schema::dropIfExists('comments');

    }

}

```


##### Roles Migration


```php

// database/migrations/xxxx_xx_xx_create_roles_table.php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;


class CreateRolesTable extends Migration

{

    public function up()

    {

        Schema::create('roles', function (Blueprint $table) {

            $table->id();

            $table->string('name');

            $table->timestamps();

        });

    }


    public function down()

    {

        Schema::dropIfExists('roles');

    }

}

```


##### Role_User Pivot Table Migration


```php

// database/migrations/xxxx_xx_xx_create_role_user_table.php

use Illuminate\Database\Migrations\Migration;

use Illuminate\Database\Schema\Blueprint;

use Illuminate\Support\Facades\Schema;


class CreateRoleUserTable extends Migration

{

    public function up()

    {

        Schema::create('role_user', function (Blueprint $table) {

            $table->id();

            $table->foreignId('role_id')->constrained()->onDelete('cascade');

            $table->foreignId('user_id')->constrained()->onDelete('cascade');

            $table->timestamps();

        });

    }


    public function down()

    {

        Schema::dropIfExists('role_user');

    }

}

```


### Step 4: Run the Migrations


Run the migrations to create the tables in the database:


```bash

php artisan migrate

```


### Step 5: Seed the Database with Dummy Data (Optional)


You can use Laravel's seeding feature to populate the database with dummy data for testing:


```bash

php artisan make:seeder DatabaseSeeder

```


Edit the `DatabaseSeeder.php` file:


```php

// database/seeders/DatabaseSeeder.php

use Illuminate\Database\Seeder;

use App\Models\User;

use App\Models\Profile;

use App\Models\Post;

use App\Models\Comment;

use App\Models\Role;


class DatabaseSeeder extends Seeder

{

    public function run()

    {

        // Create some roles

        $adminRole = Role::create(['name' => 'Admin']);

        $editorRole = Role::create(['name' => 'Editor']);

        

        // Create a user and assign roles

        $user = User::factory()->create(['name' => 'John Doe']);

        $user->roles()->attach([$adminRole->id, $editorRole->id]);


        // Create a profile for the user

        Profile::create([

            'user_id' => $user->id,

            'bio' => 'This is John Doe\'s profile.',

            'address' => '123 Main St.',

        ]);


        // Create posts and comments

        $posts = Post::factory()->count(3)->create(['user_id' => $user->id]);

        foreach ($posts as $post) {

            Comment::factory()->count(2)->create(['post_id' => $post->id]);

        }

    }

}

```


Run the seeder:


```bash

php artisan db:seed

```


### Step 6: Display the Relationships in a Controller


Create a controller to display data from the relationships:


```bash

php artisan make:controller TestController

```


In the `TestController.php` file, add the following methods to display related data:


```php

// app/Http/Controllers/TestController.php

namespace App\Http\Controllers;


use App\Models\User;

use Illuminate\Http\Request;


class TestController extends Controller

{

    public function showUserProfile($userId)

    {

        $user = User::with('profile')->findOrFail($userId);

        return view('user.profile', compact('user'));

    }


    public function showUserPosts($userId)

    {

        $user = User::with('posts')->findOrFail($userId);

        return view('user.posts', compact


('user'));

    }


    public function showPostComments($postId)

    {

        $post = Post::with('comments')->findOrFail($postId);

        return view('post.comments', compact('post'));

    }


    public function showUserRoles($userId)

    {

        $user = User::with('roles')->findOrFail($userId);

        return view('user.roles', compact('user'));

    }

}

```


### Step 7: Create Views to Display the Data


For example, to show the user's profile:


```blade

<!-- resources/views/user/profile.blade.php -->

<h1>{{ $user->name }}'s Profile</h1>

<p>Bio: {{ $user->profile->bio }}</p>

<p>Address: {{ $user->profile->address }}</p>

```


And for the posts:


```blade

<!-- resources/views/user/posts.blade.php -->

<h1>{{ $user->name }}'s Posts</h1>

@foreach($user->posts as $post)

    <h2>{{ $post->title }}</h2>

    <p>{{ $post->content }}</p>

@endforeach

```


### Step 8: Define Routes for Testing


Add routes in `web.php` to access these methods:


```php

// routes/web.php

use App\Http\Controllers\TestController;


Route::get('/user/{id}/profile', [TestController::class, 'showUserProfile']);

Route::get('/user/{id}/posts', [TestController::class, 'showUserPosts']);

Route::get('/post/{id}/comments', [TestController::class, 'showPostComments']);

Route::get('/user/{id}/roles', [TestController::class, 'showUserRoles']);

```


### Step 9: Test the Application


Visit the routes like `/user/1/profile`, `/user/1/posts`, etc., in your browser to see the relationships in action.


### Summary


This project demonstrates a basic Laravel application with various Eloquent relationships: one-to-one, one-to-many, many-to-many, and how to fetch and display related data. You can extend this further by adding more complex logic or relationships depending on your application's needs.

Comments

Post a Comment

Please do not enter any spam link in the comment box.

Popular posts from this blog

IMPORTANT INTERVIEW RELATED QUESTION

-
 IMPORTANT INTERVIEW RELATED QUESTION > DATABASE -> CASANDRA, MONGODB SHORT NOTES > DATABASE STRUCTURE & UNSTRUCTURED WORK SHORT NOTES > APPLICATION LEVEL OF OPERATING SYSTEM > ROUTER CONFIGURATION PROCESS > IPV4 AND IPV6 USE INSTEAD, CONFIGURATION PROCESS > NETWORK STORAGE WITH DATABASE STORAGE WORK > OBJECT ORIENTED PROGRAMMING CONCEPTS > PROJECT PLANNING IDEA > DEFINE DAY TO DAY WISE PLANNING > ISDN IN NETWORK > MBPS AND BANDWIDTH WORKING CONCEPT > HOW UPDATATION INVOLVES WITH POPULARITY  > GATEWAY TECHNIQUE WITH BASIC EXAMPLE  > FIREWALL TECHNIQUE WITH BASIC EXAMPLE  > WHAT IS LOCALITY OF REFERENCE    HTML CSS 1> WHAT IS INLINE ELEMENT AND BLOCK ELEMENT ? 2> DOES INLINE ELEMENT CONTAIN BLOCK ELEMENT ? 3> DOES BLOCK ELEMENT CONTAIN INLINE ELEMENT ? 4> WHAT IS THE EXCEPTION IN INLINE ELEMENT THAT CONTAIN BLOCK ELEMENT ? <A> 5>  
Read more

Survey Paper

-
 Websites:   scholar.google, microsoft academic, scienceDirect, Publmed, ieee, refseek, web of science  Smartphone based human activity monitoring and recognition using ML and DL: a comprehensive survey => my goal to make this,,, 1st.2nd.3rd.etc Gen, Desc, pic, how communication done, pros and cons, diagram of users, top algorithms used to improvements, most useful sensors and benefit of it, top inventors, diagram of users, Machine learning and Data analysis how much improves , ... future plans in improvement from Google and big companies, conclusion , references from acticles and google search. Abstract POINTS * Human activity monitoring and recognition (HAMR) based on smartphone sensor data is a feld that promotes a lot of obsevation in current era due to its notable desire in various Ambient Intelligent applications such as healthcare, sports, surveillance, and remote health monitoring. *  In this context, many research works have unveiled incredible results using various smartph
Read more

C++ Interview Questions

-
Image
          C++ Interview Questions 2 1) What is C++? 2 2) What are the advantages of C++? 2 3) What is the difference between C and C++? 3 4) What is the difference between reference and pointer? 4 5) What is a class? 5 6) What are the various OOPs concepts in C++? 5 Note: The visibility-mode can be public, private, protected. 7 7) What are the different types of polymorphism in C++? 8 8) Define namespace in C++. 12 9) Define token in C++. 14 10) Who was the creator of C++? 14 11) Which operations are permitted on pointers? 14 12) Define 'std'. 16 13) Which programming language's unsatisfactory performance led to the discovery of C++? 16 14) How delete [] is different from delete? 16 15) What is the full form of STL in C++? 16 16) What is an object? 16 17) What are the C++ access specifiers? 17 18) What is Object Oriented Programming (OOP)? 17 19) What is the difference between an array and a list? 18 20) What is the difference betwe
Read more

Git Cheat Sheet: A Beginner to Intermediate Guide

-
Certainly! Below is a refined and comprehensive guide to Git, tailored for beginners and intermediate users. This guide includes the Git basics, common commands, and additional commands like renaming branches. This should serve as a helpful reference for anyone looking to understand or refresh their knowledge of Git.  Git Cheat Sheet: A Beginner to Intermediate Guide  What is Git? Git is a distributed version control system that allows you to track changes in your codebase, collaborate with others, and manage different versions of your project. Git helps developers work on projects collaboratively, maintain different versions of their work, and track changes over time.  Basic Git Lifecycle  1. Initialize a Git Repository - Command:   git init - Purpose: Initializes a new Git repository in the current directory, turning the directory into a repository that Git can manage. 2. Clone a Repository - Command:   git clone <repository_url> - Purpose: Creates a local copy of a remote repo
Read more

Java Interview Questions

-
  Java Interview Questions 1. What are the differences between C++ and Java? C++ is not platform-independent; the principle behind C++ programming is “write once, compile anywhere.” In contrast, because the byte code generated by the Java compiler is platform-independent, it can run on any machine, Java programs are written once and run everywhere. ·         Languages Compatibility. C++ is a programming language that is based on the C programming language . Most other high-level languages are compatible with C++. Most of the languages of Java are incompatible. Java is comparable to those of C and C++. ·         Interaction with the library. It can access the native system libraries directly in C++. As a result, it’s better for programming at the system level. Java’s native libraries do not provide direct call support. You can use Java Native Interface or access the libraries. ·         Characteristics. C++ distinguishes itself by having features that are similar to procedural and objec
Read more

INTERVIEW QUS ON AUTOMATA

-
                                .  INTERVIEW QUS ON AUTOMATA 1 There are ________ tuples in the finite state machine.   a)4 b)5   c)6 d)Unlimited 2 Transition function maps.   a)Σ * Q → Σ b)Q * Q→Σ   c)Σ * Σ → Q d)Q * Σ → Q 3 Number of states required to accept string ends with 10.   a)3 b)2   c)1 d)Can’t be determined 4 δ*(q,ya) is equivalent to .   a)δ((q,y),a) b)δ(δ*(q,y),a)   c)δ(q,ya) d)independent from δ notation 5 An automaton that presents output based on previous state or current input is called   a)Acceptor b)Classifier   c)Transducer d)None of the mentioned 6 If NFA of 6 states excluding the initial state is converted into DFA, the maximum possible number of states for the DFA is   a)62 b)32   c)128 d)127 7 NFA, in its name has ’non-deterministic’ because of :   a)The result is undetermined b)The choice of path is non-deterministic   c)The state to be transited next is non-deterministic d)All of the mentioned 8 Which of the following is the correct proposition? State
Read more

OPERATION RESEARCH SYLLABUS

-
Image
  OPERATION RESEARCH SYLLABUS Unit I : Introduction [4L]  Basic LPP and Applications, Various Components of LP Problem Formulation, Basic Solution, Basic Feasible Solution, Optimum Solution.   Unit II : Solution of Linear Programming Problems [12L]  Solution of LPP using Simultaneous Equations and Graphical Method, by Simplex Method, Charnes’ Big-M Method, Duality Theory.   Unit III : Transportation Problems [12L]  Matrix minima method, North-West corner rule, Vogel Approximation Method.   Unit IV : Assignment Problems and Traveling salesman problem [6L]  Hungarian Method For Solving Assignment Problem, Traveling salesman problem.   Unit V : Network Analysis [6L]  Shortest Path: Floyd Algorithm, Maximal Flow Problem (Ford-Fulkerson), PERT-CPM .   Suggested books: 1. Ghosh and Chakraborty, “Linear Programming and Theory of Games”, Central Book Agency 2. Operation Research,Paneer Selvam,PHI 3.Operations Research, Hillier & Lieberman, TMH 4. J. K. Sharma: Operation Research Th
Read more

CPU CACHE MEMORY

-
Image
 CPU CACHE MEMORY: WHAT IS CPU CACHE? => Now a computer has two different types of memory.  One type is what is used in RAM modules, which is DRAM or a dynamic RAM and DRAM is memory that uses capacitors to store data and these capacitors have to constantly and dynamically be refreshed often with electricity in order for them to store data.  But there's another type of memory that a computer uses that doesn't have to be constantly refreshed. And this memory is called SRAM or a static RAM and SRAM is what is used in the CPU catch and because SRAM doesn't have to be constantly refreshed, it is a lot faster than DRAM and it's also very expensive.  CPU CACHE DRAM AND SRAM  The CPU cache is the CPU's internal memory. And its job is to store copies of data and instructions from RAM that's waiting to be used by the CPU. So basically what the CPU cache does, is that it holds common data that it thinks the CPU is going to access over and over again because when the CP
Read more

MAKING POWERPOINT SLIDES

-
Making PowerPoint Slides Avoiding the Pitfalls of Bad Slides   Tips to be Covered    Outlines  Slide Structure  Fonts  Color  Background  Graphs  Spelling and Grammar  Conclusions  Questions   Outline    Make your 1 st or 2 nd slide an outline of your presentation – Ex: previous slide  Follow the order of your outline for the rest of the presentation  Only place main points on the outline slide – Ex: Use the titles of each slide as main points     Slide Structure – Good    Use 1-2 slides per minute of your presentation  Write in point form, not complete sentences  Include 4-5 points per slide  Avoid wordiness: use key words and phrases only     Slide Structure - Bad   This page contains too many words for a presentation slide. It is not written in point form, making it difficult both for your audience to read and for you to present each point. Although there are exactly the same number of points on this slide as the previous slide, it looks much more complic
Read more