[34] | 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']; |
---|
[8222] | 12 | |
---|
| 13 | $DBMS = 'mysql'; |
---|
[34] | 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 | ?> |
---|