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.
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)