第一页正确显示两个项目,但当我单击下一步它没有显示任何内容。有人可以帮帮我吗。 [英] The First Page Display Two Items Correctly But When I Click On Next It Displays Nothing. Can Someone Please Help Me.
本文介绍了第一页正确显示两个项目,但当我单击下一步它没有显示任何内容。有人可以帮帮我吗。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
this creates a first page with two list if items but when i click the nest button nothing is shown. can someone please help me.
SHOW.PHP
<?php //error_reporting(0); ?>
<?php require_once("connection.php"); ?>
<?php //require_once("functions.php"); ?>
<?php include("function.php"); ?>
<?php //find_selected_page(); ?>
<?php
$con=mysqli_connect("localhost","root","","post");
if(mysqli_connect_errno()){
echo "Failed to connect to MySQL: " . mysqli_connect_error();
}
?>
<!doctype html>
<html lang="en">
<head>
<meta charset="utf-8">
<title>Designs </title>
<link href="_css/header.css" rel="stylesheet" type="text/css">
<link href="css/style.css" rel="stylesheet" type="text/css"/>
<script src="js/jquery-1.9.1.js"></script>
<script type="text/javascript">
$(document).ready(function(){
$('.content').load('show.php').show();
$('#model').change(function(){
$.post('show.php', {brand:$(this).val()},
function(result){
$('.content').html(result).show();
});
});
});
</script>
</head>
<body>
<body class="body">
<?php //include("_includes/logo.html"); ?>
<?php //include("_includes/signups.html"); ?>
<?php echo '<div class="navHeader">'; ?>
<?php echo '<ul>'; ?>
<h5><?php //echo ($sel_page['sub_title']) ?></h5>
<?php echo '</ul>'; ?>
<?php echo '</div>'; ?>
<div class="products">
<?php
if(isset($_REQUEST['page'])){
$sel_page = $_REQUEST['page'];
$page = (int) (!isset($_GET["page"]) ? 1 : $_GET["page"]);
$limit = 2;
$startpoint = ($page * $limit) - $limit;
//to make pagination
$statement = "`userad` WHERE cat_id='$sel_page' ORDER BY id DESC";
?>
<?php
$query = mysqli_query($con, "SELECT * FROM {$statement} LIMIT {$startpoint} , {$limit}");
while($row = mysqli_fetch_array($query)){?>
<?php
echo '<div class="product">';
echo '<li>';
echo '<div class="photo_name">';
echo '<img src="uploaded/'.$row['file'].' " > ';
echo '</div>';
echo '<div class="sub">';
echo '<li>';
echo '<div class="ad_title">';
echo '<h5>Design Name</h5>'.$row['ad_title'].'';
echo '</div><p>';
echo '<div class="ad_title">';
echo '<h5>Price: </h5>'.$row['price'].' GH ';
echo '</div><p>';
echo '<div class="ad_title">';
echo '<h5>Contact</h5>'.$row['m_number'].'';
echo '</div><p>';
echo '<div class="ad_title">';
echo '<h5>Designer</h5>'.$row['contact_name'].'';
echo '</div>';
echo '<div class="ad_title">';
echo '<h5>Location</h5>'.$row['address'].'';
echo '</div>';
echo '<div class="view-more">';
echo '<h4><a href="store.php?designer=', $row['u_name'], '">View more from this Designer</a></h4>';
echo '</div>';
echo '</li>';
echo '</div>';
echo '</li>';
echo '</div>';
?>
<?php }
}
?>
</div>
<?php //include("_includes/ender.php"); ?>
<!--<div class="demo-description">
<p>A menu with the default configuration, showing how to use a menu with icons.</p>
</div>-->
<?php
echo '<div class="subbody">';
//echo '<ul>';
echo '<li>';
echo pagination($statement,$limit,$page);
echo '</li>';
//echo '</ul>';
echo '</div>';
?>
</body>
</html>
FUNCTION.PHP
<?php
function pagination($query, $per_page = 10,$page = 1, $url = '?'){
$query = "SELECT COUNT(*) as `num` FROM {$query}";
$row = mysql_fetch_array(mysql_query($query));
$total = $row['num'];
$adjacents = "2";
$page = ($page == 0 ? 1 : $page);
$start = ($page - 1) * $per_page;
$prev = $page - 1;
$next = $page + 1;
$lastpage = ceil($total/$per_page);
$lpm1 = $lastpage - 1;
$pagination = "";
if($lastpage > 1)
{
$pagination .= "<ul class='pagination'>";
$pagination .= "<li class='details'>Page $page of $lastpage</li>";
if ($lastpage < 7 + ($adjacents * 2))
{
for ($counter = 1; $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<li><a class='current'>$counter</a></li>";
else
$pagination.= "<li><a href='{$url}page=$counter'>$counter</a></li>";
}
}
elseif($lastpage > 5 + ($adjacents * 2))
{
if($page < 1 + ($adjacents * 2))
{
for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)
{
if ($counter == $page)
$pagination.= "<li><a class='current'>$counter</a></li>";
else
$pagination.= "<li><a href='{$url}page=$counter'>$counter</a></li>";
}
$pagination.= "<li class='dot'>...</li>";
$pagination.= "<li><a href='{$url}page=$lpm1'>$lpm1</a></li>";
$pagination.= "<li><a href='{$url}page=$lastpage'>$lastpage</a></li>";
}
elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))
{
$pagination.= "<li><a href='{$url}page=1'>1</a></li>";
$pagination.= "<li><a href='{$url}page=2'>2</a></li>";
$pagination.= "<li class='dot'>...</li>";
for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)
{
if ($counter == $page)
$pagination.= "<li><a class='current'>$counter</a></li>";
else
$pagination.= "<li><a href='{$url}page=$counter'>$counter</a></li>";
}
$pagination.= "<li class='dot'>..</li>";
$pagination.= "<li><a href='{$url}page=$lpm1'>$lpm1</a></li>";
$pagination.= "<li><a href='{$url}page=$lastpage'>$lastpage</a></li>";
}
else
{
$pagination.= "<li><a href='{$url}page=1'>1</a></li>";
$pagination.= "<li><a href='{$url}page=2'>2</a></li>";
$pagination.= "<li class='dot'>..</li>";
for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)
{
if ($counter == $page)
$pagination.= "<li><a class='current'>$counter</a></li>";
else
$pagination.= "<li><a href='{$url}page=$counter'>$counter</a></li>";
}
}
}
if ($page < $counter - 1){
$pagination.= "<li><a href='{$url}page=$next'>Next</a></li>";
$pagination.= "<li><a href='{$url}page=$lastpage'>Last</a></li>";
}else{
$pagination.= "<li><a class='current'>Next</a></li>";
$pagination.= "<li><a class='current'>Last</a></li>";
}
$pagination.= "</ul>\n";
}
return $pagination;
}
?>
THANKS IN ADVANCE.
推荐答案
con=mysqli_connect(\"localhost\",\"root\",\"\",\"post\");
if(mysqli_connect_errno()){
echo \"Failed to connect to MySQL: \" . mysqli_connect_error();
}
?>
<!doctype html>
<html lang=\"en\">
<head>
<meta charset=\"utf-8\">
<title>Designs </title>
<link href=\"_css/header.css\" rel=\"stylesheet\" type=\"text/css\">
<link href=\"css/style.css\" rel=\"stylesheet\" type=\"text/css\"/>
<script src=\"js/jquery-1.9.1.js\"></script>
<script type=\"text/javascript\">
con=mysqli_connect("localhost","root","","post"); if(mysqli_connect_errno()){ echo "Failed to connect to MySQL: " . mysqli_connect_error(); } ?> <!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>Designs </title> <link href="_css/header.css" rel="stylesheet" type="text/css"> <link href="css/style.css" rel="stylesheet" type="text/css"/> <script src="js/jquery-1.9.1.js"></script> <script type="text/javascript">
(document).ready(function(){
(document).ready(function(){
('.content').load('show.php').show();
('.content').load('show.php').show();
这篇关于第一页正确显示两个项目,但当我单击下一步它没有显示任何内容。有人可以帮帮我吗。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文