Zf framework Database Tracker example _ PHP Tutorial

Examples of using the zf framework Database Tracker. Copy the code by calling the tracker method: $ Profiler $ Db-getProfiler (); copy the code as follows :? Php * How to use the tracker * introduces the Loader class (automatic loading class calls the tracker method)

The code is as follows:

$ Profiler = $ Db-> getProfiler ();

The code is as follows:

/*
How to use a tracker
*/

// Introduce the Loader class (automatic loading class)
Require_once ("Zend/Loader. php ");
// Use the Loader class to introduce a Db Class
Zend_Loader: loadClass ("Zend_Db ");
// Introduce the Zend_Db status server
Zend_Loader: loadClass ("Zend_Db_Statement_Pdo ");
// Configure database connection information
$ Config = array ('host' => '2017. 0.0.1 ',
'Username' => 'root ',
'Password' => '123 ',
'Dbname' => 'test ',
'Filer' => "true"
);
// Inform Zend_Db of the database and database configuration information operated by the class
$ Db = Zend_Db: factory ('pdo _ mysql', $ Config );
// Execute the encoding statement
$ Db-> query ("set names utf8 ");
//-----------------------------------------------------
$ SQL = "select * from gongsi ";
$ Db-> query ($ SQL );
// Call the tracker method
$ Profiler = $ Db-> getProfiler ();
// Obtain the number of submitted statements
Echo "number of submissions:". $ Profiler-> getTotalNumQueries ()."
";
// Obtain SQL statement execution information
$ Result = $ Profiler-> getQueryProfiles ();
Foreach ($ Result as $ key => $ value)
{
// Output the statement that has been run
Echo "text content:". $ value-> getQuery ()."
";
// Time taken to output the running statement
Echo "time spent:". $ value-> getElapsedSecs ()."
";
}
// Total time spent on output all statements
Echo "the total time spent is:". $ Profiler-> getTotalElapsedSecs ();
?>

The pipeline code is as follows: $ Profiler = $ Db-getProfiler (); the code is as follows :? Php/* How to use the tracker * // introduce the Loader class (automatic loading class...