$v) { echo " $f=$v"; } echo "\r\n"; } function test_DataFetcher($df) { $df->query(0, 4); while($row = $df->getRow()) { dump_row($row); } echo "----\r\n"; $df->query(4, 4); while($row = $df->getRow()) { dump_row($row); } echo "----\r\n"; $df->query(8, 4); while($row = $df->getRow()) { dump_row($row); } $df->close(); } function test_MysqliDataFetcher() { $df = new MysqliDataFetcher('localhost', 'root', '', 'Test', 'SELECT f1,f2 FROM t1'); test_DataFetcher($df); } function test_PDOmysqlDataFetcher() { $df = new PDOmysqlDataFetcher('localhost', 'root', '', 'Test', 'SELECT f1,f2 FROM t1', array()); test_DataFetcher($df); } function test_PDOmysqlDataFetcherWithParam() { $df = new PDOmysqlDataFetcher('localhost', '', '', 'Test', 'SELECT f1,f2 FROM t1 WHERE f1 > :f1', array('f1' => 1)); test_DataFetcher($df); } function test_PDOsqlsrvDataFetcher() { $df = new PDOsqlsrvDataFetcher('(local)', '', '', 'Test', 'SELECT f1,f2 FROM t1', array()); test_DataFetcher($df); } function bool2str($v) { return $v ? 'true' : 'false'; } function dump_dp($dp) { echo $dp->getFirst() . ' - ' . $dp->getLast() . ":\r\n"; foreach($dp->getData() as $row) { dump_row($row); } echo bool2str($dp->hasPrev()) . ' ' . bool2str($dp->hasNext()) . "\r\n"; } function test_DataPaginator() { $df = new PDOmysqlDataFetcher('localhost', 'root', '', 'Test', 'SELECT f1,f2 FROM t1', array()); $dp = new DataPaginator($df, 4); for(;;) { dump_dp($dp); if(!$dp->hasNext()) break; $dp->next(); } while($dp->hasPrev()) { $dp->prev(); dump_dp($dp); } } function test_DataPaginatorOffset() { $df = new PDOmysqlDataFetcher('localhost', 'root', '', 'Test', 'SELECT f1,f2 FROM t1', array()); $dp = new DataPaginator($df, 4, 5); dump_dp($dp); } function test_VisualPaginator($vp) { $vp->display(); } function test_SimpleTableVisualPaginator() { $df = new PDOmysqlDataFetcher('localhost', 'root', '', 'Test', 'SELECT f1,f2 FROM t1', array()); $dp = new DataPaginator($df, 4, 5); $vp = new SimpleTableVisualPaginator($dp, 'list.php', 'Test data', array('Col 1', 'Col 2')); test_VisualPaginator($vp); } function test_AdvancedTableVisualPaginator() { $df = new PDOmysqlDataFetcher('localhost', 'root', '', 'Test', 'SELECT f1,f2 FROM t1', array()); $dp = new DataPaginator($df, 4, 5); $vp = new AdvancedTableVisualPaginator($dp, 'list.php', 'Test data', array('Col 1', 'Col 2'), array('th' => 'AAA', 'td' => 'BBB'), 'f1', 'edit.php', 'del.php'); test_VisualPaginator($vp); } function test_SimpleListVisualPaginator() { $df = new PDOmysqlDataFetcher('localhost', 'root', '', 'Test', 'SELECT f1,f2 FROM t1', array()); $dp = new DataPaginator($df, 4, 5); $vp = new SimpleListVisualPaginator($dp, 'list.php', 'Test data'); test_VisualPaginator($vp); } function test_AdvancedListVisualPaginator() { $df = new PDOmysqlDataFetcher('localhost', 'root', '', 'Test', 'SELECT f1,f2 FROM t1', array()); $dp = new DataPaginator($df, 4, 5); $vp = new AdvancedListVisualPaginator($dp, 'list.php', 'Test data', array('ul' => 'AAA', 'li' => 'BBB'), "f1=:f1\r\n
\r\nf2=:f2\r\n"); test_VisualPaginator($vp); } ?>