php - 分页自定义 SQL 查询

Question

我对 WordPress 后端真的很陌生。在这里，我试图通过 $_POST 传递变量并根据我的数据库中的这些变量获取结果。一切正常，我面临的唯一问题是我得到了 80 到 90 个结果，我想给这个东西分页。我已经尝试通过绕过 URL 中的 page 变量来做到这一点，但我认为 $_POST 变量没有在第 2 页上传递。我正在添加下面的代码。

<?php
$graphic = $_POST["graphics"];
$mem = $_POST["memo"];
$opsys = $_POST["osys"];
$cpuu = $_POST["cpu"];
$hddd = $_POST["hdd"];
?>
<?php  
$rowcount = $wpdb->get_var("SELECT COUNT(*) FROM game_list WHERE game_ram <= $mem AND game_card <= $graphic AND game_hdd <= $hddd AND game_os <= $opsys AND game_cpu <= $cpuu ");
?> 
<p>
<?php
global $wpdb;
global $row;
$result = $wpdb->get_results( "SELECT * FROM game_list where game_ram <= $mem AND game_card <= $graphic AND game_hdd <= $hddd AND game_os <= $opsys AND game_cpu <= $cpuu order by release_date desc");

?>

<div>


<div style="padding:7px;"><h3> We found <font style="color:blue;"><?php echo $rowcount; ?></font> Results</h3><br><a href="https://wgod7.com/game-search-page/">Reset Parameters/Search Again</a></div>

<?php
foreach ($result as $row) {
echo "<div class=\"column\" style=\"width:100%;min-height: fit-content;padding:5px; margin:3px;border: 1px solid;border-radius: 15px; float: left;\">
<div class=\"column\" style=\"width:25%; float: left;\">
<img src=\"";
echo $row->game_icon;
echo "\" style=\"height: 138px;width:98px;\">
</div>
<div class=\"column\" style=\"padding:5px;width:75%; float: left;\"><a href=\"";
echo $row->game_link;
echo "\"><b>";  
echo $row->game_name;
echo "</a></b><hr> <b>WGod7 Game Score : </b>";
echo $row->metacritic_score;
echo "<br><b>Release Date : </b>";
echo $row->release_date;
echo "<span style=\"float:right;\"><a href=\""; echo $row->game_link; echo"\">Read More...</a></span>";
echo "</div></div>";    
}
?>
</div>

标签： phpmysqlwordpress