"TYPO3 4.0.1: typo3_src-4.0.1/typo3/sysext/adodb/adodb/tests/test-active-record.php Source File", "datetime" => "Sat Dec 2 19:22:26 2006", "date" => "2 Dec 2006", "doxygenversion" => "1.4.6", "projectname" => "TYPO3 4.0.1", "projectnumber" => "4.0.1" ); get_header($doxygen_vars); ?>

test-active-record.php

<?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());
        
        $person = new Person();
        $person->nameFirst = 'Andi';
        $person->nameLast  = '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);  
        


?>