1<?php
2
3	include_once('../adodb.inc.php');
4	include_once('../adodb-active-record.inc.php');
5
6
7	$db = NewADOConnection('mysql://root@localhost/northwind');
8	$db->debug=1;
9	ADOdb_Active_Record::SetDatabaseAdapter($db);
10
11	$db->Execute("CREATE TEMPORARY TABLE `persons` (
12	                `id` int(10) unsigned NOT NULL auto_increment,
13	                `name_first` varchar(100) NOT NULL default '',
14	                `name_last` varchar(100) NOT NULL default '',
15	                `favorite_color` varchar(100) NOT NULL default '',
16	                PRIMARY KEY  (`id`)
17	            ) ENGINE=MyISAM;
18	           ");
19
20	$db->Execute("CREATE TEMPORARY TABLE `children` (
21	                `id` int(10) unsigned NOT NULL auto_increment,
22					`person_id` int(10) unsigned NOT NULL,
23	                `name_first` varchar(100) NOT NULL default '',
24	                `name_last` varchar(100) NOT NULL default '',
25	                `favorite_pet` varchar(100) NOT NULL default '',
26	                PRIMARY KEY  (`id`)
27	            ) ENGINE=MyISAM;
28	           ");
29
30
31	$db->Execute("insert into children (person_id,name_first,name_last) values (1,'Jill','Lim')");
32	$db->Execute("insert into children (person_id,name_first,name_last) values (1,'Joan','Lim')");
33	$db->Execute("insert into children (person_id,name_first,name_last) values (1,'JAMIE','Lim')");
34
35	ADODB_Active_Record::TableHasMany('persons', 'children','person_id');
36	class person extends ADOdb_Active_Record{}
37
38	$person = new person();
39#	$person->HasMany('children','person_id');  ## this is affects all other instances of Person
40
41	$person->name_first     = 'John';
42	$person->name_last      = 'Lim';
43	$person->favorite_color = 'lavender';
44	$person->save(); // this save will perform an INSERT successfully
45
46	$person2 = new person();
47	$person2->Load('id=1');
48
49	$c = $person2->children;
50	if (is_array($c) && sizeof($c) == 3 && $c[0]->name_first=='Jill' && $c[1]->name_first=='Joan'
51		&& $c[2]->name_first == 'JAMIE') echo "OK Loaded HasMany</br>";
52	else {
53		var_dump($c);
54		echo "error loading hasMany should have 3 array elements Jill Joan Jamie<br>";
55	}
56
57	class child extends ADOdb_Active_Record{};
58	ADODB_Active_Record::TableBelongsTo('children','person','person_id','id');
59	$ch = new Child('children',array('id'));
60
61	$ch->Load('id=1');
62	if ($ch->name_first !== 'Jill') echo "error in Loading Child<br>";
63
64	$p = $ch->person;
65	if (!$p || $p->name_first != 'John') echo "Error loading belongsTo<br>";
66	else echo "OK loading BelongTo<br>";
67
68	if ($p) {
69		#$p->HasMany('children','person_id');  ## this is affects all other instances of Person
70		$p->LoadRelations('children', 'order by id',1,2);
71		if (sizeof($p->children) == 2 && $p->children[1]->name_first == 'JAMIE') echo "OK LoadRelations<br>";
72		else {
73		 	var_dump($p->children);
74			echo "error LoadRelations<br>";
75		}
76
77		unset($p->children);
78		$p->LoadRelations('children', " name_first like 'J%' order by id",1,2);
79	}
80	if ($p)
81	foreach($p->children as $c) {
82		echo " Saving $c->name_first <br>";
83		$c->name_first .= ' K.';
84		$c->Save();
85	}
86
87?>