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