1<?php 2require_once '../mplt.php'; 3$timer = new mplt(); 4require_once '../dalmp.php'; 5# ----------------------------------------------------------------------------------------------------------------- 6 7$db = new DALMP('utf8://dalmp:password@192.168.1.40:3306/dalmptest'); 8 9/** 10 * 11-- ---------------------------- 12-- Table structure for `dalmp_sessions` 13-- ---------------------------- 14CREATE TABLE IF NOT EXISTS `dalmp_sessions` ( 15 `sid` varchar(40) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', 16 `expiry` int(11) unsigned NOT NULL DEFAULT '0', 17 `data` longtext CHARACTER SET utf8 COLLATE utf8_unicode_ci, 18 `ref` varchar(255) DEFAULT NULL, 19 `ts` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, 20 PRIMARY KEY (`sid`), 21 KEY `index` (`ref`,`sid`,`expiry`) 22) ENGINE=MyISAM DEFAULT CHARSET=utf8; 23 * 24 */ 25 26/** 27 * to store sessions on mysql you need to pass the $db DALMP object if not defaults to sqlite 28 */ 29$sessions = new DALMP_Sessions($db); 30 31$GLOBALS['UID'] = 1; 32 33if ((mt_rand() % 10) == 0) { 34 $sessions->regenerate_id(4); 35} 36 37$_SESSION['test'] = 1 + @$_SESSION['test']; 38 39$rs = $db->FetchMode('ASSOC')->PGetRow('SELECT * FROM dalmp_sessions WHERE ref=?', $GLOBALS['UID']); 40print_r($rs); 41 42echo $db->isCli(1),session_id().$db->isCli(1),$_SESSION['test']; 43 44# ----------------------------------------------------------------------------------------------------------------- 45echo PHP_EOL,str_repeat('-', 80),PHP_EOL,'Time: ',$timer->getPageLoadTime(),' - Memory: ',$timer->getMemoryUsage(1),PHP_EOL,str_repeat('-', 80),PHP_EOL; 46