3 V4.80 8 Mar 2006 (c) 2000-2012 John Lim (jlim#natsoft.com). 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.
9 Latest version is available at http://adodb.sourceforge.net
12 error_reporting(E_ALL);
15 include_once('../adodb.inc.php');
16 include_once('../adodb-pager.inc.php');
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';
23 if ($driver == 'postgres') {
24 $db = NewADOConnection('postgres');
25 $db->PConnect('localhost','tester','test','test');
28 if ($driver == 'access') {
29 $db = NewADOConnection('access');
30 $db->PConnect("nwind", "", "", "");
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';
39 if ($driver == 'mssql') {
40 $db = NewADOConnection('mssql');
41 $db->Connect('JAGUAR\vsdotnet','adodb','natsoft','northwind');
43 if ($driver == 'oci8') {
44 $db = NewADOConnection('oci8');
45 $db->Connect('','scott','natsoft');
47 $sql = "select * from (select ID, firstname as \"First Name\", lastname as \"Last Name\" from adoxyz
51 if ($driver == 'access') {
52 $db = NewADOConnection('access');
53 $db->Connect('nwind');
56 if (empty($driver) or $driver == 'mysql') {
57 $db = NewADOConnection('mysql');
58 $db->Connect('localhost','root','','test');
61 //$db->pageExecuteCountRows = false;
66 $rs = $db->Execute($sql);
67 include_once('../toexport.inc.php');
69 print rs2csv($rs); # return a string
72 $rs->MoveFirst(); # note, some databases do not support MoveFirst
73 print rs2tab($rs); # return a string
77 rs2tabout($rs); # send to stdout directly
81 $pager = new ADODB_Pager($db,$sql);
82 $pager->showPageLinks = true;
83 $pager->linksPerPage = 10;
85 $pager->Render($rows=7);