[34] | 1 | <?php |
---|
| 2 | |
---|
| 3 | include_once('../adodb.inc.php'); |
---|
| 4 | include_once('../adodb-active-record.inc.php'); |
---|
| 5 | |
---|
| 6 | // uncomment the following if you want to test exceptions |
---|
| 7 | if (@$_GET['except']) { |
---|
| 8 | if (PHP_VERSION >= 5) { |
---|
| 9 | include('../adodb-exceptions.inc.php'); |
---|
| 10 | echo "<h3>Exceptions included</h3>"; |
---|
| 11 | } |
---|
| 12 | } |
---|
| 13 | |
---|
[8222] | 14 | $db = NewADOConnection('mysql://root@localhost/northwind?persist'); |
---|
[34] | 15 | $db->debug=1; |
---|
| 16 | ADOdb_Active_Record::SetDatabaseAdapter($db); |
---|
| 17 | |
---|
[8222] | 18 | |
---|
[34] | 19 | $db->Execute("CREATE TEMPORARY TABLE `persons` ( |
---|
| 20 | `id` int(10) unsigned NOT NULL auto_increment, |
---|
| 21 | `name_first` varchar(100) NOT NULL default '', |
---|
| 22 | `name_last` varchar(100) NOT NULL default '', |
---|
| 23 | `favorite_color` varchar(100) NOT NULL default '', |
---|
| 24 | PRIMARY KEY (`id`) |
---|
| 25 | ) ENGINE=MyISAM; |
---|
| 26 | "); |
---|
| 27 | |
---|
[8222] | 28 | $db->Execute("CREATE TEMPORARY TABLE `children` ( |
---|
| 29 | `id` int(10) unsigned NOT NULL auto_increment, |
---|
| 30 | `person_id` int(10) unsigned NOT NULL, |
---|
| 31 | `name_first` varchar(100) NOT NULL default '', |
---|
| 32 | `name_last` varchar(100) NOT NULL default '', |
---|
| 33 | `favorite_pet` varchar(100) NOT NULL default '', |
---|
| 34 | PRIMARY KEY (`id`) |
---|
| 35 | ) ENGINE=MyISAM; |
---|
| 36 | "); |
---|
| 37 | |
---|
| 38 | class Person extends ADOdb_Active_Record{ function ret($v) {return $v;} } |
---|
[34] | 39 | $person = new Person(); |
---|
[8222] | 40 | ADOdb_Active_Record::$_quoteNames = '111'; |
---|
[34] | 41 | |
---|
| 42 | echo "<p>Output of getAttributeNames: "; |
---|
| 43 | var_dump($person->getAttributeNames()); |
---|
| 44 | |
---|
| 45 | /** |
---|
| 46 | * Outputs the following: |
---|
| 47 | * array(4) { |
---|
| 48 | * [0]=> |
---|
| 49 | * string(2) "id" |
---|
| 50 | * [1]=> |
---|
| 51 | * string(9) "name_first" |
---|
| 52 | * [2]=> |
---|
| 53 | * string(8) "name_last" |
---|
| 54 | * [3]=> |
---|
| 55 | * string(13) "favorite_color" |
---|
| 56 | * } |
---|
| 57 | */ |
---|
| 58 | |
---|
| 59 | $person = new Person(); |
---|
| 60 | $person->name_first = 'Andi'; |
---|
| 61 | $person->name_last = 'Gutmans'; |
---|
| 62 | $person->save(); // this save() will fail on INSERT as favorite_color is a must fill... |
---|
| 63 | |
---|
| 64 | |
---|
| 65 | $person = new Person(); |
---|
| 66 | $person->name_first = 'Andi'; |
---|
| 67 | $person->name_last = 'Gutmans'; |
---|
| 68 | $person->favorite_color = 'blue'; |
---|
| 69 | $person->save(); // this save will perform an INSERT successfully |
---|
| 70 | |
---|
| 71 | echo "<p>The Insert ID generated:"; print_r($person->id); |
---|
| 72 | |
---|
| 73 | $person->favorite_color = 'red'; |
---|
| 74 | $person->save(); // this save() will perform an UPDATE |
---|
| 75 | |
---|
| 76 | $person = new Person(); |
---|
| 77 | $person->name_first = 'John'; |
---|
| 78 | $person->name_last = 'Lim'; |
---|
| 79 | $person->favorite_color = 'lavender'; |
---|
| 80 | $person->save(); // this save will perform an INSERT successfully |
---|
| 81 | |
---|
| 82 | // load record where id=2 into a new ADOdb_Active_Record |
---|
| 83 | $person2 = new Person(); |
---|
| 84 | $person2->Load('id=2'); |
---|
| 85 | |
---|
[8222] | 86 | $activeArr = $db->GetActiveRecordsClass($class = "Person",$table = "Persons","id=".$db->Param(0),array(2)); |
---|
| 87 | $person2 = $activeArr[0]; |
---|
| 88 | echo "<p>Name (should be John): ",$person->name_first, " <br> Class (should be Person): ",get_class($person2),"<br>"; |
---|
[34] | 89 | |
---|
[8222] | 90 | $db->Execute("insert into children (person_id,name_first,name_last) values (2,'Jill','Lim')"); |
---|
| 91 | $db->Execute("insert into children (person_id,name_first,name_last) values (2,'Joan','Lim')"); |
---|
| 92 | $db->Execute("insert into children (person_id,name_first,name_last) values (2,'JAMIE','Lim')"); |
---|
[34] | 93 | |
---|
[8222] | 94 | $newperson2 = new Person(); |
---|
| 95 | $person2->HasMany('children','person_id'); |
---|
| 96 | $person2->Load('id=2'); |
---|
| 97 | $person2->name_last='green'; |
---|
| 98 | $c = $person2->children; |
---|
| 99 | $person2->save(); |
---|
[34] | 100 | |
---|
[8222] | 101 | if (is_array($c) && sizeof($c) == 3 && $c[0]->name_first=='Jill' && $c[1]->name_first=='Joan' |
---|
| 102 | && $c[2]->name_first == 'JAMIE') echo "OK Loaded HasMany</br>"; |
---|
| 103 | else { |
---|
| 104 | var_dump($c); |
---|
| 105 | echo "error loading hasMany should have 3 array elements Jill Joan Jamie<br>"; |
---|
| 106 | } |
---|
| 107 | |
---|
| 108 | class Child extends ADOdb_Active_Record{}; |
---|
| 109 | $ch = new Child('children',array('id')); |
---|
| 110 | $ch->BelongsTo('person','person_id','id'); |
---|
| 111 | $ch->Load('id=1'); |
---|
| 112 | if ($ch->name_first !== 'Jill') echo "error in Loading Child<br>"; |
---|
| 113 | |
---|
| 114 | $p = $ch->person; |
---|
| 115 | if ($p->name_first != 'John') echo "Error loading belongsTo<br>"; |
---|
| 116 | else echo "OK loading BelongTo<br>"; |
---|
[34] | 117 | |
---|
[8222] | 118 | $p->hasMany('children','person_id'); |
---|
| 119 | $p->LoadRelations('children', " Name_first like 'J%' order by id",1,2); |
---|
| 120 | if (sizeof($p->children) == 2 && $p->children[1]->name_first == 'JAMIE') echo "OK LoadRelations<br>"; |
---|
| 121 | else echo "error LoadRelations<br>"; |
---|
| 122 | |
---|
| 123 | $db->Execute("CREATE TEMPORARY TABLE `persons2` ( |
---|
| 124 | `id` int(10) unsigned NOT NULL auto_increment, |
---|
| 125 | `name_first` varchar(100) NOT NULL default '', |
---|
| 126 | `name_last` varchar(100) NOT NULL default '', |
---|
| 127 | `favorite_color` varchar(100) default '', |
---|
| 128 | PRIMARY KEY (`id`) |
---|
| 129 | ) ENGINE=MyISAM; |
---|
| 130 | "); |
---|
| 131 | |
---|
| 132 | $p = new adodb_active_record('persons2'); |
---|
| 133 | $p->name_first = 'James'; |
---|
| 134 | |
---|
| 135 | $p->name_last = 'James'; |
---|
| 136 | |
---|
| 137 | $p->HasMany('children','person_id'); |
---|
| 138 | $p->children; |
---|
| 139 | var_dump($p); |
---|
| 140 | $p->Save(); |
---|
[34] | 141 | ?> |
---|