{"id":20062,"date":"2020-12-21T07:01:18","date_gmt":"2020-12-21T07:01:18","guid":{"rendered":"http:\/\/www.devopsschool.com\/blog\/?p=20062"},"modified":"2022-04-28T09:15:10","modified_gmt":"2022-04-28T09:15:10","slug":"how-to-display-and-popular-data-from-database-using-left-join-and-oderby","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/how-to-display-and-popular-data-from-database-using-left-join-and-oderby\/","title":{"rendered":"How to Display Recent and  popular data from Database using left join and OderBy"},"content":{"rendered":"\n<p><strong>Fist Step In Welcome.blade.php file<\/strong><\/p>\n\n\n\n<p><strong>for Table <\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/welcome.blade_.php_.png\" alt=\"\" class=\"wp-image-20066\"\/><\/figure>\n\n\n\n<p><strong>Secound Step In Pages.blade.php<\/strong><\/p>\n\n\n\n<script src=\"https:\/\/gist.github.com\/dharmendra150696\/52eb53714a682531fbaa5b4718cebf18.js\"><\/script>\n\n\n\n<p><strong>Third Step In Routing, Go To web.php<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/web.php_.png\" alt=\"\" class=\"wp-image-20069\"\/><\/figure>\n\n\n\n<p><strong>Forth Step In GestController.php<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/GestController.png\" alt=\"\" class=\"wp-image-20070\"\/><\/figure>\n\n\n\n<p>This is Return $gallery View<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/viewpage-1024x428.png\" alt=\"\" class=\"wp-image-20071\"\/><\/figure>\n\n\n\n<p><strong>This is View page <\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/trip-1024x261.png\" alt=\"\" class=\"wp-image-20072\"\/><\/figure>\n\n\n\n<p><strong>Fifth Step in GestController in popular data<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/popular-1.png\" alt=\"\" class=\"wp-image-20074\"\/><\/figure>\n\n\n\n<p><strong>Popular data View<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/popular2-1024x261.png\" alt=\"\" class=\"wp-image-20075\"\/><\/figure>\n\n\n\n<p>This is Welcome page view <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/www.devopsschool.com\/blog\/wp-content\/uploads\/2020\/12\/popular3-1024x265.png\" alt=\"\" class=\"wp-image-20076\"\/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Fist Step In Welcome.blade.php file for Table Secound Step In Pages.blade.php Third Step In Routing, Go To web.php Forth Step In GestController.php This is Return $gallery View This is View&#8230; <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[5201],"tags":[6524,6525,1591,6528,6526,6527],"class_list":["post-20062","post","type-post","status-publish","format-standard","hentry","category-laravel","tag-leftjoin","tag-orderby","tag-select","tag-subscriber","tag-take","tag-where"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/20062","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\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=20062"}],"version-history":[{"count":0,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/20062\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=20062"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=20062"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=20062"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}