diff options
Diffstat (limited to 'trunk/adodb5/tests/test-active-recs2.php')
| -rw-r--r-- | trunk/adodb5/tests/test-active-recs2.php | 77 |
1 files changed, 0 insertions, 77 deletions
diff --git a/trunk/adodb5/tests/test-active-recs2.php b/trunk/adodb5/tests/test-active-recs2.php deleted file mode 100644 index d35751e9..00000000 --- a/trunk/adodb5/tests/test-active-recs2.php +++ /dev/null @@ -1,77 +0,0 @@ -<?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>"; -?>
\ No newline at end of file |
