How to print sql statement in cakephp_PHP tutorial

How to print sql statements in cakephp

This article mainly introduces the method of printing sql statements in cakephp, which can realize the function of printing all previous SQL statements and has certain reference value. , friends in need can refer to it

The example in this article describes how cakephp prints sql statements. Share it with everyone for your reference. The specific implementation method is as follows:

Copy the following statement into your code, you can print out all the sql statements before this:

?

1 2 3 4 5 6 7 8 9 10 11

$sources = ConnectionManager::sourceList(); if (!isset($logs)): $logs = array(); foreach ($sources as $source): $db =& ConnectionManager::getDataSource($source); if (!$db->isInterfaceSupported('getLog')): continue; endif; $logs[$source] = $db->getLog(); endforeach; endif;

1 2

3

4 5

6 7 8 9 10 11

$sources = ConnectionManager::sourceList(); if (!isset($logs)):

$logs = array(); foreach ($sources as $source): $db =& ConnectionManager::getDataSource($source); if (!$db->isInterfaceSupported('getLog')): continue; endif; $logs[$source] = $db->getLog(); endforeach; endif;

I hope this article will be helpful to everyone’s PHP programming based on the cakePHP framework. http://www.bkjia.com/PHPjc/958130.htmlwww.bkjia.comtruehttp: //www.bkjia.com/PHPjc/958130.htmlTechArticleHow to print sql statements in cakephp. This article mainly introduces the method of printing sql statements in cakephp, which can be realized before printing output. The functions of all SQL statements have certain reference value, and the required...