Connect("localhost","tester","test","test"); } else $db = NewADOConnection('oci8://scott:natsoft@/'); $arr = $db->ServerInfo(); echo "

$db->dataProvider: {$arr['description']}

"; $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 "
"; $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 "

Affected Rows after delete=".$db->Affected_Rows()."

";