PHP Classes

File: example.php

Recommend this page to a friend!
  Classes of Mike Jordan   PHP Script Profiler   example.php   Download  
File: example.php
Role: Example script
Content type: text/plain
Description: Example script
Class: PHP Script Profiler
Profile the execution of PHP scripts
Author: By
Last change:
Date: 9 years ago
Size: 2,690 bytes
 

Contents

Class file image Download
<?php

require_once 'PHP Profiler/profiler.php';
$profile = new profiler;

$point_1 = $profile->start_profile( 'Script Includes' );

include
'objSQL_3.5.2/objSQL.php';

$profile->stop_profile( $point_1 );

$point_2 = $profile->start_profile( 'DB Connection' );

$dbh = new objsql( array( 'sqlite', '', '', '', 'G:\www\dev\Projects\mojotest2.sq3' ) );

if (
error_get_last() !== null )
    throw new
Exception( error_get_last()['message'] );
else
    echo
"objSQL Version: {$dbh->obj_info()['OBJSQL_VERSION']}<br />
          Database:
{$dbh->obj_info()['DATABASE_NAME']}<br />
          Driver:
{$dbh->obj_info()['DATABASE_DRIVER']}<br />
          DB Type:
{$dbh->obj_info()['DATABASE_TYPE']}<br />
          Version:
{$dbh->obj_info()['DATABASE_VERSION']}<br />
          Collation:
{$dbh->obj_info()['DATABASE_CHARSET']}<br />
          PHP Version:
{$dbh->obj_info()['PHP_VERSION']}<br /><hr />";
               
$profile->stop_profile( $point_2 );

$point_3 = $profile->start_profile( 'Insert Query' );
       
for (
$i = 1; $i < 41; $i++ )
{
   
$data = array( 'f_name' => 'Bob',
                  
'l_name' => 'Jones' );
   
   
$rs = $dbh->obj_insert( 'emp_test', $data );
               
    if (
$dbh->obj_error() )
        throw new
Exception( $dbh->obj_error_message() );
               
   
$data = array( 'f_name' => 'Helen',
                  
'l_name' => 'Xavier' );
   
   
$rs = $dbh->obj_insert( 'emp_test', $data );
               
    if (
$dbh->obj_error() )
        throw new
Exception( $dbh->obj_error_message() );
   
   
$data = array( 'f_name' => 'Ken',
                  
'l_name' => 'Gomez' );
   
   
$rs = $dbh->obj_insert( 'emp_test', $data );
               
    if (
$dbh->obj_error() )
        throw new
Exception( $dbh->obj_error_message() );
   
   
$data = array( 'f_name' => 'Patty',
                  
'l_name' => 'Cline' );
   
   
$rs = $dbh->obj_insert( 'emp_test', $data );
               
    if (
$dbh->obj_error() )
        throw new
Exception( $dbh->obj_error_message() );
}

$profile->stop_profile( $point_3 );

$point_4 = $profile->start_profile( 'Select Query' );

$rs = $dbh->obj_select( 'emp_test', '', 'emp_id' );
       
if (
$dbh->obj_error() )
    throw new
Exception( $dbh->obj_error_message() );
       
while (
$rs->obj_fetch_assoc() )
{
    echo
"{$rs->obj_field( 'emp_id' )} -
         
{$rs->obj_field( 'f_name' )} -
         
{$rs->obj_field( 'l_name' )}<br />";
}
       
$rs->obj_free_result();
       
$profile->stop_profile( $point_4 );

//save to log file
$profile->print_profile( 'profile_log.txt' );

//print to screen
echo "<pre>{$profile->print_profile()}</pre>";

?>