[2] | 1 | <?php |
---|
| 2 | /* |
---|
[34] | 3 | V4.80 8 Mar 2006 (c) 2000-2007 John Lim (jlim#natsoft.com.my). All rights reserved. |
---|
[2] | 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://adodb.sourceforge.net |
---|
| 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 '; |
---|
[34] | 21 | //$sql = 'select distinct firstname, lastname from adoxyz order by firstname'; |
---|
[2] | 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'); |
---|
[34] | 46 | |
---|
| 47 | $sql = "select * from (select ID, firstname as \"First Name\", lastname as \"Last Name\" from adoxyz |
---|
| 48 | order by 1)"; |
---|
[2] | 49 | } |
---|
| 50 | |
---|
| 51 | if ($driver == 'access') { |
---|
| 52 | $db = NewADOConnection('access'); |
---|
| 53 | $db->Connect('nwind'); |
---|
| 54 | } |
---|
| 55 | |
---|
| 56 | if (empty($driver) or $driver == 'mysql') { |
---|
| 57 | $db = NewADOConnection('mysql'); |
---|
[34] | 58 | $db->Connect('localhost','root','','test'); |
---|
[2] | 59 | } |
---|
| 60 | |
---|
| 61 | //$db->pageExecuteCountRows = false; |
---|
| 62 | |
---|
| 63 | $db->debug = true; |
---|
| 64 | |
---|
| 65 | if (0) { |
---|
| 66 | $rs = &$db->Execute($sql); |
---|
| 67 | include_once('../toexport.inc.php'); |
---|
| 68 | print "<pre>"; |
---|
| 69 | print rs2csv($rs); # return a string |
---|
| 70 | |
---|
[34] | 71 | print '<hr />'; |
---|
[2] | 72 | $rs->MoveFirst(); # note, some databases do not support MoveFirst |
---|
| 73 | print rs2tab($rs); # return a string |
---|
| 74 | |
---|
[34] | 75 | print '<hr />'; |
---|
[2] | 76 | $rs->MoveFirst(); |
---|
| 77 | rs2tabout($rs); # send to stdout directly |
---|
| 78 | print "</pre>"; |
---|
| 79 | } |
---|
| 80 | |
---|
| 81 | $pager = new ADODB_Pager($db,$sql); |
---|
| 82 | $pager->showPageLinks = true; |
---|
[34] | 83 | $pager->linksPerPage = 10; |
---|
[2] | 84 | $pager->cache = 60; |
---|
| 85 | $pager->Render($rows=7); |
---|
| 86 | ?> |
---|