Rev | Line | |
---|
[6779] | 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 | include_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; |
---|
| 27 | while ($arr = $rs->FetchRow()) { |
---|
| 28 | print_r($arr); |
---|
| 29 | print "<br>"; |
---|
| 30 | $cnt += 1; |
---|
| 31 | } |
---|
| 32 | |
---|
| 33 | if ($cnt != 50) print "<b>Error in \$cnt = $cnt</b>"; |
---|
| 34 | ?> |
---|
Note: See
TracBrowser
for help on using the repository browser.