library/adodb/ibase.php

   1 <?php
   2 // bad commit = e3c11ed98970408eae649f929898983c6b5d2a6a
   3
   4 $host = 'localhost:/var/lib/firebird/2.5/data/employee.fdb';
   5 $u = 'SYSDBA';
   6 $p = 'C0yote71';
   7
   8 define( 'ADODB_ASSOC_CASE', $argc > 1 ? (int)$argv[1] : 2 );
   9
  10 /*
  11 $dbh = ibase_connect($host, $u, $p);
  12 $stmt = 'SELECT * FROM employee';
  13
  14 $sth = ibase_query($dbh, $stmt) or die(ibase_errmsg());
  15 var_dump(ibase_fetch_row($sth));
  16 */
  17
  18 require_once('adodb.inc.php');
  19
  20 $ADODB_FETCH_MODE=ADODB_FETCH_ASSOC;
  21 $db = ADONewConnection('ibase');
  22 $db->dialect = 3;
  23
  24 $db->PConnect($host, $u, $p);
  25 $sql="SELECT * FROM EMPLOYEE";
  26 $res=$db->GetRow($sql);
  27 print_r($res);
  28
  29 $res=$db->Execute($sql);
  30 print_r($res->fields);