home *** CD-ROM | disk | FTP | other *** search
/ PC Professionell 2005 June / PCpro_2005_06.ISO / files / opensource / xamp / xampp-win32.exe / xampp / pdo.php < prev    next >
Encoding:
PHP Script  |  2004-06-30  |  936 b   |  42 lines
  1. <?php
  2. error_reporting(E_ALL);
  3. include('../adodb.inc.php');
  4.  
  5.  
  6.  
  7. echo "New Connection\n";
  8. $DB = NewADOConnection('pdo');
  9. echo "Connect\n";
  10. $pdo_connection_string = 'odbc:nwind';
  11. $DB->Connect($pdo_connection_string,'','') || die("CONNECT FAILED");
  12. echo "Execute\n";
  13.  
  14.  
  15.  
  16. //$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
  17. $rs = $DB->Execute("select * from products where productid<3");
  18. echo "e=".$DB->ErrorNo() . " ".($DB->ErrorMsg())."\n";
  19.  
  20.  
  21. //print_r(get_class_methods($DB->_stmt));
  22.  
  23. if (!$rs) die("NO RS");
  24. echo "FETCH\n";
  25. $cnt = 0;
  26. while (!$rs->EOF) {
  27.     print_r($rs->fields);
  28.     $rs->MoveNext();
  29.     if ($cnt++ > 1000) break;
  30. }
  31.  
  32. echo "<br>--------------------------------------------------------<br>\n\n\n";
  33.  
  34. $stmt = $DB->PrepareStmt("select * from products");
  35. $rs = $stmt->Execute();
  36. echo "e=".$stmt->ErrorNo() . " ".($stmt->ErrorMsg())."\n";
  37. while ($arr = $rs->FetchRow()) {
  38.     print_r($arr);
  39. }
  40. die("DONE\n");
  41.  
  42. ?>