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