Рекурсивный акроним словосочетания «PHP: Hypertext Preprocessor»

Добро пожаловать на форум PHP программистов!

За последние 24 часа нас посетили 15895 программистов и 1772 робота. Сейчас ищут 1033 программиста ...

Оглавление

About the manual Предисловие Basic concepts all PEAR users should understand Installation (Pyrus)Installation (PEAR)Command line installer (PEAR)Dependency Tracking (Meta Packages) with PEAR

Using Pyrus, the PEAR Installer for PHP 5.3+

About Pyrus Commands available in Pyrus Pyrus configuration Differences from the PEAR Installer Creating plugins for Pyrus Developer Tools for Pyrus Using Pyrus in your programs: Pyrus's Public API

PEAR Developer Guide

About PEAR and PEAR2 Becoming a PEAR developer: how to get involved PEAR Developer Guide Coding Standards PEAR Installer: Core components (Installer API, error handling)PEAR Installer: customizing the installer itself RFCs

Channels: distributing your packages

channel.xml, REST, XML-RPC Creating your own channel with Pyrus and PEAR2_SimpleChannelServer

->getLinks()

Вернуться к: DB_DataObject

->getLinks()

->getLinks() – load related objects

Synopsis

boolean $DB_DataObject->getLinks ( string $variableFormat )

Loads the all the related objects into the main object, by using the links.ini relationships, and sets the calling objects variables with the row name prefixed with an underscode (_) to the resulting objects.

Using this with the earlier column naming convention is depreciated, and links.ini files should be used.

Parameter

string $variableFormat - the default behavior is to assign the resulting objects to variables with the row name prefixed with an underscode (_), however, you can use this value to format the variable differently

examples of formaters

  if room.occupied_by is linked to a person.id  without a modifier - eg _%s   results in the equivilant of $object->_occupied_by =  $object->getLink('occupied_by');    with a modifier - eg link_%s   results in the equivilant of $object->link_occupied_by = $object->getLink('occupied_by');

Return value

boolean - TRUE on success and FALSE on failure

Note

This function can not be called statically.

See

DB_DataObject::getLink()

Example

Two Example Tables

Loading all the related objects

 <?php
$person = new DataObjects_Person;
$person->get(1079);
$person->getLinks();
print_r($person);
?>

Resulting SQL

SELECT * FROM person WHERE id=1079
SELECT * FROM convention WHERE id=1

Resulting Output

Object:dataobjects_person Object
(
    [_DB_DataObject_version] => 1.0
    [__table] => person
    [_database_dsn] =>
    [_database_dsn_md5] => 3974043abbccdd6412fb156a1d10b98377
    [_database] => testing
    [_condition] =>
    [_group_by] =>
    [_order_by] =>
    [_limit] =>
    [_data_select] => *
    [_link_loaded] => 1
    [_lastError] => pear_error Object
        (
            [error_message_prefix] =>
            [mode] => 1
            [level] => 1024
            [code] => -3
            [message] => getLink:Could not find class for row last_modified, table last
            [userinfo] =>
            [callback] =>
        )

    [id] => 1079
    [N] => 1
    [_DB_resultid] => 2
    [first_name] => Tim
    [last_name] => White
    [middle_name] =>
    [badge_number] => 123
    [street] => 334411 N Washington
    [city] => Texas
    [state] => CO
    [zip] => 12345
    [phone] => 343412323232
    [reg_type] => Staff
    [judge] =>
    [staff] => CHECKED
    [volunteer] =>
    [rpga_number] => 1232323
    [total_fee] => 0.00
    [email_address] => tim@example.com
    [country] => USA
    [convention_id] => 1
    [last_modified] => 20020711084539
    [_first_name] =>
    [_last_name] =>
    [_middle_name] =>
    [_badge_number] =>
    [_reg_type] =>
    [_rpga_number] =>
    [_total_fee] =>
    [_email_address] =>
    [_convention_id] => dataobjects_convention Object
        (
            [_DB_DataObject_version] => 1.0
            [__table] => convention
            [_database_dsn] =>
            [_database_dsn_md5] => 3974043abbcc86412fb156a1d10b98377
            [_database] => testing
            [_condition] =>
            [_group_by] =>
            [_order_by] =>
            [_limit] =>
            [_data_select] => *
            [_link_loaded] =>
            [_lastError] =>
            [id] => 1
            [N] => 1
            [_DB_resultid] => 3
            [name] => ABCD XYZ
            [sponsor_organization] => some sponser
            [rpga_convention_code] => ABCD_XYZ
            [web_site_url] => http://example.com
            [last_modified] => 20020703143828
            [room_id] => 1
        )

    [_last_modified] =>
)

** Note,  This error: [message] => getLink:Could not find class for row last_modified, table last

is caused by the original link code using {tablename}_{colname} for guessing links, this automated
linking should be ignored, and not used, as it is depreciated.

Example with three tables join

 <?php
/**
 * The following example show a three tables join.
 *
 * More joins can be nested as you see fit.
 */
$person = new DataObjects_Person;

$data = array();
if ($person->find()) {
    while ($person->fetch()) {
        $person->getLinks();
        // Following is another call to getLinks for the second join
        $person->_convention_id->getLinks();
        $data[] = $person->_convention_id->_room_id->ToArray();
    }
}

print_r($data);
?>

databasename.links.ini

; this ini file is for the three tables join example above.
[person]
person_id = convention:person_id

[room]
room_id = convention:room_id

Вернуться к: DB_DataObject