?? test-active-recs2.php
字號:
<?phperror_reporting(E_ALL);include('../adodb.inc.php');include('../adodb-active-record.inc.php');###########################$ADODB_ACTIVE_CACHESECS = 36;$DBMS = @$_GET['db'];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>";?>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -