Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
.Index.txt	1.55 KB	-rw-r--r--	2008-01-09 06:27
benchmark.php	2.03 KB	-rw-r--r--	2008-01-09 06:27
client.php	3.99 KB	-rw-r--r--	2008-01-09 06:27
pdo.php	1.73 KB	-rw-r--r--	2008-01-09 06:27
rr.htm	35.64 KB	-rw-r--r--	2008-01-09 06:27
test-active-record.php	2.28 KB	-rw-r--r--	2008-01-09 06:27
test-active-recs2.php	1.31 KB	-rw-r--r--	2008-01-09 06:27
test-datadict.php	7.39 KB	-rw-r--r--	2008-01-09 06:27
test-perf.php	909 B	-rw-r--r--	2008-01-09 06:27
test-pgblob.php	1.99 KB	-rw-r--r--	2008-01-09 06:27
test-php5.php	2.37 KB	-rw-r--r--	2008-01-09 06:27
test-xmlschema.php	1.26 KB	-rw-r--r--	2008-01-09 06:27
test.php	53.45 KB	-rw-r--r--	2008-01-09 06:27
test2.php	574 B	-rw-r--r--	2008-01-09 06:27
test3.php	896 B	-rw-r--r--	2008-01-09 06:27
test4.php	4.41 KB	-rw-r--r--	2008-01-09 06:27
test5.php	1.36 KB	-rw-r--r--	2008-01-09 06:27
test_rs_array.php	679 B	-rw-r--r--	2008-01-09 06:27
testcache.php	806 B	-rw-r--r--	2008-01-09 06:27
testdatabases.inc.php	16.87 KB	-rw-r--r--	2008-01-09 06:27
testgenid.php	731 B	-rw-r--r--	2008-01-09 06:27
testmssql.php	1.99 KB	-rw-r--r--	2008-01-09 06:27
testoci8.php	2.31 KB	-rw-r--r--	2008-01-09 06:27
testoci8cursor.php	2.9 KB	-rw-r--r--	2008-01-09 06:27
testpaging.php	2.26 KB	-rw-r--r--	2008-01-09 06:27
testpear.php	873 B	-rw-r--r--	2008-01-09 06:27
testsessions.php	1.91 KB	-rw-r--r--	2008-01-09 06:27
time.php	478 B	-rw-r--r--	2008-01-09 06:27
tmssql.php	1.84 KB	-rw-r--r--	2008-01-09 06:27
xmlschema-mssql.xml	832 B	-rw-r--r--	2008-01-09 06:27
xmlschema.xml	961 B	-rw-r--r--	2008-01-09 06:27

Rename

<?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');
	$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;
	           ");
			   
	class Person extends ADOdb_Active_Record{}
	$person = new Person();
	
	echo "<p>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->nameFirst = 'Andi';
	$person->nameLast  = '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 "<p>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');
	
	var_dump($person2);
	
	$activeArr = $db->GetActiveRecordsClass($class = "Person",$table = "persons","id=".$db->Param(0),array(2));
	$person2 =& $activeArr[0];
	echo "<p>Name (should be John): ",$person->name_first, " <br> Class (should be Person): ",get_class($person2);