[Sommaire] [Imprimer]

   1  <?php
   2  error_reporting(E_ALL);
   3  include ('../adodb.inc.php');
   4  
   5  echo "<pre>";
   6  try {
   7      echo "New Connection\n";
   8      
   9      
  10      $dsn = 'pdo_mysql://root:@localhost/northwind?persist';
  11      
  12      if (!empty($dsn)) {
  13          $DB =& NewADOConnection($dsn) || die("CONNECT FAILED");
  14          $connstr = $dsn;
  15      } else {
  16      
  17          $DB = NewADOConnection('pdo');
  18          
  19          echo "Connect\n";
  20          
  21          $u = ''; $p = '';
  22          /*
  23          $connstr = 'odbc:nwind';
  24          
  25          $connstr = 'oci:';
  26          $u = 'scott';
  27          $p = 'natsoft';
  28          
  29          
  30          $connstr ="sqlite:d:\inetpub\adodb\sqlite.db";
  31          */
  32          
  33          $connstr = "mysql:dbname=northwind";
  34          $u = 'root';
  35          
  36          $connstr = "pgsql:dbname=test";
  37          $u = 'tester';
  38          $p = 'test';
  39          
  40          $DB->Connect($connstr,$u,$p) || die("CONNECT FAILED");
  41      
  42      }
  43      
  44      echo "connection string=$connstr\n Execute\n";
  45      
  46      //$ADODB_FETCH_MODE = ADODB_FETCH_ASSOC;
  47      $rs = $DB->Execute("select * from ADOXYZ where id<3");
  48      if  ($DB->ErrorNo()) echo "*** errno=".$DB->ErrorNo() . " ".($DB->ErrorMsg())."\n";
  49      
  50      
  51      //print_r(get_class_methods($DB->_stmt));
  52      
  53      if (!$rs) die("NO RS");
  54      
  55      echo "Meta\n";
  56      for ($i=0; $i < $rs->NumCols(); $i++) {
  57          var_dump($rs->FetchField($i));
  58          echo "<br>";
  59      }
  60      
  61      echo "FETCH\n";
  62      $cnt = 0;
  63      while (!$rs->EOF) {
  64          adodb_pr($rs->fields); 
  65          $rs->MoveNext();
  66          if ($cnt++ > 1000) break;
  67      }
  68      
  69      echo "<br>--------------------------------------------------------<br>\n\n\n";
  70      
  71      $stmt = $DB->PrepareStmt("select * from ADOXYZ");
  72      
  73      $rs = $stmt->Execute();
  74      $cols = $stmt->NumCols(); // execute required
  75      
  76      echo "COLS = $cols";
  77      for($i=1;$i<=$cols;$i++) {
  78          $v = $stmt->_stmt->getColumnMeta($i);
  79          var_dump($v);
  80      }
  81      
  82      echo "e=".$stmt->ErrorNo() . " ".($stmt->ErrorMsg())."\n";
  83      while ($arr = $rs->FetchRow()) {
  84          adodb_pr($arr);
  85      }
  86      die("DONE\n");
  87  
  88  } catch (exception $e) {
  89      echo "<pre>";
  90      echo $e;
  91      echo "</pre>";
  92  }
  93  
  94  ?>