这是我显示视频列表的代码:
<?php
$result = mysqli_query($con,$query);
echo "<div class='"maincover '" data-role='"scrollbox'" data-scroll='"vertical'">";
echo "<div class='"panel panel-default'">";
while($row = mysqli_fetch_array($result)) {
echo "<div class='"panel-heading'">";
echo '<div><a class="panel-title btn-block" href="details.php?id='.$row['id'].'"><h3>'.$row['id'].' | '.$row['vidTitle'].'</h3></a></div>';
echo "</div>";
echo "<div class='"panel-body'">";
echo "<div class='"imgCover'"><img class='"imageCover'"src='"" . $row['url'] . "'"></div>";
echo "<div class='"vidSD'">" . $row['vidSD'] . "</div>";
echo "<div class='"vidDetails'">
<hr class='"style-two'">
<table>
<tr><td class='"vidDetailsTD'"><strong>" . $lang['vtYear'] . "</strong></td><td class='"vidDetailsTD'">" . $row['vidYear'] ."</td></tr>
<tr><td class='"vidDetailsTD'"><strong>" . $lang['vtCity'] . "</strong></td><td class='"vidDetailsTD'">". $row['vidCity'] ."</td></tr>
<tr><td class='"vidDetailsTD'"><strong>" . $lang['vtGenre'] . "</strong></td><td class='"vidDetailsTD'">". $row['vidZanr'] ." , ". $row['vidZanr2'] ." , ". $row['vidZanr3'] . "</td></tr>
<tr><td class='"vidDetailsTD'"><strong>" . $lang['vtQuality'] . "</strong></td><td class='"vidDetailsTD'">". $row['vidQuality'] ."</td></tr>
<tr><td class='"vidDetailsTD'"><strong>" . $lang['vtTranslatedBy'] . "</strong></td><td class='"vidDetailsTD'">". $row['vidTranslated'] ."</td></tr>
<tr><td class='"vidDetailsTD'"><strong>" . $lang['vtVideoTime'] . "</strong></td><td class='"vidDetailsTD'">". $row['vidTime'] . "</td></tr>
</table>
</div></div>";
echo " <div class='"panel-footer'">";
echo '<h6><strong>' . $lang['vsdAuthor'] . '</strong><a href="../userPages/user.php?u='.$row['addName'].'">'.$row['addName'].'</a></h6>';
echo '<div><h6><strong>' . $lang['vsdPublished'] . '</strong>' . $row['published'] . '</h6></div>';
echo "</div>";
}
echo "</div></div>";
mysqli_close($con);
?>
我需要它在底部,如果我有10个以上的结果,它会显示这样的按钮单击
基本上就像谷歌使用的页面负载从1到10,如果你打开第10页,它会显示5到15之间的页面。
这是我想要的另一个示例单击但我不确定如何将其实现到我的代码中。。。
首先,这不能只通过bootstrap来完成,因为它是前端框架。要做到这一点,您还必须对服务器端进行分页,或者使用JS。
这是教程的链接
http://www.techumber.com/2012/08/simple-pagination-with-php-mysql.html
index.php
include ('paginate.php'); //include of paginat page
$per_page = 5; // number of results to show per page
$result = mysql_query("SELECT * FROM countries");
$total_results = mysql_num_rows($result);
$total_pages = ceil($total_results / $per_page);//total pages we going to have
//-------------if page is setcheck------------------//
if (isset($_GET['page'])) {
$show_page = $_GET['page']; //current page
if ($show_page > 0 && $show_page <= $total_pages) {
$start = ($show_page - 1) * $per_page;
$end = $start + $per_page;
} else {
// error - show first set of results
$start = 0;
$end = $per_page;
}
} else {
// if page isn't set, show first set of results
$start = 0;
$end = $per_page;
}
// display pagination
$page = intval($_GET['page']);
$tpages=$total_pages;
if ($page <= 0)
$page = 1;