問題描述

我發(fā)現(xiàn)為了顯示加載更多按鈕而進(jìn)行輔助查詢以檢查更多結(jié)果非常不專業(yè).

我正在使用 PDO，有什么方法可以在沒有限制過濾器的情況下獲得找到的總行數(shù)，但仍然過濾結(jié)果?

當(dāng)前代碼:

//顯示結(jié)果$開始= 0$r=$db->prepare("SELECT * FROM location WHERE area=:area LIMIT $start,10");$r->execute($fields);//查看是否有更多結(jié)果$r=$db->prepare("SELECT * FROM location WHERE area=:area");$r->execute($fields);$offset=$start+10;if($r->rowCount()>$offset){echo "
加載更多
";}

MySQL only AFAIK:

$r=$db->prepare("SELECT SQL_CALC_FOUND_ROWS * FROM location WHERE area=:area LIMIT $start,10");$r->execute($fields);var_dump($r->fetchAll());var_dump($db->query('SELECT FOUND_ROWS();')->fetch(PDO::FETCH_COLUMN));

對于數(shù)據(jù)庫服務(wù)器來說，當(dāng)然與查詢所有記錄的時(shí)間一樣繁重.對于非 MySQL 使用，此查詢當(dāng)然比獲取所有記錄的行數(shù)要好:

$r=$db->prepare("SELECT COUNT(*) FROM location WHERE area=:area");$r->execute($fields);$count = $r->fetch(PDO::FETCH_COLUMN);回聲 $count;

I found it very unprofessional to make a secondary query to check for more results in order to display a load more button.

I'm using PDO, is there any way to get the total found rows without the limit filter but still filtering the results?

Current Code:

// Show Results

$start = 0

$r=$db->prepare("SELECT * FROM locations WHERE area=:area LIMIT $start,10");
$r->execute($fields);

// See if there is more results

$r=$db->prepare("SELECT * FROM locations WHERE area=:area");
$r->execute($fields);

$offset=$start+10;
if($r->rowCount() > $offset){
echo "<div class='load'>Load More</div>";
}

MySQL only AFAIK:

$r=$db->prepare("SELECT SQL_CALC_FOUND_ROWS * FROM locations WHERE area=:area LIMIT $start,10");
$r->execute($fields);

var_dump($r->fetchAll());

var_dump($db->query('SELECT FOUND_ROWS();')->fetch(PDO::FETCH_COLUMN));

About as heavy for the database server as querying a single time for all the records of course. For non-MySQL use, this query is of course better then getting the rowcount of all the records:

$r=$db->prepare("SELECT COUNT(*) FROM locations WHERE area=:area");
$r->execute($fields);
$count = $r->fetch(PDO::FETCH_COLUMN);
echo $count;

這篇關(guān)于如何在不考慮 PDO 限制的情況下獲取找到的總行數(shù)?的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！