How to use ZF framework database tracker

Learning assignment Zend_Db uses
//Method to call the tracker
$Profiler = $Db -> getProfiler();

/*
How to use the tracker
*/

//Introduce the Loader class (automatic loading class)
require_once("Zend/Loader.php");
//Use the Loader class Introduce a Db class
Zend_Loader::loadClass("Zend_Db");
//Introduce Zend_Db's stater
Zend_Loader::loadClass("Zend_Db_Statement_Pdo");
//Configure database connection information
$Config = array('host' " true"
 );
//Tell the Zend_Db class to operate the database and database configuration information
$Db = Zend_Db::factory('PDO_Mysql', $Config);
//Execute the encoding statement
$Db -> query( "set names utf8");
//---------------------------------------- -------------
$Sql = "select * from gongsi";
$Db -> query($Sql);
//Method to call the tracker
$Profiler = $Db -> getProfiler();
//Get the number of submitted statements
echo "Number of submissions:" . $Profiler -> getTotalNumQueries() . "";
//Get the number of SQL statements executed Information
$Result = $Profiler -> getQueryProfiles();
foreach ($Result as $key => $value)
{
 //Output the executed statement
 echo "The text content is:" . $value- >getQuery() . "";
 //Output the time it takes to run the statement
 echo "The time spent is:" . $value->getElapsedSecs() . "";
}
//Output the total time spent on all statements
echo "The total time spent is:" . $Profiler -> getTotalElapsedSecs();
?>


Copy code