Gecko [ edgpens.lpkmn.gov.my ]

Name	Size	Permission
.mad-root	0 B	-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-
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-record.php

<?php

include_once('../adodb.inc.php');
	include_once('../adodb-active-record.inc.php');
	
	// uncomment the following if you want to test exceptions
	if (@$_GET['except']) {
		if (PHP_VERSION >= 5) {
			include('../adodb-exceptions.inc.php');
			echo "<h3>Exceptions included</h3>";
		}
	}

$db = NewADOConnection('mysql://root@localhost/northwind?persist');
	$db->debug=1;
	ADOdb_Active_Record::SetDatabaseAdapter($db);

$db->Execute("CREATE TEMPORARY TABLE `persons` (
	 `id` int(10) unsigned NOT NULL auto_increment,
	 `name_first` varchar(100) NOT NULL default '',
	 `name_last` varchar(100) NOT NULL default '',
	 `favorite_color` varchar(100) NOT NULL default '',
	 PRIMARY KEY (`id`)
	 ) ENGINE=MyISAM;
	 ");
			 
	$db->Execute("CREATE TEMPORARY TABLE `children` (
	 `id` int(10) unsigned NOT NULL auto_increment,
					`person_id` int(10) unsigned NOT NULL,
	 `name_first` varchar(100) NOT NULL default '',
	 `name_last` varchar(100) NOT NULL default '',
	 `favorite_pet` varchar(100) NOT NULL default '',
	 PRIMARY KEY (`id`)
	 ) ENGINE=MyISAM;
	 ");
			 
	class Person extends ADOdb_Active_Record{ function ret($v) {return $v;} }
	$person = new Person();
	ADOdb_Active_Record::$_quoteNames = '111';
	
	echo "Output of getAttributeNames: ";
	var_dump($person->getAttributeNames());
	
	/**
	 * Outputs the following:
	 * array(4) {
	 * [0]=>
	 * string(2) "id"
	 * [1]=>
	 * string(9) "name_first"
	 * [2]=>
	 * string(8) "name_last"
	 * [3]=>
	 * string(13) "favorite_color"
	 * }
	 */
	
	$person = new Person();
	$person->name_first = 'Andi';
	$person->name_last = 'Gutmans';
	$person->save(); // this save() will fail on INSERT as favorite_color is a must fill...
	
	
	$person = new Person();
	$person->name_first = 'Andi';
	$person->name_last = 'Gutmans';
	$person->favorite_color = 'blue';
	$person->save(); // this save will perform an INSERT successfully
	
	echo "The Insert ID generated:"; print_r($person->id);
	
	$person->favorite_color = 'red';
	$person->save(); // this save() will perform an UPDATE
	
	$person = new Person();
	$person->name_first = 'John';
	$person->name_last = 'Lim';
	$person->favorite_color = 'lavender';
	$person->save(); // this save will perform an INSERT successfully
	
	// load record where id=2 into a new ADOdb_Active_Record
	$person2 = new Person();
	$person2->Load('id=2');
	
	$activeArr = $db->GetActiveRecordsClass($class = "Person",$table = "Persons","id=".$db->Param(0),array(2));
	$person2 = $activeArr[0];
	echo "Name (should be John): ",$person->name_first, " Class (should be Person): ",get_class($person2)," ";	
	
	$db->Execute("insert into children (person_id,name_first,name_last) values (2,'Jill','Lim')");
	$db->Execute("insert into children (person_id,name_first,name_last) values (2,'Joan','Lim')");
	$db->Execute("insert into children (person_id,name_first,name_last) values (2,'JAMIE','Lim')");
	
	$newperson2 = new Person();
	$person2->HasMany('children','person_id');
	$person2->Load('id=2');
	$person2->name_last='green';
	$c = $person2->children;
	$person2->save();

if (is_array($c) && sizeof($c) == 3 && $c[0]->name_first=='Jill' && $c[1]->name_first=='Joan'
		&& $c[2]->name_first == 'JAMIE') echo "OK Loaded HasMany";
	else {
		var_dump($c);
		echo "error loading hasMany should have 3 array elements Jill Joan Jamie ";
	}
	
	class Child extends ADOdb_Active_Record{};
	$ch = new Child('children',array('id'));
	$ch->BelongsTo('person','person_id','id');
	$ch->Load('id=1');
	if ($ch->name_first !== 'Jill') echo "error in Loading Child ";
	
	$p = $ch->person;
	if ($p->name_first != 'John') echo "Error loading belongsTo ";
	else echo "OK loading BelongTo ";

$p->hasMany('children','person_id');
	$p->LoadRelations('children', "	Name_first like 'J%' order by id",1,2);
	if (sizeof($p->children) == 2 && $p->children[1]->name_first == 'JAMIE') echo "OK LoadRelations ";
	else echo "error LoadRelations ";
	
		$db->Execute("CREATE TEMPORARY TABLE `persons2` (
	 `id` int(10) unsigned NOT NULL auto_increment,
	 `name_first` varchar(100) NOT NULL default '',
	 `name_last` varchar(100) NOT NULL default '',
	 `favorite_color` varchar(100) default '',
	 PRIMARY KEY (`id`)
	 ) ENGINE=MyISAM;
	 ");
	
	$p = new adodb_active_record('persons2');
	$p->name_first = 'James';
	
	$p->name_last = 'James';
	
	$p->HasMany('children','person_id');
	$p->children;
	var_dump($p);
	$p->Save();
?>

${this.title}

Code Editor : test-active-record.php