本文整理汇总了PHP中Zend_Db_Adapter_Pdo_Mysql::fetchOne方法的典型用法代码示例。如果您正苦于以下问题:PHP Zend_Db_Adapter_Pdo_Mysql::fetchOne方法的具体用法?PHP Zend_Db_Adapter_Pdo_Mysql::fetchOne怎么用?PHP Zend_Db_Adapter_Pdo_Mysql::fetchOne使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Zend_Db_Adapter_Pdo_Mysql
的用法示例。
在下文中一共展示了Zend_Db_Adapter_Pdo_Mysql::fetchOne方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: searchNotesCount
/**
* count notes
*
* @param Tinebase_Model_NoteFilter $_filter
* @param boolean $ignoreACL
* @return int notes count
*/
public function searchNotesCount(Tinebase_Model_NoteFilter $_filter, $ignoreACL = true)
{
$select = $this->_db->select()->from(array('notes' => SQL_TABLE_PREFIX . 'notes'), array('count' => 'COUNT(' . $this->_db->quoteIdentifier('id') . ')'))->where($this->_db->quoteIdentifier('is_deleted') . ' = 0');
if (!$ignoreACL) {
$this->_checkFilterACL($_filter);
}
Tinebase_Backend_Sql_Filter_FilterGroup::appendFilters($select, $_filter, $this);
$result = $this->_db->fetchOne($select);
return $result;
}
示例2: getCount
/**
* Gets record count for current page
*
* @return int
*/
public function getCount()
{
$count = 0;
$count = $this->adapter->fetchOne('SELECT COUNT(1) as fox_query_count FROM (' . $this->query . ') AS fox_subquery_count');
return $count;
}