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 | ?> |
---|