在分页期间保存PHP/AJAX筛选器选择

我有一个页面，允许您使用AJAX调用过滤结果，这很好，我已经添加了分页，最初工作很好，但一旦你移动到另一个页面，复选框变得未选中，它只是再次显示所有结果。我认为这是因为页面移动到第2页时正在重新加载，是否有办法保持过滤器设置的设置并继续显示过滤器AJAX的结果。当没有选择过滤器时，分页显然工作得很好，但我的大脑似乎没有工作，无法解决这个问题。任何帮助将不胜感激!

我的代码如下，我也知道，目前我的代码是开放的sql注入，但只是试图让一切工作，然后将返回通过它:

<body>
<?php include("PHP/header.php"); ?>

<div class="container-fluid">

<div class="container" style="margin-top: 2%; text-align: center;"> 
<h1> Reviews</h1>
On This page you will find our reviews on music tech and software
<br/>
<br/>
<br/>
Filter Reviews:
<ul class="list-group">
<?php
$search = $conn->prepare("SELECT DISTINCT reviewcat FROM review_db ORDER BY reviewcat");
$search->execute(); 
while ($row = $search->fetch(PDO::FETCH_ASSOC)) {       
?>
<li class="list-group-item">
<div class="form-check">
<label class="form-check-label">
<input type="checkbox" class="form-check-input product_check" value="<?=$row['reviewcat'];?>" id="reviewcat"> <?=$row['reviewcat']; ?>
</label>
</div>
</li>
<?php } ?>
</ul>
</div>
<br/><br/>  
<div class="row-fluid ">

<h5 class="text-center" id="textChange"> All Reviews </h5>
<hr>
<div class="text-center">
<img src="Images/loader.gif" id="loader" width="100" style="display: none">
</div>
<?php
if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
}
$no_of_records_per_page = 8;
$offset = ($pageno-1) * $no_of_records_per_page;


// Prev + Next


$prev = $pageno - 1;
$next = $pageno + 1;     
?>


<div id="result" class="card-deck card_group_style pt-4" >
<?php



$stmt = $conn->prepare("SELECT COUNT(*) FROM review_db");
$stmt->execute();

$total_rows = $stmt->fetchColumn();
$total_pages = ceil($total_rows / $no_of_records_per_page);


$result = $conn->prepare("SELECT * FROM review_db ORDER BY reviewsub DESC LIMIT $offset, $no_of_records_per_page ");
$result->execute();



?>    


<?php while ($row = $result->fetch(PDO::FETCH_ASSOC)) {// Important line !!! Check summary get row on array .. ?>

<?php
$my_date = $row['reviewsub'];
$date = DATE("d/m/Y",strtotime($my_date));
?>
<div class="col-sm-6 col-lg-3 py-2">

<div class="card mb-4">



<img class="card-img-top card-images " src="Images/Reviews/<?php echo $row['reviewimage1'];?>" alt="<?php echo $row['reviewtitle'];?>" >
<div class="card-body">
<h5 class="card-title"><?php echo $row['reviewtitle'];?></h5>
<p class="card-text"><?php echo $row['reviewsynop'];?></p>


<a href="Reviews/review-content.php?id=<?php echo $row['id'];?>&reviewtitle=<?php echo $row['reviewtitle'];?>" class="btn btn-primary my-4" >Read More</a>
<div class="card-footer" style="padding: 1%;">
<small class="text-muted">Submitted: <?php echo $date; ?></small>
</div>
</div>


</div> 
</div>




<?php } ?>



</div>

<div class="container">
<!-- Pagination Controller -->
<?php
if($total_pages <= 1){

$hidepage = 'none'; 

}else{

$hidepage = 'flex';
}
?>  

<ul class="pagination justify-content-center pagination-mb" style="display: <?php echo $hidepage; ?>">

<li><a class="page-link" href="?pageno=1">First</a></li>

<li class="page-item <?php if($pageno <= 1){ echo 'disabled'; } ?>">
<a class="page-link" href="<?php if($pageno <= 1){ echo '#'; } else { echo "?pageno=".($pageno - 1); } ?>">Prev</a>
</li>


<?php for($i = 1; $i <= $total_pages; $i++ ): ?>
<li class="page-item <?php if($pageno == $i) {echo 'active'; } ?>">
<a class="page-link" href="?pageno=<?= $i; ?>"> <?= $i; ?> </a>
</li>
<?php endfor; ?>




