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