diff options
Diffstat (limited to 'trunk/adodb5/tests/testpaging.php')
| -rw-r--r-- | trunk/adodb5/tests/testpaging.php | 86 |
1 files changed, 0 insertions, 86 deletions
diff --git a/trunk/adodb5/tests/testpaging.php b/trunk/adodb5/tests/testpaging.php deleted file mode 100644 index 39de9d12..00000000 --- a/trunk/adodb5/tests/testpaging.php +++ /dev/null @@ -1,86 +0,0 @@ -<?php -/* -V4.80 8 Mar 2006 (c) 2000-2012 John Lim (jlim#natsoft.com). All rights reserved. - Released under both BSD license and Lesser GPL library license. - Whenever there is any discrepancy between the two licenses, - the BSD license will take precedence. - Set tabs to 4 for best viewing. - - Latest version is available at http://adodb.sourceforge.net -*/ - -error_reporting(E_ALL); - - -include_once('../adodb.inc.php'); -include_once('../adodb-pager.inc.php'); - -$driver = 'oci8'; -$sql = 'select ID, firstname as "First Name", lastname as "Last Name" from adoxyz order by id'; -//$sql = 'select count(*),firstname from adoxyz group by firstname order by 2 '; -//$sql = 'select distinct firstname, lastname from adoxyz order by firstname'; - -if ($driver == 'postgres') { - $db = NewADOConnection('postgres'); - $db->PConnect('localhost','tester','test','test'); -} - -if ($driver == 'access') { - $db = NewADOConnection('access'); - $db->PConnect("nwind", "", "", ""); -} - -if ($driver == 'ibase') { - $db = NewADOConnection('ibase'); - $db->PConnect("localhost:e:\\firebird\\examples\\employee.gdb", "sysdba", "masterkey", ""); - $sql = 'select distinct firstname, lastname from adoxyz order by firstname'; - -} -if ($driver == 'mssql') { - $db = NewADOConnection('mssql'); - $db->Connect('JAGUAR\vsdotnet','adodb','natsoft','northwind'); -} -if ($driver == 'oci8') { - $db = NewADOConnection('oci8'); - $db->Connect('','scott','natsoft'); - -$sql = "select * from (select ID, firstname as \"First Name\", lastname as \"Last Name\" from adoxyz - order by 1)"; -} - -if ($driver == 'access') { - $db = NewADOConnection('access'); - $db->Connect('nwind'); -} - -if (empty($driver) or $driver == 'mysql') { - $db = NewADOConnection('mysql'); - $db->Connect('localhost','root','','test'); -} - -//$db->pageExecuteCountRows = false; - -$db->debug = true; - -if (0) { -$rs = $db->Execute($sql); -include_once('../toexport.inc.php'); -print "<pre>"; -print rs2csv($rs); # return a string - -print '<hr />'; -$rs->MoveFirst(); # note, some databases do not support MoveFirst -print rs2tab($rs); # return a string - -print '<hr />'; -$rs->MoveFirst(); -rs2tabout($rs); # send to stdout directly -print "</pre>"; -} - -$pager = new ADODB_Pager($db,$sql); -$pager->showPageLinks = true; -$pager->linksPerPage = 10; -$pager->cache = 60; -$pager->Render($rows=7); -?>
\ No newline at end of file |
