library/adodb/tests/test-active-recs2.php

   1 <?php
   2 error_reporting(E_ALL);
   3 include('../adodb.inc.php');
   4
   5 include('../adodb-active-record.inc.php');
   6
   7 ###########################
   8
   9 $ADODB_ACTIVE_CACHESECS = 36;
  10
  11 $DBMS = @$_GET['db'];
  12
  13 $DBMS = 'mysql';
  14 if ($DBMS == 'mysql') {
  15         $db = NewADOConnection('mysql://root@localhost/northwind');
  16 } else if ($DBMS == 'postgres') {
  17         $db = NewADOConnection('postgres');
  18         $db->Connect("localhost","tester","test","test");
  19 } else
  20         $db = NewADOConnection('oci8://scott:natsoft@/');
  21
  22
  23 $arr = $db->ServerInfo();
  24 echo "<h3>$db->dataProvider: {$arr['description']}</h3>";
  25
  26 $arr = $db->GetActiveRecords('products',' productid<10');
  27 adodb_pr($arr);
  28
  29 ADOdb_Active_Record::SetDatabaseAdapter($db);
  30 if  (!$db)  die('failed');
  31
  32
  33
  34
  35 $rec = new ADODB_Active_Record('photos');
  36
  37 $rec = new ADODB_Active_Record('products');
  38
  39
  40 adodb_pr($rec->getAttributeNames());
  41
  42 echo "<hr>";
  43
  44
  45 $rec->load('productid=2');
  46 adodb_pr($rec);
  47
  48 $db->debug=1;
  49
  50
  51 $rec->productname = 'Changie Chan'.rand();
  52
  53 $rec->insert();
  54 $rec->update();
  55
  56 $rec->productname = 'Changie Chan 99';
  57 $rec->replace();
  58
  59
  60 $rec2 = new ADODB_Active_Record('products');
  61 $rec->load('productid=3');
  62 $rec->save();
  63
  64 $rec = new ADODB_Active_record('products');
  65 $rec->productname = 'John ActiveRec';
  66 $rec->notes = 22;
  67 #$rec->productid=0;
  68 $rec->discontinued=1;
  69 $rec->Save();
  70 $rec->supplierid=33;
  71 $rec->Save();
  72 $rec->discontinued=0;
  73 $rec->Save();
  74 $rec->Delete();
  75
  76 echo "<p>Affected Rows after delete=".$db->Affected_Rows()."</p>";
  77 ?>