What are the ways to record Laravel SQL statements

This article mainly introduces "what are the methods of recording Laravel SQL statements". In daily operation, I believe that many people have doubts about the methods of recording Laravel SQL statements. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful to answer the questions of "what methods of recording Laravel SQL statements?" Next, please follow the editor to study!

Print the sql statement and output it directly after you execute the SQL statement

Method 1:

$queries = DB::getQueryLog ()

$a = end ($queries)

$tmp = str_replace ('?','.% saw.'', $a ["query"])

Echo vsprintf ($tmp, $a ['bindings'])

Exit

Method 2: pay attention to putting it on the routes.php

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

At this point, the study of "what are the methods of recording Laravel SQL statements" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!