{"id":18401,"date":"2020-09-07T08:24:57","date_gmt":"2020-09-07T08:24:57","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=18401"},"modified":"2021-10-29T06:39:10","modified_gmt":"2021-10-29T06:39:10","slug":"how-to-merge-two-or-multiple-tables-to-each-other-in-the-laravel-php-framework-part-3","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-3\/","title":{"rendered":"How to merge two or multiple tables to each other in the Laravel PHP Framework? (Part-3)"},"content":{"rendered":"\n<p><a href=\"https:\/\/www.devopsschool.com\/blog\/how-to-merge-two-or-multiple-tables-to-each-other-in-the-laravel-php-framework-part-1\/\">Part-1<\/a> <a href=\"https:\/\/www.devopsschool.com\/blog\/how-to-merge-two-or-multiple-tables-to-each-other-in-the-laravel-php-framework-part-2\/\">Part-2<\/a><\/p>\n\n\n\n<p>Now, we&#8217;ll create the 2nd table State to merge with the Country table. <\/p>\n\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Step 1.<\/span><\/strong> <strong>Create<\/strong>&nbsp;child file&nbsp;<strong>resources\/views\/State<\/strong>&nbsp;folder with name&nbsp;<strong>create.blade.php<\/strong>.<\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/ushakiran27\/b5080f3bbd479deb1f019e0381cdf52e.js\"><\/script>\n\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Step 2.<\/span><\/strong> <strong>Create<\/strong>&nbsp;<strong>edit.blade.php file<\/strong>. In this file within&nbsp;<strong>resources\/views\/State&nbsp;<\/strong>folder.<\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/ushakiran27\/1cf2cbc1e84621c194c567273a3a9c52.js\"><\/script>\n\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Step 3.<\/span><\/strong> <strong>Create<\/strong> an&nbsp;<strong>index.blade.php<\/strong>&nbsp;file within <strong>resource\/views\/State\/<\/strong>&nbsp;folder.<\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/ushakiran27\/a72d8280d34726e9562518a0539887ac.js\"><\/script>\n\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Step 4.<\/span><\/strong> <strong>Go<\/strong> to <strong>app\/State.php<\/strong>. Now, we need to list all the properties we need in the $fillable array.<\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/ushakiran27\/456aa25e8f5e6d610ade84d3bc6edeeb.js\"><\/script>\n\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Step 5.<\/span><\/strong> <strong>Go <\/strong>to <strong>app\/Http\/Controllers\/StateController.php <\/strong>file.<\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/ushakiran27\/3b15eafa5344a7fcb6a3a478819b34c3.js\"><\/script>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-1\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"> -&gt;leftJoin(<span class=\"hljs-string\">'countries'<\/span>, <span class=\"hljs-string\">'states.country_id'<\/span>, <span class=\"hljs-string\">'='<\/span>, <span class=\"hljs-string\">'countries.country_id'<\/span>)<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-1\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-2\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\"> <span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-function\"><span class=\"hljs-keyword\">function<\/span> <span class=\"hljs-title\">index<\/span><span class=\"hljs-params\">()<\/span>\n    <\/span>{\n         $states = State::all()-&gt;toArray();\n         $states = DB::table(<span class=\"hljs-string\">'states'<\/span>)\n         -&gt;leftJoin(<span class=\"hljs-string\">'countries'<\/span>, <span class=\"hljs-string\">'states.country_id'<\/span>, <span class=\"hljs-string\">'='<\/span>, <span class=\"hljs-string\">'countries.country_id'<\/span>)\n         -&gt;orderBy(<span class=\"hljs-string\">'state_id'<\/span>,<span class=\"hljs-string\">'desc'<\/span>)-&gt;paginate(<span class=\"hljs-number\">5<\/span>);\n        <span class=\"hljs-keyword\">return<\/span> view(<span class=\"hljs-string\">'state.index'<\/span>,  &#91;<span class=\"hljs-string\">'states'<\/span> =&gt; $states]);\n\n    }<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-2\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<p><strong><span class=\"has-inline-color has-vivid-red-color\">Step 6.<\/span><\/strong> Then,&nbsp;<strong>go&nbsp;<\/strong>to&nbsp;<strong>routes\/web.php<\/strong>&nbsp;file and&nbsp;<strong>define&nbsp;<\/strong>all these routes.<\/p>\n\n\n<pre class=\"wp-block-code\" aria-describedby=\"shcb-language-3\" data-shcb-language-name=\"PHP\" data-shcb-language-slug=\"php\"><span><code class=\"hljs language-php\">Route::resource(<span class=\"hljs-string\">'state'<\/span>,<span class=\"hljs-string\">'StateController'<\/span>);\nRoute::any(<span class=\"hljs-string\">'\/search1'<\/span>, <span class=\"hljs-string\">'StateController@search'<\/span>);<\/code><\/span><small class=\"shcb-language\" id=\"shcb-language-3\"><span class=\"shcb-language__label\">Code language:<\/span> <span class=\"shcb-language__name\">PHP<\/span> <span class=\"shcb-language__paren\">(<\/span><span class=\"shcb-language__slug\">php<\/span><span class=\"shcb-language__paren\">)<\/span><\/small><\/pre>\n\n\n<h4 class=\"has-text-align-center wp-block-heading\"><span class=\"has-inline-color has-vivid-cyan-blue-color\">Run the URL<\/span><\/h4>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"576\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/09\/image-8-1024x576.png\" alt=\"\" class=\"wp-image-18406\" srcset=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/09\/image-8-1024x576.png 1024w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/09\/image-8-300x169.png 300w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/09\/image-8-768x432.png 768w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/09\/image-8-355x199.png 355w, https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/09\/image-8.png 1366w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n\n\n\n<p>Thanks<\/p>\n\n\n<div class=\"epyt-gallery\" data-currpage=\"1\" id=\"epyt_gallery_19920\"><figure class=\"wp-block-embed wp-block-embed-youtube is-type-video is-provider-youtube epyt-figure\"><div class=\"wp-block-embed__wrapper\"><iframe loading=\"lazy\"  id=\"_ytid_84252\"  width=\"760\" height=\"427\"  data-origwidth=\"760\" data-origheight=\"427\" src=\"https:\/\/www.youtube.com\/embed\/?enablejsapi=1&#038;autoplay=0&#038;cc_load_policy=0&#038;cc_lang_pref=&#038;iv_load_policy=1&#038;loop=0&#038;rel=1&#038;fs=1&#038;playsinline=0&#038;autohide=2&#038;theme=dark&#038;color=red&#038;controls=1&#038;disablekb=0&#038;\" class=\"__youtube_prefs__  no-lazyload\" title=\"YouTube player\"  data-epytgalleryid=\"epyt_gallery_19920\"  allow=\"fullscreen; accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen data-no-lazy=\"1\" data-skipgform_ajax_framebjll=\"\"><\/iframe><\/div><\/figure><div class=\"epyt-gallery-list\"><div>Sorry, there was a YouTube error.<\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Part-1 Part-2 Now, we&#8217;ll create the 2nd table State to merge with the Country table. Step 1. Create&nbsp;child file&nbsp;resources\/views\/State&nbsp;folder with name&nbsp;create.blade.php. Step 2. Create&nbsp;edit.blade.php file. In this file within&nbsp;resources\/views\/State&nbsp;folder. Step 3. Create an&nbsp;index.blade.php&nbsp;file within resource\/views\/State\/&nbsp;folder. Step 4. Go to app\/State.php. Now, we need to list all the properties we need in the $fillable array. Step&#8230;<\/p>\n","protected":false},"author":29,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[1,5201],"tags":[],"class_list":["post-18401","post","type-post","status-publish","format-standard","hentry","category-sql","category-laravel"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/18401","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/29"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=18401"}],"version-history":[{"count":8,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/18401\/revisions"}],"predecessor-version":[{"id":24546,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/18401\/revisions\/24546"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=18401"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=18401"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=18401"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}