/include/adodb/tests/test-active-record.php
PHP | 82 lines | 48 code | 19 blank | 15 comment | 2 complexity | c7ef92274ade6c6db74e20c8796219f1 MD5 | raw file
Possible License(s): LGPL-2.1, GPL-2.0, BSD-3-Clause, LGPL-2.0, CC-BY-SA-3.0, AGPL-1.0
- <?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->name_first = 'Andi';
- $person->name_last = '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);
-
- ?>