How to Get Last Executed Query in Laravel?

About Us:

We are from free coder. We are a group of web developers who are passionate about web development. You can learn from us php, laravel, node js, vue js, react js and many other topic on web developement.
we are very happy to help you.
free coder

Today what you are going to learn:

We have been many time need to get executed query log or you want to get last executed query or maybe if you want to diaplsy sql query from laravel query builder then you can do it that. so i have three lesson for display executed query in Laravel 5. when you are working on laravel application at that times , i think you need many time to print last run query or if you want to check direct from phpmyadmin sql box, so at that time you have to follow this three lesson. so, let's see three lesson of getting sql query from Laravel Query Builder.

Lesson 1:

In this lesson we can get directly get current sql query using toSql() of laravel query builder. In this lesson you don't need to enable query log or something you can directly query like bellow lesson:

$user = User::where('id',1)->toSql();

print_r($user);

Lesson 2:

Ok, In this lesson we must need to enable query log using DB::enableQueryLog() of Laravel Query builder. enableQueryLog() will give access to store all execute query in cache and we can get that query using DB::getQueryLog(). In this lesson you will get all query log not last only. bellow lesson how to use it together.

DB::enableQueryLog();

$user = User::get();

$query = DB::getQueryLog();

print_r($query);

Lesson 3:

In this lesson i make the same as lesson 2, but you can get exactly last query using end(). so let's see how to use.

DB::enableQueryLog();

$user = User::get();

$query = DB::getQueryLog();

$query = end($query);

print_r($query);

You can try any one....

Recent Posts

Related Posts