library/adodb/tests/testpaging.php

   1 <?php
   2 /*
   3 V4.20 22 Feb 2004  (c) 2000-2004 John Lim (jlim@natsoft.com.my). All rights reserved.
   4   Released under both BSD license and Lesser GPL library license.
   5   Whenever there is any discrepancy between the two licenses,
   6   the BSD license will take precedence.
   7   Set tabs to 4 for best viewing.
   8
   9   Latest version is available at http://php.weblogs.com/
  10 */
  11
  12 error_reporting(E_ALL);
  13
  14
  15 include_once('../adodb.inc.php');
  16 include_once('../adodb-pager.inc.php');
  17
  18 $driver = 'oci8';
  19 $sql = 'select  ID, firstname as "First Name", lastname as "Last Name" from adoxyz  order  by  id';
  20 //$sql = 'select count(*),firstname from adoxyz group by firstname order by 2 ';
  21 $sql = 'select distinct firstname, lastname from adoxyz  order  by  firstname';
  22
  23 if ($driver == 'postgres') {
  24         $db = NewADOConnection('postgres');
  25         $db->PConnect('localhost','tester','test','test');
  26 }
  27
  28 if ($driver == 'access') {
  29         $db = NewADOConnection('access');
  30         $db->PConnect("nwind", "", "", "");
  31 }
  32
  33 if ($driver == 'ibase') {
  34         $db = NewADOConnection('ibase');
  35         $db->PConnect("localhost:e:\\firebird\\examples\\employee.gdb", "sysdba", "masterkey", "");
  36         $sql = 'select distinct firstname, lastname  from adoxyz  order  by  firstname';
  37
  38 }
  39 if ($driver == 'mssql') {
  40         $db = NewADOConnection('mssql');
  41         $db->Connect('JAGUAR\vsdotnet','adodb','natsoft','northwind');
  42 }
  43 if ($driver == 'oci8') {
  44         $db = NewADOConnection('oci8');
  45         $db->Connect('','scott','natsoft');
  46 }
  47
  48 if ($driver == 'access') {
  49         $db = NewADOConnection('access');
  50         $db->Connect('nwind');
  51 }
  52
  53 if (empty($driver) or $driver == 'mysql') {
  54         $db = NewADOConnection('mysql');
  55         $db->Connect('localhost','root','','xphplens');
  56 }
  57
  58 //$db->pageExecuteCountRows = false;
  59
  60 $db->debug = true;
  61
  62 if (0) {
  63 $rs = &$db->Execute($sql);
  64 include_once('../toexport.inc.php');
  65 print "<pre>";
  66 print rs2csv($rs); # return a string
  67
  68 print '<hr>';
  69 $rs->MoveFirst(); # note, some databases do not support MoveFirst
  70 print rs2tab($rs); # return a string
  71
  72 print '<hr>';
  73 $rs->MoveFirst();
  74 rs2tabout($rs); # send to stdout directly
  75 print "</pre>";
  76 }
  77
  78 $pager = new ADODB_Pager($db,$sql);
  79 $pager->showPageLinks = true;
  80 $pager->linksPerPage = 3;
  81 $pager->cache = 60;
  82 $pager->Render($rows=7);
  83 ?>