laravel Eloquent ORM - How to get compiled query?

Question

In Laravel 4.2 I want to get Compiled Query.

This is what i have:

$product = Product::where('id', '=', '100')->get();

I want compiled query like:

select * from products where id = 100

Purpose of the question is: i want to use it as sub query in another query.

I have searched and found Class Grammer and Class MySQL But i did not found solution for that.

Is there any solution?

Your help would be appreciated.

This is how you do it http://stackoverflow.com/a/24838367/784588 — Jarek Tkaczyk, Dec 10 '14 at 14:23

score 4 · Answer 1 · answered Dec 10 '14 at 05:49

4

The easiest way is probably mostly finding out what query was just executed, rather than what the query will be. Something like this:

function latestQuery()
{
    $queries = DB::getQueryLog();
    return end($queries);
}

Hopefully that's the same for your purposes.

answered Dec 10 '14 at 05:49

Joel Hinz

24,719
6
62
75

my purpose is something different. i want to use it as 'subquery' in another query. – akash varlani Dec 10 '14 at 05:56
You really have to explain better what you're after because this is the closest you're gonna get to the actual query. – Martijn Dec 11 '14 at 07:09

score 3 · Answer 2 · answered Jun 15 '17 at 05:03

3

You can get the SQL query like this:

use DB;//write this at the top of the file above your Class 

DB::enableQueryLog();//Enable query logging
$product = Product::where('id', '=', '100')->get();
dd(DB::getQueryLog());//print the SQl query

answered Jun 15 '17 at 05:03

Rahul Gupta

9,775
7
56
69

score 1 · Answer 3 · answered Dec 10 '14 at 06:02

1

You can register an event listener in your routes file(in development phase), which will listen for the laravel query event and var_dump the executed query.

Event::listen('illuminate.query', function($sql)
{
    var_dump($sql);
});

But this will turn out to be messy. So better use something like Clockwork. It is awesome, you can view all the executed query in your browser.

answered Dec 10 '14 at 06:02

Shhetri

152
7

my purpose is something different. i want to use it as 'subquery' in another query. – akash varlani Dec 10 '14 at 06:06
What exactly are you intending to do? Be more specific. – Shhetri Dec 10 '14 at 06:09

score -3 · Accepted Answer · answered Dec 10 '14 at 06:34

You can use grammer for subqueries, See below example for reference :

$users = DB::table('users')
             ->where('user.id', '=', $userID)
             ->join('product', 'product.userid',  '=', 'user.id');

$price = $users->select(array(DB::raw('SUM(price)')))
               ->grammar
               ->select($users); // Compiles the statement

$result = DB::table('users')->select(array(DB::raw("({$price}) as price)))->get();

This add a subquery to your main query.

laravel Eloquent ORM - How to get compiled query?

4 Answers4