1<?php
2require_once '../../MPLT.php';
3$timer = new MPLT();
4require_once '../../src/dalmp.php';
5# ------------------------------------------------------------------------------
6
7$user = getenv('MYSQL_USER') ?: 'root';
8$password = getenv('MYSQL_PASS') ?: '';
9$host = getenv('MYSQL_HOST') ?: '127.0.0.1';
10$port = getenv('MYSQL_PORT') ?: '3306';
11
12define('DALMP_MYSQLI_INIT_COMMAND', 'SET time_zone="-05:00"');
13
14$db = new DALMP\Database("utf8://$user:$password@$host:$port/dalmp");
15
16echo "-05:00 time: ", $db->GetOne('SELECT NOW()');
17
18/**
19 *  load zone files to mysql
20 *  mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root mysql
21 */
22$db->PExecute('SET time_zone=?','+00:00');
23
24echo PHP_EOL, 'UTC time: ', $db->GetOne('SELECT NOW()');
25echo PHP_EOL, 'lc_time_names: ', $db->GetOne('SELECT @@lc_time_names');
26echo ': ', $db->PGetOne("SELECT DATE_FORMAT(?,'%W %a %M %b')", '2010-01-01');
27
28$db->PExecute('SET lc_time_names=?', 'es_MX');
29
30echo PHP_EOL, 'lc_time_names: ', $db->GetOne('SELECT @@lc_time_names');
31echo ': ', $db->PGetOne("SELECT DATE_FORMAT(?,'%W %a %M %b')", '2010-01-01');
32
33$db->PExecute('SET lc_time_names=?', 'pt_BR');
34echo PHP_EOL, 'lc_time_names: ', $db->GetOne('SELECT @@lc_time_names');
35echo ': ', $db->PGetOne("SELECT DATE_FORMAT(?,'%W %a %M %b')", '2010-01-01');
36
37# ------------------------------------------------------------------------------
38echo PHP_EOL,str_repeat('-', 80),PHP_EOL,'Time: ',$timer->getPageLoadTime(),' - Memory: ',$timer->getMemoryUsage(1),PHP_EOL,str_repeat('-', 80),PHP_EOL;
39