用于php输出的下一页和上一页的Javascript



我想为我正在使用的php输出制作一个上一页/下一页。但是,我通过2 LIMIT创建了输出,因为我只想通过page/divstyle进行两次选择(我会将其设置为99999(,并且我无法使其在next/prev按钮上工作。你知道我是需要javascript代码还是需要做其他事情吗?如果需要,怎么办?我不想转到另一个页面,我只想用这两个选择来更改当前的div样式,并显示下两个。为此,我将LIMIT设置为9999999,但首先我需要弄清楚如何设置两个选择。

$sql10 = "SELECT username, Headshots, Murders, BanditsKilled, TotalBanditsKilled, ZombiesKilled, TotalZombiesKilled, TotalMurders, Backpack, pAdminLevel, pVIP, pHour, pMin, pSec, pBlood, pThrist, pHunger, Humanity, pJailed, pAliveTime, pPoints
FROM users 
where IP = '".$row['IP']."'
order by pHour DESC LIMIT 2;";
$results10 =  array();
$result10 = mysqli_query($con,$sql10);
$results10 = mysqli_fetch_all($result10, MYSQLI_ASSOC);
$resulta10 = mysqli_fetch_array($result10);
$output10 = '';
foreach ($results10 as $row) {
$output10 .= '<div class="panel panel-profile list-view">
<div class="panel-heading">
<div class="media">
<div class="media-left">
<a href="#">
<img class="media-object img-circle" src="../images/photos/user1.png" alt="">
</a>
</div>
<div class="media-body">
<h4 class="media-heading">'. $row['username'] . '</h4>';
if($pAdminLevel1 > 1) : 
$output10 .= '<p class="media-usermeta"><i class="glyphicon glyphicon-briefcase"></i>' . $pAdminLevel . '</p>' ;
endif; 
if($Tester == 1) : 
$output10 .= '<p class="media-usermeta"><i class="glyphicon glyphicon-briefcase"></i>Tester</p>' ;
endif; 
if($Tester == 0 && $pAdminLevel1 < 0) : 
$output10 .= '<p class="media-usermeta"><i class="glyphicon glyphicon-briefcase"></i>Utilizator</p>' ;
endif; 
$output10 .= '</div>
</div><!-- media -->
<ul class="panel-options">
<li><a class="tooltips" href="" data-toggle="tooltip" title="" data-original-title="View Options"><i class="glyphicon glyphicon-option-vertical"></i></a></li>
</ul>
</div><!-- panel-heading -->
<div class="panel-body people-info">
<div class="row">
<div class="col-sm-4">
<div class="info-group">
<label>Headshots</label>
' . $row['Headshots'] . '
</div>
</div>
<div class="col-sm-4">
<div class="info-group">
<label>Ucideri</label>
' . $row['Murders'] . '
</div>
</div>
<div class="col-sm-4">
<div class="info-group">
<label>Bandiți uciși</label>
' . $row['BanditsKilled'] . '
</div>
</div>
</div><!-- row -->
<div class="row">
<div class="col-sm-4">
<div class="info-group">
<label>Numărul total de bandiți uciși:</label>
<h4>'. $row['TotalBanditsKilled'] . '</h4>
</div>
</div>
<div class="col-sm-4">
<div class="info-group">
<label>Zombie uciși</label>
<h4>'. $row['ZombiesKilled'] . '</h4>
</div>
</div>
<div class="col-sm-4">
<div class="info-group">
<label>Numărul total de zombie uciși:</label>
<h4>'. $row['TotalZombiesKilled'] . '</h4>
</div>
</div>
</div><!-- row -->
<div class="row">
<div class="col-sm-4">
<div class="info-group">
<label>Ucideri Totale:</label>
' . $row['TotalMurders'] . '
</div>
</div>
<div class="col-sm-4">
<div class="info-group">
<label>Rucsac</label>
' .$Backpack . '
</div>
</div>
<div class="col-sm-4">
<div class="info-group">
<label>VIP</label>
' . $pVIP . '
</div>
</div>
</div><!-- row -->
<div class="row">
<div class="col-sm-4">
<div class="info-group">
<label>Level:</label>
<h4>'. $row['pHour'] . '</h4>
</div>
</div>
<div class="col-sm-4">
<div class="info-group">
<label>Ore jucate în total:</label>
<h4>'. $row['pHour'] . ':'. $row['pMin'] . '</h4>
</div>
</div>
<div class="col-sm-4">
<div class="info-group">
<label>Sânge</label>
<h4>'. $row['pBlood'] . ' litri</h4>
</div>
</div>
</div>
<div class="row">
<div class="col-sm-4">
<div class="info-group">
<label>Sete</label>
' . $row['pThrist'] . '
</div>
</div>
<div class="col-sm-4">
<div class="info-group">
<label>Foamete</label>
' . $row['pHunger'] . '
</div>
</div>
<div class="col-sm-4">
<div class="info-group">
<label>Umanitate</label>
' . $row['Humanity'] . '
</div>
</div>
</div><!-- row -->
<div class="row">
<div class="col-sm-4">
<div class="info-group">
<label>Admin Jail:</label>
<h4>'. $row['pJailed'] . '</h4>
</div>
</div>
<div class="col-sm-4">
<div class="info-group">
<label>Timp în viață:</label>
<h4>'. $row['pAliveTime'] . '</h4>
</div>
</div>
<div class="col-sm-4">
<div class="info-group">
<label>Credite:</label>
<h4>'. $row['pPoints'] . '</h4>
</div>
</div>
</div>
</div><!-- row -->
</div><!-- panel -->';

以及HTML部分。

<div class="col-sm-8 col-md-9 col-lg-10 people-list">
<div class="people-options clearfix">

<div class="btn-group pull-right people-pager">
<button type="button" onclick="previous()" class="btn btn-default"><i class="fa fa-chevron-left"></i></button>
<button type="button" onclick="next()" class="btn btn-default"><i class="fa fa-chevron-right"></i></button>
</div>
<span class="people-count pull-right">Selected<strong>1-2</strong> of your accounts</span>
</div><!-- people-options -->
<?php echo $output10 ?>

</div>

使用数据表而不是javascript分页。它总是最好的和免费的开源。

https://datatables.net/

相反,您可以使用Turbolinks js,这是一种使页面加载更快和异步的lirary,您可以从github克隆它,执行下面的链接Turbolinks使您的web应用程序导航更快

https://github.com/turbolinks/turbolinks

最新更新