{"id":7901,"date":"2023-05-31T05:55:48","date_gmt":"2023-05-31T05:55:48","guid":{"rendered":"https:\/\/www.bacancytechnology.com\/qanda\/?p=7901"},"modified":"2023-08-07T05:24:49","modified_gmt":"2023-08-07T05:24:49","slug":"many-to-many-migration-in-laravel","status":"publish","type":"post","link":"https:\/\/www.bacancytechnology.com\/qanda\/laravel\/many-to-many-migration-in-laravel","title":{"rendered":"Many to Many Relationships"},"content":{"rendered":"

Many to many relationships will occur when we’ve 2 tables which are interconnected with each other with multiple records.<\/p>\n

Definition:<\/strong> Many-to-many (M:M) – is used to relate many records in the table A with many records in the table B. A record (‘parent’) in Table A can have many matching records (‘children’) in Table B, and a record (‘child’) in Table B can have many matching records (‘parents’) in Table A.<\/p>\n

So, now we’ll be understanding about how to create a Many to Many Relationship in Laravel with migration through foreign key references and sync data with pivot table and CRUD operation for students, subjects related to Many to Many Relationship.<\/p>\n

Steps are as follows:<\/h3>\n
    \n
  1. \n
      \n
    1. \n
        \n
      1. At the very first install fresh Laravel and create a database and make environment configurations.
        \nTerminal Command:<\/strong> composer create-project laravel\/laravel test-app<\/li>\n
      2. Create 2 Models with migration through below commands:
        \nTerminal Command: php artisan make:model Student -m<\/p>\n
        \/**\r\n * Run the migrations.\r\n *\r\n * @return void\r\n *\/\r\npublic function up()\r\n{\r\n    Schema::create('student', function (Blueprint $table){\r\n        $table->id();\r\n\r\n        $table->string('f_name')->nullable();\r\n        $table->string('l_name')->nullable();\r\n        $table->string('address')->nullable();\r\n\r\n        $table->timestamps();\r\n    });\r\n}\r\n\r\n\/**\r\n * Reverse the migrations.\r\n *\r\n * @return void\r\n *\/\r\npublic function down()\r\n{\r\n    Schema::dropIfExists('student');\r\n}<\/pre>\n
        Terminal Command:<\/strong> php artisan make:model Subject -m<\/p>\n
        \/**\r\n * Run the migrations.\r\n *\r\n * @return void\r\n *\/\r\npublic function up()\r\n{\r\n    Schema::create('subject', function (Blueprint $table){\r\n        $table->id();\r\n\r\n        $table->string('name')->nullable();\r\n\r\n        $table->timestamps();\r\n    });\r\n}\r\n\r\n\/**\r\n * Reverse the migrations.\r\n *\r\n * @return void\r\n *\/\r\npublic function down()\r\n{\r\n    Schema::dropIfExists('subject');\r\n}<\/pre>\n<\/li>\n
      3. Create a new pivot table:<\/strong>
        \nWe need to connect subjects, students both tables and which connected through a pivot table. With below terminal command pivot table migration will be created.
        \nTerminal Command:<\/strong> php artisan make:migration createStudentSubjectPivotTable<\/p>\n
        \/**\r\n * Run the migrations.\r\n *\r\n * @return void\r\n *\/\r\npublic function up()\r\n{\r\n    Schema::create('student_subject', function (Blueprint $table){\r\n        $table->id();\r\n\r\n        $table->foreignId('student_id')->nullable()->constrained('student')->onUpdate('SET NULL')->onDelete('CASCADE');\r\n        $table->foreignId('subject_id')->nullable()->constrained('subject')->onUpdate('SET NULL')->onDelete('CASCADE');\r\n        $table->string('grade')->nullable();\r\n\r\n        $table->timestamps();\r\n    });\r\n}\r\n\r\n\/**\r\n * Reverse the migrations.\r\n *\r\n * @return void\r\n *\/\r\npublic function down()\r\n{\r\n    Schema::dropIfExists('student_subject');\r\n}<\/pre>\n<\/li>\n
      4. Now, both models are defined through foreign references which is as follows:
        \nStudent model<\/strong> will be like this:<\/p>\n
        <?php\r\n\r\nnamespace App\\Models;\r\n\r\nuse Illuminate\\Database\\Eloquent\\Factories\\HasFactory;\r\nuse Illuminate\\Database\\Eloquent\\Model;\r\n\r\nclass Student extends Model\r\n{\r\n    use HasFactory;\r\n\r\n    protected $table = \"student\";\r\n\r\n    public function subject(){\r\n        return $this->belongsToMany(Subject::class, 'student_subject');\r\n    }\r\n}<\/pre>\n
        Subject model<\/strong> will be like this:<\/p>\n
        <?php\r\n\r\nnamespace App\\Models;\r\n\r\nuse Illuminate\\Database\\Eloquent\\Factories\\HasFactory;\r\nuse Illuminate\\Database\\Eloquent\\Model;\r\n\r\nclass Subject extends Model\r\n{\r\n    use HasFactory;\r\n\r\n    protected $table = \"subject\";\r\n\r\n    public function student(){\r\n        return $this->belongsToMany(Student::class, 'student_subject');\r\n    }\r\n}<\/pre>\n<\/li>\n
      5. Once we\u2019ve defined the relationship, we can run the migrate to create tables in our database through below command:
        \nTerminal Command:<\/strong> php artisan migrate<\/li>\n
      6. Create\/Update Records:
        \nNext, we need to use helper methods attach(), detach(), sync()<\/strong> which helps us to assign Many to many Relationships. For now temporary purpose I\u2019ve taken fake data for storing records, you can take your own or get it from the form submit also.
        \nattach() function<\/strong><\/p>\n
        pubilc function store (){\r\n    Subject::create([\r\n        ['name' => 'English'],\r\n        ['name' => 'Mathematics'],\r\n        ['name' => 'Science'],\r\n    ]);\r\n\r\n    $student_item = Student::create([\r\n        'f_name' => fake()->firstName(),\r\n        'l_name' => fake()->lastName(),\r\n        'address' => fake()->address(),\r\n    ]);\r\n    $student_item->subject()->attach([1, 2, 3]);\r\n}<\/pre>\n
        sync() function<\/strong><\/p>\n
        pubilc function update (){\r\n    Subject::create([\r\n        ['name' => 'Drawing'],\r\n        ['name' => 'Social Science'],\r\n    ]);\r\n\r\n    $student_item = Student::find(1);\r\n    $student_item->subject()->sync([4, 5]);\r\n}<\/pre>\n
        detach() function<\/strong><\/p>\n
        Code:\r\n\r\npubilc function destroy (){\r\n    $student_item = Student::find(1);\r\n    $student_item->subject()->detach();\r\n    $student_item->delete();\r\n}<\/pre>\n<\/li>\n
      7. Retrieve Records:\n
        pubilc function index (){\r\n    $student_list = Student::with('subject')->get();\r\n    return view ('student', compact('student_list'));\r\n}<\/pre>\n
        Same way we can define a single students and assign multiple subjects to that particular student. This\u2019ll be a vice-versa process.\n<\/ol>\n<\/li>\n<\/ol>\n<\/li>\n<\/ol>\n
        So, this way we can define Many to Many Relationships in Laravel through migration and foreign references.<\/p>\n
        The same way we can create a common media table which will store only media file names and ‘id’ of the other tables (users, posts, products, etc.). This will be polymorphic many to many relationships and through 2 tables only.<\/p>\n","protected":false},"excerpt":{"rendered":"
        Many to many relationships will occur when we’ve 2 tables which are interconnected with each other with multiple records. Definition: Many-to-many (M:M) – is used to relate many records in the table A with many records in the table B. A record (‘parent’) in Table A can have many matching records (‘children’) in Table B, […]<\/p>\n","protected":false},"author":1,"featured_media":8483,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false,"footnotes":""},"categories":[10],"tags":[],"class_list":["post-7901","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-laravel"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.bacancytechnology.com\/qanda\/wp-json\/wp\/v2\/posts\/7901"}],"collection":[{"href":"https:\/\/www.bacancytechnology.com\/qanda\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bacancytechnology.com\/qanda\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bacancytechnology.com\/qanda\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bacancytechnology.com\/qanda\/wp-json\/wp\/v2\/comments?post=7901"}],"version-history":[{"count":13,"href":"https:\/\/www.bacancytechnology.com\/qanda\/wp-json\/wp\/v2\/posts\/7901\/revisions"}],"predecessor-version":[{"id":8482,"href":"https:\/\/www.bacancytechnology.com\/qanda\/wp-json\/wp\/v2\/posts\/7901\/revisions\/8482"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.bacancytechnology.com\/qanda\/wp-json\/wp\/v2\/media\/8483"}],"wp:attachment":[{"href":"https:\/\/www.bacancytechnology.com\/qanda\/wp-json\/wp\/v2\/media?parent=7901"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bacancytechnology.com\/qanda\/wp-json\/wp\/v2\/categories?post=7901"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bacancytechnology.com\/qanda\/wp-json\/wp\/v2\/tags?post=7901"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}