1<?php 2/* 3V4.80 8 Mar 2006 (c) 2000-2009 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. 8 9 Latest version is available at http://adodb.sourceforge.net 10*/ 11 12error_reporting(E_ALL); 13 14include_once('../adodb-pear.inc.php'); 15$username = 'root'; 16$password = ''; 17$hostname = 'localhost'; 18$databasename = 'xphplens'; 19$driver = 'mysql'; 20 21$dsn = "$driver://$username:$password@$hostname/$databasename"; 22 23$db = DB::Connect($dsn); 24$db->setFetchMode(ADODB_FETCH_ASSOC); 25$rs = $db->Query('select firstname,lastname from adoxyz'); 26$cnt = 0; 27while ($arr = $rs->FetchRow()) { 28 print_r($arr); 29 print "<br>"; 30 $cnt += 1; 31} 32 33if ($cnt != 50) print "<b>Error in \$cnt = $cnt</b>"; 34?>