{"id":17948,"date":"2020-09-07T08:28:13","date_gmt":"2020-09-07T08:28:13","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=17948"},"modified":"2021-10-29T06:38:05","modified_gmt":"2021-10-29T06:38:05","slug":"how-to-merge-two-or-multiple-tables-to-each-other-in-the-laravel-php-framework-part-1","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-merge-two-or-multiple-tables-to-each-other-in-the-laravel-php-framework-part-1\/","title":{"rendered":"How to merge two or multiple tables to each other in the Laravel PHP Framework? (Part-1)"},"content":{"rendered":"\n

How to merge two or multiple tables to each other in the Laravel PHP Framework?<\/p>\n\n\n\n

Part-2<\/a> Part-3<\/a><\/p>\n\n\n\n

How to seed Country\/State data into the Database? Click Here<\/a> Here, we are going to merge the Country table to the State table using left join<\/strong><\/p>\n\n\n\n

The LEFT JOIN keyword returns all records from the left table (table1), and the matched records from the right table (table2). The result is NULL from the right side if there is no match.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Step 1.<\/span><\/strong> Create<\/strong> a new Project in Laravel, so open<\/strong> git bash. Write<\/strong> down the following command:-<\/p>\n\n\n

$ composer create-project --prefer-dist laravel\/laravel Join \"5.8.*\"<\/span><\/code><\/span>Code language:<\/span> JavaScript<\/span> (<\/span>javascript<\/span>)<\/span><\/small><\/pre>\n\n\n
Step 2.<\/span><\/strong> Create<\/strong> the authentication scaffolding<\/strong> and Country model. Write<\/strong> down the following command:-<\/p>\n\n\n
$ php artisan make:auth<\/code><\/span><\/pre>\n\n
$ php artisan make:model Country -m<\/code><\/span><\/pre>\n\n\n
Step 3.<\/span><\/strong> Create<\/strong> the State model. Write<\/strong> down the following command:-<\/p>\n\n\n
$ php artisan make:model State -m<\/code><\/span><\/pre>\n\n\n
Step 4. <\/span>Generate<\/strong> a migration file into the database\/migrations<\/strong> folder of <\/strong>the Country<\/strong> table.<\/p>\n\n\n
public<\/span> function<\/span> up<\/span>()<\/span>\n<\/span>{\n        Schema::create('countries'<\/span>, function<\/span> (Blueprint $table)<\/span> <\/span>{\n            $table->bigIncrements('country_id'<\/span>);\n            $table->string('country_name'<\/span>);\n            $table->string('sort'<\/span>);\n            $table->integer('phoneCode'<\/span>); \n            $table->timestamps();\n        });\n    }<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Step 5.<\/span><\/strong> Generate<\/strong> a migration file into the database\/migrations<\/strong> folder of State<\/strong> table.<\/p>\n\n\n
public<\/span> function<\/span> up<\/span>()<\/span>\n<\/span>{\n        Schema::create('states'<\/span>, function<\/span> (Blueprint $table)<\/span> <\/span>{\n            $table->bigIncrements('state_id'<\/span>);\n            $table->string('state_name'<\/span>);\n            $table->integer('country_id'<\/span>);\n            $table->timestamps();\n        });\n    }<\/code><\/span>Code language:<\/span> PHP<\/span> (<\/span>php<\/span>)<\/span><\/small><\/pre>\n\n\n
Step 6.<\/span><\/strong> Migrate<\/strong> these tables into the MySQL database, so write the following command.<\/p>\n\n\n
$ php artisan migrate<\/code><\/span><\/pre>\n\n\n
Step 7.<\/span><\/strong>  Create<\/strong> a CountryController<\/strong> in App\/Http\/Controller<\/strong> folder so, write the following command.<\/p>\n\n\n
$ php artisan make:controller CountryController --resource<\/code><\/span><\/pre>\n\n\n
\"\"<\/figure>\n\n\n\n
Step 8.<\/span><\/strong> Create<\/strong> a StateController<\/strong> in App\/Http\/Controller<\/strong> folder so, write the following command.<\/p>\n\n\n
$ php artisan make:controller StateController --resource<\/code><\/span><\/pre>\n\n\n
\"\"<\/figure>\n\n\n\n
Step 9.<\/span><\/strong>  Create<\/strong> child file resources\/views\/Country<\/strong> folder with name create.blade.php<\/strong>. <\/p>\n\n\n\n