text: <?php
  error_reporting(E_ALL);
  include('../adodb.inc.php');
  
  include('../adodb-active-record.inc.php');
  
  ###########################
  
  $ADODB_ACTIVE_CACHESECS = 36;
  
  $DBMS = @$_GET['db'];
  
  $DBMS = 'mysql';
  if ($DBMS == 'mysql') {
  	$db = NewADOConnection('mysql://root@localhost/northwind');
  } else if ($DBMS == 'postgres') {
  	$db = NewADOConnection('postgres');
  	$db->Connect("localhost","tester","test","test");
  } else
  	$db = NewADOConnection('oci8://scott:natsoft@/');
  
  
  $arr = $db->ServerInfo();
  echo "<h3>$db->dataProvider: {$arr['description']}</h3>";
  
  $arr = $db->GetActiveRecords('products',' productid<10');
  adodb_pr($arr);
  
  ADOdb_Active_Record::SetDatabaseAdapter($db);
  if  (!$db)  die('failed');
  
  
  
  
  $rec = new ADODB_Active_Record('photos');
  
  $rec = new ADODB_Active_Record('products');
  
  
  adodb_pr($rec->getAttributeNames());
  
  echo "<hr>";
  
  
  $rec->load('productid=2');
  adodb_pr($rec);
  
  $db->debug=1;
  
  
  $rec->productname = 'Changie Chan'.rand();
  
  $rec->insert();
  $rec->update();
  
  $rec->productname = 'Changie Chan 99';
  $rec->replace();
  
  
  $rec2 = new ADODB_Active_Record('products');
  $rec->load('productid=3');
  $rec->save();
  
  $rec = new ADODB_Active_record('products');
  $rec->productname = 'John ActiveRec';
  $rec->notes = 22;
  #$rec->productid=0;
  $rec->discontinued=1;
  $rec->Save();
  $rec->supplierid=33;
  $rec->Save();
  $rec->discontinued=0;
  $rec->Save();
  $rec->Delete();
  
  echo "<p>Affected Rows after delete=".$db->Affected_Rows()."</p>";
  