Paginate i using reference website at this link : http://www.techumber.com/2012/
ID: 3552796 • Letter: P
Question
Paginate i using reference website at this link : http://www.techumber.com/2012/08/simple-pagination-with-php-mysql.html
mysql query is using inner join with 3 table, and i want show 20 record in one page include(`Client Code` as GuestCode, CMDextras.ArrivalDate as arr, CMDextras.DepartureDate as dep, CMDapr.FirstName as fname, CMDapr.Surname as lname, CMDextras.TRXDescription as tdescription )
In database have 5000 record.
Can help solve my code and explain error using comment?
Thank you.
Code:
(INDEX.PHP)
<?php
include('config.php');
include('pagination.php');
?>
<html>
<head>
<link rel="stylesheet" href="mystylesheet2.css" type="text/css">
</head>
<body>
<?php
$per_page=20;
$query=("
SELECT DISTINCT CMDclient.`Client Code` as GuestCode, CMDextras.ArrivalDate as arr, CMDextras.DepartureDate as dep, CMDapr.FirstName as fname, CMDapr.Surname as lname, CMDextras.TRXDescription as tdescription
FROM CMDclient
INNER JOIN CMDextras ON (CMDclient.`Client Code CLMAIN`=CMDextras.GuestCode)
INNER JOIN CMDapr ON (CMDapr.GuestCode=CMDextras.GuestCode)
LIMIT 0,100");
$fetch=mysql_query($query)or die("cannot");
$total_result=mysql_num_rows($fetch);
$total_pages=ceil($total_result/$per_page);
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 result
$start=0;
$end=$per_page;
}
}
else
{
$start=0;
$end=$per_page;
}
$page=intval($_GET['page']);
$tpages=$total_pages;
if($page<=0)
$page=1;
?>
<?php
$reload=$_SERVER['PHP_SELF']."?tpages=" . $tpages;
echo '<div class="pagination"><ul>';
if($totalpages>1)
{
echo paginate($reload, $show_page, $total_pages);
}
echo "</ul></div>";
for($i=$start; $i<$end; $i++)
{
if($i==$total_result)
{
break;
}
echo "<table>";
// echo out the contents of each row into a table
echo "<tr>";
echo '<td>' . mysql_result($result, $i, 'GuestCode') . '</td>';
echo '<td>' . mysql_result($result, $i, 'arr') . '</td>';
echo '<td>' . mysql_result($result, $i, 'dep') . '</td>';
echo '<td>' . mysql_result($result, $i, $FinalName) . '</td>';
echo '<td>' . mysql_result($result, $i, 'tdescription') . '</td>';
echo "</tr>";
}
// close table>
echo "</table>";
?>
</table>
</body>
</html>
(PAGINATE.PHP)
<?php
function paginate($reload, $page, $tpages) {
$adjacents = 2;
$prevlabel = "‹ Prev";
$nextlabel = "Next ›";
$out = "";
// previous
if ($page == 1) {
$out.= "<span>".$prevlabel."</span> ";
} elseif ($page == 2) {
$out.="<li><a href="".$reload."">".$prevlabel."</a> </li>";
} else {
$out.="<li><a href="".$reload."&page=".($page - 1)."">".$prevlabel."</a> </li>";
}
$pmin=($page>$adjacents)?($page - $adjacents):1;
$pmax=($page<($tpages - $adjacents))?($page + $adjacents):$tpages;
for ($i = $pmin; $i <= $pmax; $i++) {
if ($i == $page) {
$out.= "<li class="active"><a href="">".$i."</a></li> ";
} elseif ($i == 1) {
$out.= "<li><a href="".$reload."">".$i."</a> </li>";
} else {
$out.= "<li><a href="".$reload. "&page=".$i."">".$i. "</a> </li>";
}
}
if ($page<($tpages - $adjacents)) {
$out.= "<a href="" . $reload."&page=".$tpages."">" .$tpages."</a> ";
}
// next
if ($page < $tpages) {
$out.= "<li><a href="".$reload."&page=".($page + 1)."">".$nextlabel."</a> </li>";
} else {
$out.= "<span>".$nextlabel."</span> ";
}
$out.= "";
return $out;
}
?>
Explanation / Answer
#include int main() { int red,green; printf(" red :"); scanf("%d",&red); printf(" green :"); scanf("%d",&green); if ( red ){ printf(" Stop %d ",red); } else{ printf("Pass the road - %d ",green); } return 0; }Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.