/include/adodb/tests/testpear.php
PHP | 34 lines | 20 code | 5 blank | 9 comment | 3 complexity | 83e8845b290525e5b78610bf2b505038 MD5 | raw file
Possible License(s): LGPL-2.1, GPL-2.0, BSD-3-Clause, LGPL-2.0, CC-BY-SA-3.0, AGPL-1.0
- <?php
- /*
- V4.80 8 Mar 2006 (c) 2000-2006 John Lim (jlim#natsoft.com.my). All rights reserved.
- Released under both BSD license and Lesser GPL library license.
- Whenever there is any discrepancy between the two licenses,
- the BSD license will take precedence.
- Set tabs to 4 for best viewing.
-
- Latest version is available at http://adodb.sourceforge.net
- */
- error_reporting(E_ALL);
- include_once('../adodb-pear.inc.php');
- $username = 'root';
- $password = '';
- $hostname = 'localhost';
- $databasename = 'xphplens';
- $driver = 'mysql';
- $dsn = "$driver://$username:$password@$hostname/$databasename";
- $db = DB::Connect($dsn);
- $db->setFetchMode(ADODB_FETCH_ASSOC);
- $rs = $db->Query('select firstname,lastname from adoxyz');
- $cnt = 0;
- while ($arr = $rs->FetchRow()) {
- print_r($arr);
- print "<br>";
- $cnt += 1;
- }
- if ($cnt != 50) print "<b>Error in \$cnt = $cnt</b>";
- ?>