本文整理汇总了PHP中Zend_Db_Adapter_Pdo_Mysql::fetchAll方法的典型用法代码示例。如果您正苦于以下问题:PHP Zend_Db_Adapter_Pdo_Mysql::fetchAll方法的具体用法?PHP Zend_Db_Adapter_Pdo_Mysql::fetchAll怎么用?PHP Zend_Db_Adapter_Pdo_Mysql::fetchAll使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Zend_Db_Adapter_Pdo_Mysql
的用法示例。
在下文中一共展示了Zend_Db_Adapter_Pdo_Mysql::fetchAll方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: mergeDuplicateSharedTags
/**
* merge duplicate shared tags
*
* @param string $model record model for which tags should be merged
* @param boolean $deleteObsoleteTags
* @param boolean $ignoreAcl
*
* @see 0007354: function for merging duplicate tags
*/
public function mergeDuplicateSharedTags($model, $deleteObsoleteTags = TRUE, $ignoreAcl = FALSE)
{
$select = $this->_db->select()->from(array('tags' => SQL_TABLE_PREFIX . 'tags'), 'name')->where($this->_db->quoteIdentifier('type') . ' = ?', Tinebase_Model_Tag::TYPE_SHARED)->where($this->_db->quoteIdentifier('is_deleted') . ' = 0')->group('name')->having('COUNT(' . $this->_db->quoteIdentifier('name') . ') > 1');
$queryResult = $this->_db->fetchAll($select);
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Found ' . count($queryResult) . ' duplicate tag names.');
}
$controller = Tinebase_Core::getApplicationInstance($model);
if ($ignoreAcl) {
$containerChecks = $controller->doContainerACLChecks(FALSE);
}
$recordFilterModel = $model . 'Filter';
foreach ($queryResult as $duplicateTag) {
$filter = new Tinebase_Model_TagFilter(array('name' => $duplicateTag['name'], 'type' => Tinebase_Model_Tag::TYPE_SHARED));
$paging = new Tinebase_Model_Pagination(array('sort' => 'creation_time'));
$tagsWithSameName = $this->searchTags($filter, $paging);
$targetTag = $tagsWithSameName->getFirstRecord();
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Merging tag ' . $duplicateTag['name'] . '. Found ' . count($tagsWithSameName) . ' tags with this name.');
}
foreach ($tagsWithSameName as $tag) {
if ($tag->getId() === $targetTag->getId()) {
// skip target (oldest) tag
continue;
}
$recordFilter = new $recordFilterModel(array(array('field' => 'tag', 'operator' => 'in', 'value' => array($tag->getId()))));
$recordIdsWithTagToMerge = $controller->search($recordFilter, NULL, FALSE, TRUE);
if (Tinebase_Core::isLogLevel(Zend_Log::DEBUG)) {
Tinebase_Core::getLogger()->debug(__METHOD__ . '::' . __LINE__ . ' Found ' . count($recordIdsWithTagToMerge) . ' ' . $model . '(s) with tags to be merged.');
}
if (!empty($recordIdsWithTagToMerge)) {
$recordFilter = new $recordFilterModel(array(array('field' => 'id', 'operator' => 'in', 'value' => $recordIdsWithTagToMerge)));
$this->attachTagToMultipleRecords($recordFilter, $targetTag);
$this->detachTagsFromMultipleRecords($recordFilter, $tag->getId());
}
// check occurrence of the merged tag and remove it if obsolete
$tag = $this->get($tag);
if ($deleteObsoleteTags && $tag->occurrence == 0) {
$this->deleteTags($tag->getId(), $ignoreAcl);
}
}
}
if ($ignoreAcl) {
/** @noinspection PhpUndefinedVariableInspection */
$controller->doContainerACLChecks($containerChecks);
}
}
示例2: fetchAll
/**
* Fetches elements according to limit
*
* @param int $offset
* @param int $itemCountPerPage
* @return array
*/
public function fetchAll($offset, $itemCountPerPage)
{
return $this->adapter->fetchAll($this->query . ' LIMIT ' . $itemCountPerPage . ' OFFSET ' . $offset);
}