| Date Posted |
Email |
Phone |
Name |
Subject |
Message |
|
', $question);
print "
| $date_post |
$client_email |
$client_phone |
$client_name |
$subject |
$question |
delete |
";
}
print "
";
// how many rows we have in database
$result = mysqli_query($conn, $query) or die(mysqli_error($conn));
$numrows = mysqli_num_rows($result);
// how many pages we have when using paging?
$maxPage = ceil($numrows/$rowsPerPage);
$self = $_SERVER['PHP_SELF'];
// creating 'previous' and 'next' link
// plus 'first page' and 'last page' link
// print 'previous' link only if we're not
// on page one
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = "
[Prev] ";
$first = "
[First Page] ";
}
else
{
$prev = ' [Prev] '; // we're on page one, don't enable 'previous' link
$first = ' [First Page] '; // nor 'first page' link
}
// print 'next' link only if we're not
// on the last page
if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = "
[Next] ";
$last = "
[Last Page] ";
}
else
{
$next = ' [Next] '; // we're on the last page, don't enable 'next' link
$last = ' [Last Page] '; // nor 'last page' link
}
// print the page navigation link
echo $first . $prev . " Showing page
$pageNum of
$maxPage pages " . $next . $last;
if ($maxPage == 0) {
print "
SORRY No record found";
}
?>