<li class="page-item <?php if($pageno >= $total_pages){ echo 'disabled'; } ?>">
<a class="page-link" href="<?php if($pageno >= $total_pages){ echo '#'; } else { echo "?pageno=".($pageno + 1); } ?>">Next</a>
</li>

<li><a class="page-link" href="?pageno=<?php echo $total_pages; ?>">Last</a></li>

</ul>

<!-- Pagination end -->
</div>

</div>





</div>

</div>
<?php include("PHP/footer.php"); ?>
</div>
</body>
<?php include("PHP/js.php"); ?>
<script>
$(document).ready(function(){
$('#link-review,#link-footer-review').addClass('active');
});
</script>
<script type="text/javascript">
$(document).ready(function(){

function get_filter_text(text_id){
var filterData = [];
$('#'+text_id+':checked').each(function(){
filterData.push($(this).val());
});
return filterData;
}






$(".product_check").click(function(){
if ($(this).prop('checked')) {  

$("#loader").show();

var action = 'data';
var reviewcat = get_filter_text('reviewcat');

$.ajax({
method:'POST',
url:'reviewaction.php',
data:{action:action,reviewcat:reviewcat},
success:function(response){
$("#result").html(response);
$("#loader").hide();
$("#textChange").text("Filtered Reviews");
}

});
} else {

$("#loader").show();

var action = 'data';
var reviewcat = get_filter_text('reviewcat');

$.ajax({
method:'POST',
url:'reviewaction.php',
data:{action:action,reviewcat:reviewcat},
success:function(response){
$("#result").html(response);
$("#loader").hide();
$("#textChange").text("All Reviews");
}

});

}

});



});
</script>

reviewaction.php:

<?php

if(isset($_POST['action'])){

if (isset($_GET['pageno'])) {
$pageno = $_GET['pageno'];
} else {
$pageno = 1;
}
$no_of_records_per_page = 8;
$offset = ($pageno-1) * $no_of_records_per_page;


// Prev + Next


$prev = $pageno - 1;
$next = $pageno + 1;


$checksql = "SELECT COUNT(*) FROM review_db WHERE reviewcat !=''";
$sql = "SELECT * FROM review_db WHERE reviewcat !=''";


if(isset($_POST['reviewcat'])){
$reviewcat = implode("','", $_POST['reviewcat']);
$checksql .="AND reviewcat IN('".$reviewcat."')";
$sql .="AND reviewcat IN('".$reviewcat."')";
}

$resultpag = $conn->prepare($checksql);
$resultpag->execute();

$total_rows = $resultpag->fetchColumn();
$total_pages = ceil($total_rows / $no_of_records_per_page);

$sql .="ORDER BY reviewsub DESC LIMIT $offset, $no_of_records_per_page "; 


$result = $conn->prepare($sql);
$result->execute();

$output='';

if (count($result) > 0) {


while ($row = $result->fetch(PDO::FETCH_ASSOC)) {

$my_date = $row['reviewsub'];
$date = DATE("d/m/Y",strtotime($my_date));

$output .= '


<div class="col-sm-6 col-lg-3 py-2">

<div class="card mb-4">



<img class="card-img-top card-images" src="Images/Reviews/'.$row['reviewimage1'].'" alt="'.$row['reviewtitle'].'" >
<div class="card-body">
<h5 class="card-title">'.$row['reviewtitle'].'</h5>
<p class="card-text">'.$row['reviewsynop'].'</p>



<a href="Reviews/review-content.php?id='.$row['id'].'&reviewtitle='.$row['reviewtitle'].'" class="btn btn-primary my-4" >Read More</a>

<div class="card-footer" style="padding: 1%;">
<small class="text-muted">Submitted: '.$date.'</small>
</div>


</div> 
</div>
</div>



';
} //While Loop End






}else{
$output = "<h3>No Reviews Found!</h3>";
}







echo $output;
} 


?>

有两种方法。一种方法是将过滤器添加到过滤器函数末尾的每个页面链接的GET URI参数中，如果在运行POST请求之前URI中存在参数，则添加将过滤器标记为选中/检查的代码。另一种方法是更改代码，以便使用相同的POST请求进行分页，而不是实际导航到新的URL。

相关内容

最新更新

热门标签：