[8222] | 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 | ?> |
---|