PHP cltr\pdo_table Examples

Example #1

File: example.php Project: bubujka/cltr

<?php

require 'cltr.php';
cltr\pdo_host('localhost');
cltr\pdo_dbname('my_blog');
cltr\pdo_user('root');
cltr\pdo_password('OloloO111');
cltr\pdo_table('page_time');
cltr\start();
sleep(1);
cltr\stop();

Example #2

File: cltr.php Project: bubujka/cltr

});
def('cltr\\time', function () {
    return microtime(true) - cltr\time_start();
});
def('cltr\\stop', function () {
    try {
        if (!cltr\pdo_host()) {
            return;
        }
        if (!cltr\time_start()) {
            return;
        }
        $db = cltr\pdo();
        $db->query('
      CREATE TABLE IF NOT EXISTS `' . cltr\pdo_table() . '` (
        `id` int(11) NOT NULL AUTO_INCREMENT,
        `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
        `host` varchar(255) DEFAULT NULL,
        `uri` varchar(1024) DEFAULT NULL,
        `time` float(8,5) DEFAULT NULL,
        `memory` int(11) DEFAULT NULL,
        PRIMARY KEY (`id`)
      ) ENGINE=MyISAM AUTO_INCREMENT=0 DEFAULT CHARSET=utf8;');
        $db->query('insert into `' . cltr\pdo_table() . '` (host, uri, memory, time) values(
      ' . $db->quote(cltr\host()) . ',
      ' . $db->quote(cltr\uri()) . ',
      ' . $db->quote(memory_get_peak_usage()) . ',
      ' . $db->quote(cltr\time()) . ')');
    } catch (Exception $e) {
    }
});