lib/WikiDB/adodb/tests/pdo.php

   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 ?>