code help - pagination
Posted on
16th Feb 2014 07:03 pm by
admin
Hi all, I have this code, basically a user logs into my site and they get this page.
The problem I have is that the pagination isn't working, and I can figure out why. I dont get any errors.
Can you help please. If you need any more info, just shout. Ta muchly
Code: <?php
include("includes/dbconnect120-gem.php");
include("includes/db_auth_hp.php");
include("includes/functions.php");
$username = $result['username'];
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml"><!-- InstanceBegin template="/Templates/templ8t.dwt.php" codeOutsideHTMLIsLocked="false" -->
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<link href="css/layout.css" rel="stylesheet" type="text/css" />
<link href="css/text.css" rel="stylesheet" type="text/css" />
<!-- InstanceBeginEditable name="doctitle" -->
<title>Untitled Document</title>
<!-- InstanceEndEditable -->
<!-- InstanceBeginEditable name="head" -->
<script language="javascript" type="text/javascript">
<!--
function showhide(id) {
if(document.getElementById(id).style.display == 'none') {
document.getElementById(id).style.display = 'block';
} else {
document.getElementById(id).style.display = 'none';
}
}
-->
</script
<!-- InstanceEndEditable -->
<style type="text/css">
<!--
.style1 {color: #FFFFFF}
.H2 {
font-size: x-large;
font-family: Arial, Helvetica, sans-serif;
background-color: #FFFF00;
}
.link {color: #FFFF33}
-->
</style>
</head>
<body>
<div class="wrapper">
<div class="header">
</div>
<div class="body">
<!-- InstanceBeginEditable name="bodytext" -->
Hello, <?php echo ucwords($username); ?> you are now logged in.
<?php
// find out how many rows are in the table
$sql = "SELECT COUNT(*) FROM articles";
$result = mysql_query($sql) or trigger_error("SQL", E_USER_ERROR);
$r = mysql_fetch_row($result);
$numrows = $r[0];
// number of rows to show per page
$rowsperpage = 1;
// find out total pages
$totalpages = ceil($numrows / $rowsperpage);
// get the current page or set a default
if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {
// cast var as int
$currentpage = (int) $_GET['currentpage'];
} else {
// default page num
$currentpage = 1;
} // end if
// if current page is greater than total pages...
if ($currentpage > $totalpages) {
// set current page to last page
$currentpage = $totalpages;
} // end if
// if current page is less than first page...
if ($currentpage < 1) {
// set current page to first page
$currentpage = 1;
} // end if
// the offset of the list, based on current page
$offset = ($currentpage - 1) * $rowsperpage;
//Gets news.
$sql = "SELECT * FROM articles ORDER BY ID DESC";
$result = mysql_query($sql);
//Displays the results.
while($row = mysql_fetch_array($result)){
$news_title = nl2br($row['Title']);
$news_subtitle = nl2br($row['SubTitle']);
$news_post = nl2br($row['Article']);
$post_id = $row['ID'];
echo $news_title;?>
<?php echo $news_subtitle; ?>
<?php echo $news_post; ?>
<!-- END DISPLAY NEWS -->
<?php
$csql = "SELECT comments.tstamp, login.username, comments.post
FROM comments
LEFT JOIN login
ON comments.userid = login.userid
WHERE comments.articleid = $post_id
ORDER BY comments.postid DESC";
$cquery = mysql_query($csql);
$ccount = mysql_num_rows($cquery);
if($ccount == 0) {
$comments_number = '<a href="comment.php?post='.$post_id.'" target="_self">No Comments</a>';
} else {
$comments_number = '<a href="#coms'.$post_id.'" onclick="showhide('c'.$post_id.'');">Comments('.$ccount.')</a>';
}
?>
<p class="right"><?php echo $comments_number; ?><a name="coms<?php echo $post_id; ?>"></a> </p>
<div style="display:none" id="<?php echo 'c'.$post_id; ?>" >
<?php
if($ccount != 0) {
while($crow = mysql_fetch_array($cquery)) {
$ctime = $crow['tstamp'];
$cusername = ucwords($crow['username']);
$cmessage = $crow['post'];
echo "<hr />n";
echo '<p><span class="bold">'.$cusername.':</span> '.nl2br($cmessage)."n";
echo '<br /><span class="bold">Posted: </span>';
if(timeago($ctime) == '') {
echo "Just.n";
}
elseif(strlen(timeago($ctime)) < 16) {
echo str_replace('and ', '', timeago($ctime)).'ago.</p>'."n";
} else {
echo timeago($ctime).'ago.</p>'."n";
}
}
$more = 'Leave a Comment';
echo '<p class="right"><a href="comment.php?post='.$post_id.'" target="_self">'.$more.'</a></p>';
}
?>
</div>
<?php
} // end while
/****** build the pagination links ******/
// range of num links to show
$range = 4;
// if not on page 1, don't show back links
if ($currentpage > 1) {
// show << link to go back to page 1
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";
// get previous page num
$prevpage = $currentpage - 1;
// show < link to go back to 1 page
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";
} // end if
// loop to show links to range of pages around current page
for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {
// if it's a valid page number...
if (($x > 0) && ($x <= $totalpages)) {
// if we're on current page...
if ($x == $currentpage) {
// 'highlight' it but don't make a link
echo " [<b>$x</b>] ";
// if not current page...
} else {
// make it a link
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";
} // end else
} // end if
} // end for
// if not on last page, show forward and last page links
if ($currentpage != $totalpages) {
// get next page
$nextpage = $currentpage + 1;
// echo forward link for next page
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";
// echo forward link for lastpage
echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";
} // end if
/****** end build pagination links ******/
?>
<!-- InstanceEndEditable --> </div>
<div class="sidebar">
<!-- MENU -->
<BR><?php
include "includes/menujs.js";
include "includes/menucss.css";
include "includes/menu.html";
?>
</p>
<p>
<!-- InstanceBeginEditable name="sidebar" -->
<div class="sidebartitle">
Latest News</div>
<div class="sidebartext">
</div>
<div class="sidebartitle">
Coming Soon </div>
<div class="sidebartext">
</div>
<!-- InstanceEndEditable --> </p>
</div>
</div>
<div class="clear"></div>
<div class="copyright">
<div align="center" class="style1">©Copyright 2010 Bradley Stoke Judo Club || Site Designed by Gem Gale || Site Hosted by <a href="http://www.wotwebsystems.com" class="link">WOT Web Systems</a></div>
</div>
</body>
<!-- InstanceEnd --></html>
Your Answer:
Login to answer
139 
16 
Other forums
php or sql?
Sorry not sure if this is a sql problem or php the following code is supposed to delete data from th
Casting Decimals in Oracle
This code worked as a query in DB2, but I am not sure what the syntax is for casting decimals in Ora
php unable to sent email
Hi, guys, I try to send a email through php but unfortunately the mail unable to sent. Here is my co
Calculating n! using vector
#include
#include
#include
using
Help with simple query
Hi,
I'm trying to do a Query with a Union where I want to print the number of rows $tc conta
foreach result into a single variable
Hi,
I have this code...
Code: [Select]foreach ($_POST['Interests'] as $interest =&
Passing Variables
What I'm wanting to do is when the user clicks on Arenas it will know the name of the country it's w
Array to string conversion
Can anyone help me with this?
Notice: Array to string conversion in /home/..../index.php on l
RTF fomatting to email content
Im trying to sen an email with content is picked up from a rtf-file (file_get_contents('*.rtf'). Mai
Not reloading page after php form submit
Hello helpful souls out there. You guys have come through for me in the recent past and I'm hoping s
