[903] | 1 | <?php
|
---|
| 2 | /*
|
---|
| 3 | V4.80 8 Mar 2006 (c) 2000-2007 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://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 ';
|
---|
| 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 | $sql = "select * from (select ID, firstname as \"First Name\", lastname as \"Last Name\" from adoxyz
|
---|
| 48 | order by 1)";
|
---|
| 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');
|
---|
| 58 | $db->Connect('localhost','root','','test');
|
---|
| 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 |
|
---|
| 71 | print '<hr />';
|
---|
| 72 | $rs->MoveFirst(); # note, some databases do not support MoveFirst
|
---|
| 73 | print rs2tab($rs); # return a string
|
---|
| 74 |
|
---|
| 75 | print '<hr />';
|
---|
| 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;
|
---|
| 83 | $pager->linksPerPage = 10;
|
---|
| 84 | $pager->cache = 60;
|
---|
| 85 | $pager->Render($rows=7);
|
---|
| 86 | ?> |
---|