本文整理匯總了PHP中ResultSet::valid方法的典型用法代碼示例。如果您正苦於以下問題:PHP ResultSet::valid方法的具體用法?PHP ResultSet::valid怎麽用?PHP ResultSet::valid使用的例子?那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類ResultSet
的用法示例。
在下文中一共展示了ResultSet::valid方法的1個代碼示例,這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚,您的評價將有助於係統推薦出更棒的PHP代碼示例。
示例1: loadAttributes
/**
* Load attributes values with single query
*
* @param ResultSet $rows
* @param ResultSet $attributes
* @return array
*/
public function loadAttributes($rows, $attributes)
{
if (!$rows->valid()) {
return;
}
$this->cacheAttributes($attributes);
$entityIds = array();
foreach ($rows as $row) {
array_push($entityIds, $this->getEntityId($row));
}
$typeTables = $this->getTypeTables($attributes);
$queries = array();
foreach ($typeTables as $type => $typeTable) {
$select = $typeTable->getSql()->select();
$select->where(array('entity_id' => $entityIds));
$attributeIds = array();
foreach ($attributes as $attribute) {
if ($type == $this->getAttributeType($attribute)) {
$attributeIds[] = $this->getAttributeId($attribute);
}
}
$select->where(array('attribute_id' => $attributeIds));
$queries[] = $select->getSqlString($typeTable->getAdapter()->getPlatform());
}
/* build query */
$query = '(' . implode(') UNION ALL (', $queries) . ')';
$db = $this->_entitiesTable->getAdapter();
$valuesRows = $db->query($query, Adapter::QUERY_MODE_EXECUTE);
$result = new ValuesCache();
foreach ($valuesRows as $row) {
$result->setAttributeValue($row['entity_id'], $row['attribute_id'], $row['value']);
}
return $result;
}