00001 <?php
00002
00003
00004
00005
00006
00007
00008
00009
00010
00011
00012 error_reporting(E_ALL);
00013
00014 include_once('../adodb-pear.inc.php');
00015 $username = 'root';
00016 $password = '';
00017 $hostname = 'localhost';
00018 $databasename = 'xphplens';
00019 $driver = 'mysql';
00020
00021 $dsn = "$driver://$username:$password@$hostname/$databasename";
00022
00023 $db = DB::Connect($dsn);
00024 $db->setFetchMode(ADODB_FETCH_ASSOC);
00025 $rs = $db->Query('select firstname,lastname from adoxyz');
00026 $cnt = 0;
00027 while ($arr = $rs->FetchRow()) {
00028 print_r($arr);
00029 print "<br>";
00030 $cnt += 1;
00031 }
00032
00033 if ($cnt != 50) print "<b>Error in \$cnt = $cnt</b>";
00034 ?>