Gecko [ 8.222.176.185 ]

Name	Size	Permission
.mad-root	0 B	-rw-rw-rw-
adminer.php	465.43 KB	-rw-rw-rw-
benchmark.php	2.03 KB	-rw-rw-rw-
client.php	3.98 KB	-rw-rw-rw-
pdo.php	1.82 KB	-rw-rw-rw-
pwnkit	10.99 KB	-rw-rw-rw-
test-active-record.php	4.63 KB	-rw-rw-rw-
test-active-recs2.php	1.41 KB	-rw-rw-rw-
test-active-relations.php	2.99 KB	-rw-rw-rw-
test-active-relationsx.php	24.48 KB	-rw-rw-rw-
test-datadict.php	7.49 KB	-rw-rw-rw-
test-perf.php	959 B	-rw-rw-rw-
test-pgblob.php	1.99 KB	-rw-rw-rw-
test-php5.php	2.48 KB	-rw-rw-rw-
test-xmlschema.php	1.28 KB	-rw-rw-rw-
test.php	54.95 KB	-rw-rw-rw-
test2.php	598 B	-rw-rw-rw-
test3.php	893 B	-rw-rw-rw-
test4.php	4.56 KB	-rw-rw-rw-
test5.php	1.35 KB	-rw-rw-rw-
test_rs_array.php	679 B	-rw-rw-rw-
testcache.php	803 B	-rw-rw-rw-
testdatabases.inc.php	17.82 KB	-rw-rw-rw-
testgenid.php	766 B	-rw-rw-rw-
testmssql.php	1.98 KB	-rw-rw-rw-
testoci8.php	2.32 KB	-rw-rw-rw-
testoci8cursor.php	2.89 KB	-rw-rw-rw-
testpaging.php	2.25 KB	-rw-rw-rw-
testpear.php	870 B	-rw-rw-rw-
testsessions.php	2.48 KB	-rw-rw-rw-
time.php	520 B	-rw-rw-rw-
tmssql.php	1.92 KB	-rw-rw-rw-
xmlschema-mssql.xml	832 B	-rw-rw-rw-
xmlschema.xml	961 B	-rw-rw-rw-

Name

Size

Permission

Action

.mad-root

0 B

-rw-rw-rw-

adminer.php

465.43 KB

-rw-rw-rw-

benchmark.php

2.03 KB

-rw-rw-rw-

client.php

3.98 KB

-rw-rw-rw-

pdo.php

1.82 KB

-rw-rw-rw-

pwnkit

10.99 KB

-rw-rw-rw-

test-active-record.php

4.63 KB

-rw-rw-rw-

test-active-recs2.php

1.41 KB

-rw-rw-rw-

test-active-relations.php

2.99 KB

-rw-rw-rw-

test-active-relationsx.php

24.48 KB

-rw-rw-rw-

test-datadict.php

7.49 KB

-rw-rw-rw-

test-perf.php

959 B

-rw-rw-rw-

test-pgblob.php

1.99 KB

-rw-rw-rw-

test-php5.php

2.48 KB

-rw-rw-rw-

test-xmlschema.php

1.28 KB

-rw-rw-rw-

test.php

54.95 KB

-rw-rw-rw-

test2.php

598 B

-rw-rw-rw-

test3.php

893 B

-rw-rw-rw-

test4.php

4.56 KB

-rw-rw-rw-

test5.php

1.35 KB

-rw-rw-rw-

test_rs_array.php

679 B

-rw-rw-rw-

testcache.php

803 B

-rw-rw-rw-

testdatabases.inc.php

17.82 KB

-rw-rw-rw-

testgenid.php

766 B

-rw-rw-rw-

testmssql.php

1.98 KB

-rw-rw-rw-

testoci8.php

2.32 KB

-rw-rw-rw-

testoci8cursor.php

2.89 KB

-rw-rw-rw-

testpaging.php

2.25 KB

-rw-rw-rw-

testpear.php

870 B

-rw-rw-rw-

testsessions.php

2.48 KB

-rw-rw-rw-

time.php

520 B

-rw-rw-rw-

tmssql.php

1.92 KB

-rw-rw-rw-

xmlschema-mssql.xml

832 B

-rw-rw-rw-

xmlschema.xml

961 B

-rw-rw-rw-

Code Editor : test-active-recs2.php

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

${this.title}

Code Editor : test-active-recs2.php