# EXAMPLE USAGE: fun_rs_navigation($mysql_link,$users_query,$PHP_SELF,$offset,$limit,'75%',0); #
# &$db_connect is the MySQL connection passed by reference #
# $db_query is your entire query string including WHERE criteria and ORDER BY - without the LIMIT statement! #
# $page_url will probably always be $PHP_SELF #
# $tablewidth determines the width of the $navstring table #
# $verbiage, by default set to 'true', prints out "page:$pagenumber/$totalpages total records:$totalrecords" #
function fun_rs_selfdefine(&$db_connect,$db_query,$page_url,$offset,$pagesize,$tablewidth,$verbiage,$range,$text1,$text2,$style)
{
$db_result = @mysql_query($db_query,$db_connect);
$totalrecords = @mysql_num_rows($db_result);
$pagenumber = (int)(($offset + $pagesize) / $pagesize);
$totalpages = intval($totalrecords/$pagesize);
$showpage = 2 * $range + 1;
if ($totalrecords%$pagesize > 0) $totalpages++;
$navstring = "";
// start building navigation string
// echo "offset=" . $offset . "
";
// echo "i=" . $i . "
";
// echo "pagenumber=" . $pagenumber . "
";
// echo "offset=" . $offset . "
";
$navstring = "
";
if ($totalpages <$showpage ) {
if ($totalrecords > $pagesize) // only show <> row if $totalrecords is greater than $pagesize
{
$navstring .= "| ";
if ($pagenumber > 1)
{
$navstring .= "上一頁 ";
}
for ($i=1;$i<=$totalpages;$i++)
{
if ($i==$pagenumber)
{
$navstring .= "" .$i ." ";
} else {
$nextoffset = $pagesize * ($i-1);
$navstring .= "$i ";
}
}
if($totalrecords-$offset < $pagesize)
{
$navstring .= " | ";
} else {
$navstring .= "下一頁";
}
}
} else {
if ($totalrecords > $pagesize) // only show <> row if $totalrecords is greater than $pagesize
{
$navstring .= "| ";
if (($pagenumber > 1) && ($offset-$pagesize) >= 0)
{
$navstring .= "上一頁 ";
}
$displayfrom = (int)($pagenumber) - (int)($range);
$displayto = (int)($pagenumber) + (int)($range);
if ($displayfrom <= 0) {
$displayfrom=1;
$displayto=$showpage;
}
if ($displayto > $totalpages ) {
$displayto = $totalpages;
$displayfrom = $totalpages - 2 * $range;
}
for ($i=$displayfrom;$i<=$displayto;$i++)
{
if ($i==$pagenumber )
{
$navstring .= "" .$i ." "; ;
} else {
$nextoffset = $pagesize * ($i-1);
$navstring .= "$i ";
}
}
if($totalrecords-$offset < $pagesize)
{
$navstring .= " | ";
} else {
$navstring .= "下一頁";
}
}
}
// $navstring .= "
";
if ($verbiage)
{
$navstring .= "";
$navstring .= "第 ".$pagenumber."/".$totalpages . " 頁 ";
$navstring .= $text1 . $totalrecords .$text2;
$navstring .= " | ";
}
$navstring .= "
";
echo $navstring;
}
// fun_rs_navigation($mysql_link,$users_query,$PHP_SELF,$offset,$pagesize,'100%',1);
function fun_rs_list(&$db_connect,$db_query,$page_url,$offset,$pagesize,$tablewidth,$verbiage,$range,$a1,$a2,$a3,$a4,$a5,$a6)
{
$db_result = @mysql_query($db_query,$db_connect);
$totalrecords = @mysql_num_rows($db_result);
$pagenumber = (int)(($offset + $pagesize) / $pagesize);
$totalpages = intval($totalrecords/$pagesize);
$showpage = 2 * $range + 1;
if ($totalrecords%$pagesize > 0) $totalpages++;
$navstring = "";
$page_urlT=(strpos($page_url, '?')) ? "&" : "?";
$page_url =$page_url . $page_urlT;
// start building navigation string
// echo "offset=" . $offset . "
";
// echo "i=" . $i . "
";
// echo "pagenumber=" . $pagenumber . "
";
// echo "offset=" . $offset . "
";
$navstring = "";
if ($totalpages <$showpage ) {
if ($totalrecords > $pagesize) // only show <> row if $totalrecords is greater than $pagesize
{
$navstring .= "| ";
if ($pagenumber > 1)
{
$navstring .= "上一頁 ";
}
for ($i=1;$i<=$totalpages;$i++)
{
if ($i==$pagenumber)
{
$navstring .= "" .$i ." ";
} else {
$nextoffset = $pagesize * ($i-1);
$navstring .= "$i ";
}
}
if($totalrecords-$offset < $pagesize)
{
$navstring .= " | ";
} else {
$navstring .= "下一頁";
}
}
} else {
if ($totalrecords > $pagesize) // only show <> row if $totalrecords is greater than $pagesize
{
$navstring .= "| ";
if (($pagenumber > 1) && ($offset-$pagesize) >= 0)
{
$navstring .= "上一頁 ";
}
$displayfrom = (int)($pagenumber) - (int)($range);
$displayto = (int)($pagenumber) + (int)($range);
if ($displayfrom <= 0) {
$displayfrom=1;
$displayto=$showpage;
}
if ($displayto > $totalpages ) {
$displayto = $totalpages;
$displayfrom = $totalpages - 2 * $range;
}
for ($i=$displayfrom;$i<=$displayto;$i++)
{
if ($i==$pagenumber )
{
$navstring .= "" .$i ." "; ;
} else {
$nextoffset = $pagesize * ($i-1);
$navstring .= "$i ";
}
}
if($totalrecords-$offset < $pagesize)
{
$navstring .= " | ";
} else {
$navstring .= "下一頁";
}
}
}
// $navstring .= "
";
if ($verbiage)
{
$navstring .= "";
$navstring .= "第 ".$pagenumber."/".$totalpages . " 頁 ";
$navstring .= "搜尋結果:共有" . $totalrecords . "家餐廳";
$navstring .= " | ";
}
$navstring .= "
";
echo $navstring;
}
function fun_rs_navigation(&$db_connect,$db_query,$page_url,$offset,$pagesize,$tablewidth,$verbiage,$range, $pagnation_align)
{
if ($pagesize==0){$pagesize=1;}
$db_result = @mysql_query($db_query,$db_connect);
$totalrecords = @mysql_num_rows($db_result);
$pagenumber = (int)(($offset + $pagesize) / $pagesize);
$totalpages = intval($totalrecords/$pagesize);
$showpage = 2 * $range + 1;
if ($totalrecords%$pagesize > 0) $totalpages++;
$navstring = "";
// start building navigation string
// echo "offset=" . $offset . "
";
// echo "i=" . $i . "
";
// echo "pagenumber=" . $pagenumber . "
";
// echo "offset=" . $offset . "
";
$navstring = "";
if ($totalpages <$showpage ) {
if ($totalrecords > $pagesize) // only show <> row if $totalrecords is greater than $pagesize
{
$navstring .= "| ";
if ($pagenumber > 1)
{
$navstring .= "previous ";
}
for ($i=1;$i<=$totalpages;$i++)
{
if ($i==$pagenumber)
{
$navstring .= "" .$i ." ";
} else {
$nextoffset = $pagesize * ($i-1);
$navstring .= "$i ";
}
}
if($totalrecords-$offset < $pagesize)
{
$navstring .= " | ";
} else {
$navstring .= "next";
}
}
} else {
if ($totalrecords > $pagesize) // only show <> row if $totalrecords is greater than $pagesize
{
$navstring .= "| ";
if (($pagenumber > 1) && ($offset-$pagesize) >= 0)
{
$navstring .= "previous ";
}
$displayfrom = (int)($pagenumber) - (int)($range);
$displayto = (int)($pagenumber) + (int)($range);
if ($displayfrom <= 0) {
$displayfrom=1;
$displayto=$showpage;
}
if ($displayto > $totalpages ) {
$displayto = $totalpages;
$displayfrom = $totalpages - 2 * $range;
}
for ($i=$displayfrom;$i<=$displayto;$i++)
{
if ($i==$pagenumber )
{
$navstring .= "" .$i ." "; ;
} else {
$nextoffset = $pagesize * ($i-1);
$navstring .= "$i ";
}
}
if($totalrecords-$offset < $pagesize)
{
$navstring .= " | ";
} else {
$navstring .= "next";
}
}
}
// $navstring .= "
";
if ($verbiage)
{
$navstring .= "";
$navstring .= "Page ".$pagenumber."/".$totalpages . " ";
$navstring .= "Total Posts:" . $totalrecords;
$navstring .= " | ";
}
$navstring .= "
";
echo $navstring;
}
// fun_rs_navigation($mysql_link,$users_query,$PHP_SELF,$offset,$pagesize,'100%',1);