PASSWORD RESET

Your destination for complete Tech news

How to get the query builder to output raw SQL query as string in Laravel?

313 0
< 1 min read

To get the raw SQL query as a string in Laravel, you can use the toSql method of the query builder instance. Here is an example of how you can use it:

$users = DB::table('users')
           ->where('username', 'john')
           ->toSql();
echo $users; // Outputs the raw SQL query as a string

The toSql method returns the raw SQL query as a string, which you can then output or use in your application as needed.

You can also use the get method to execute the query and retrieve the results, while still getting the raw SQL query as a string:

$users = DB::table('users')
           ->where('username', 'john')
           ->get();
echo DB::getQueryLog(); // Outputs an array of all the queries run by the connection

The getQueryLog method returns an array of all the queries run by the database connection, with each element containing the raw SQL query as a string. You can then access the raw SQL query for a specific query by accessing the corresponding element in the array.

Leave A Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.