/**
* Return the number of results when the query is performed
*
* @param One_Query $query
* @param boolean $overrideFilters
* @return int
*/
public function executeSchemeCount(One_Query $query, $overrideFilters = false)
{
$scheme = $query->getScheme();
$db = $this->db($scheme);
$renderer = $this->getRenderer();
// Need to remember the old Select in case the One_Query is reused afterwards
$oldSelect = $query->getSelect();
$query->setSelect(array('COUNT( * ) AS total'));
$sql = $renderer->render($query, $overrideFilters);
// put the old Select back into the One_Query
$query->setSelect($oldSelect);
$db->setQuery($sql);
return intval($db->loadResult());
}
/**
* Return the number of results when the query is performed
*
* @param One_Query $query
* @param boolean $overrideFilters
* @return int
*/
public function executeSchemeCount(One_Query $query, $overrideFilters = false)
{
$scheme = $query->getScheme();
$db = $this->db($scheme);
$renderer = $this->getRenderer();
// Need to remember the old Select in case the One_Query is reused afterwards
$oldSelect = $query->getSelect();
$query->setSelect(array('COUNT(*) AS total'));
$sql = $renderer->render($query, $overrideFilters);
// put the old Select back into the One_Query
$query->setSelect($oldSelect);
// execute query
$result = mysql_query($sql, $db);
if ($result == false) {
throw new One_Exception(mysql_error() . '<br />' . $sql);
}
$count = mysql_result($result, 0, 'total');
return $count;
}
/**
* Return the number of results when the query is performed
*
* @param One_Query $query
* @param boolean $overrideFilters
* @return int
*/
public function executeSchemeCount(One_Query $query, $overrideFilters = false)
{
$scheme = $query->getScheme();
$db = $this->db($scheme);
$renderer = $this->getRenderer();
// Need to remember the old Select in case the One_Query is reused afterwards
$oldSelect = $query->getSelect();
$query->setSelect(array('COUNT(*) AS total'));
$sql = $renderer->render($query, $overrideFilters);
// put the old Select back into the One_Query
$query->setSelect($oldSelect);
// execute query
$result = $db->query($sql);
if ($result === false) {
throw new One_Exception('MYSQLI error (' . $db->connect_errno . ') ' . $db->connect_error);
}
$row = $result->fetch_assoc();
$count = $row['total'];
return $count;
}
