[Sommaire] [Imprimer]

   1  <?php
   2  
   3  // BASIC ADO test
   4  
   5      include_once ('../adodb.inc.php');
   6  
   7      $db = &ADONewConnection("ado_access");
   8      $db->debug=1;
   9      $access = 'd:\inetpub\wwwroot\php\NWIND.MDB';
  10      $myDSN =  'PROVIDER=Microsoft.Jet.OLEDB.4.0;'
  11          . 'DATA SOURCE=' . $access . ';';
  12          
  13      echo "<p>PHP ",PHP_VERSION,"</p>";
  14      
  15      $db->Connect($myDSN) || die('fail');
  16      
  17      print_r($db->ServerInfo());
  18      
  19      try {
  20      $rs = $db->Execute("select $db->sysTimeStamp,* from adoxyz where id>02xx");
  21      print_r($rs->fields);
  22      } catch(exception $e) {
  23      print_r($e);
  24      echo "<p> Date m/d/Y =",$db->UserDate($rs->fields[4],'m/d/Y');
  25      }
  26  ?>