PHP Project::LoadArrayByMinimumId Examples

Example #1

File: migrating.tpl.php Project: qcodo/qcodo

        // Escape the Parameter(s)
        $intId = $objDatabase->SqlVariable($intId);
        // Setup the SQL Query
        $strQuery = sprintf('
				SELECT
				%s
					project.*
					%s
				FROM
					`project` AS `project`
					%s
				WHERE
					project.id > %s
				%s
				%s', $strLimitPrefix, $strExpandSelect, $strExpandFrom, $intId, $strOrderBy, $strLimitSuffix);
        // Perform the Query and Instantiate the Result
        $objDbResult = $objDatabase->Query($strQuery);
        return Project::InstantiateDbResult($objDbResult);
    }
}
// Lets use Beta 2-style Object Expansion (using QQueryExpansion) to Load an Array of Projects
$objExpansionMap[Project::ExpandManagerPerson] = true;
$objProjectArray = Project::LoadArrayByMinimumId(2, null, null, $objExpansionMap);
foreach ($objProjectArray as $objProject) {
    printf('ID #%s: %s (managed by %s %s)<br/>', $objProject->Id, $objProject->Name, $objProject->ManagerPerson->FirstName, $objProject->ManagerPerson->LastName);
}
?>

	<?php 
$this->RenderEnd();
require __INCLUDES__ . '/examples/footer.inc.php';