How to add another table after joining multiple tables in Laravel?

I'm trying to achieve the following MySQL query with Laravel

SELECT a.*, b.*, c.* FROM table_1 a LEFT JOIN table_2 b ON a.b_id = b.id, table_3 c WHERE c.age > 21;

I know how to join tables in Laravel. But if you see my SQL query carefully you can find that there is another table just after the left join (without any join). This is where I'm stuck.

I tried the following code in Laravel, but didn't work.

DB::table(DB::raw('table_1 a, table_3 c'))
  ->select('a.*', 'b.*', 'c.*')
  ->leftJoin('table_2 b', 'a.b_id', '=', 'b.id')
  ->where('c.age', '>', 21)
  ->get();

Please help me out with the proper solution. Thanks in advance.

Note: Please ignore syntax error if any



from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3C1xLIo
via IFTTT

تعليقات

إرسال تعليق

المشاركات الشائعة من هذه المدونة

BlueHost Web Hosting Review: Secrets Revealed for Shared Hosting

صورة
BlueHost is one of the biggest web-hosting company providing quality web hosting solutions over two decades from business enterprises to individuals since 1996. Over the years the company secured a place in the list of top twenty web hosting companies in the world and operates with its headquarters being situated in Provo, Utah, USA - along with 700 plus employees. Currently Bluehost and its sister concerns said to host nearly two-million domains and is a major achievement for any web hosting providers. Though it is regarded as the largest shared hosting service provider, ‘Is Bluehost a right choice for websites developed on PHP based platforms?’ To understand it better, here we have altogether reviewed Bluehost Web-Hosting Services from several perspective including performance, pricing, platform compatibility, uptime, security, after support and more. Get Bluehost Hosting for just $3.95 per month with Free Domain 1. Hosting Features BlueHost’s Blazing Fast Servers with Speed
قراءة المزيد

How to Create Treeview with Bootstrap and jQuery

صورة
Hi! Today let's see about creating treeview using bootstrap and jquery . A Treeview is a tree like representation of elements in a hierarchical structure. It offers a quick and easy navigation through websites. Although there are several jquery plugins available for tree view that simplify the task, I wanted something that works well with bootstrap. And I found out a good library called 'Bootstrap Treeview' . It leverages the best of bootstrap framework and helps you display hierarchical tree structures using the JSON data set. You can do much more than a simple tree, like fetch data from the database and render a dynamic tree, make it collapsible, add icons , checkboxes and filters etc. Building Treeview with Bootstrap: Now let's see how to add treeview in bootstrap. To build the menu, we need three different libraries, Bootstrap CSS jQuery Bootstrap Treeview These libraries are available in the cdn, so you can load them directly on your projects without down
قراءة المزيد

Submit Form using jQuery AJAX and PHP without Page Refresh

صورة
Hi! In this tutorial we will see how to submit form using jquery ajax and php without page refresh . Web Development enhanced with AJAX increases speed and performance thereby improving the overall user experience. It allows you to update part of a web page without refreshing it completely. Basically, when you submit an html form, the entire page will be refreshed. But by using ajax technique, you can submit the form to the web server without having to reload the page. Instead, the form data will be submitted to the server in the background and can be processed in any way you want. How to Submit Form using jQuery AJAX and PHP? The jQuery library provides ajax() method which allows you to submit form without refreshing page . It will send an HTTP request to the web server (here is the php script), which is then processed by the server and sends an http response. Let's see how to do it. Step 1) Create a Basic HTML Form First let's create a simple html form containin
قراءة المزيد