Code: Select all
If ($category == "About"){
include("../include/about.php");
}
Else{
@ $rpp; //Records Per Page
@ $cps; //Current Page Starting row number
@ $lps; //Last Page Starting row number
@ $a; //will be used to print the starting row number that is shown in the page
@ $b; //will be used to print the ending row number that is shown in the page
/////////////////////////////////////////////////////////////////////////////////
//Database connection
/////////////////////////////////////////////////////////////////////////////////
include("../include/opendbconnection.php");
/////////////////////////////////////////////////////////////////////////////////
//Following IF Statement is used to make sure when the page is loaded for the
//first time, Current Page's Starting row number is 0, i.e. 1st row from the
//table is being printed. It will change as the user will click on next.
/////////////////////////////////////////////////////////////////////////////////
$alpha = $_GET['alpha'];
if(empty($_GET["cps"]))
{
$cps = "0";
}
else
{
$cps = $_GET["cps"];
}
/////////////////////////////////////////////////////////////////////////////////
$a = $cps+1;
$rpp = "10";
$lps = $cps - $rpp; //Calculating the starting row number for previous page
/////////////////////////////////////////////////////////////////////////////////
//Following IF Statement is used to make sure whether a link to Previous page is
//needed or not. If the user is viewing the first set of data then the link will
//be disabled, if on the next set then it will carry the $lps in its link and
//enable the link
if ($cps <> 0)
{
$prv = "<a href='menuview.php?category=$category&alpha=$alpha&cps=$lps'>Previous</a>";
}
else
{
$prv = "<font color='cccccc'>Previous</font>";
}
/////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////
//Following SQL Statement uses SQL_CALC_FOUND_ROWS function to calculate total
//number of rows found by the query excluding the limit function added at the
//end of the SQL statement. This is followed by second query with FOUND_ROWS()
//function which actually gives out the number of rows found.
/////////////////////////////////////////////////////////////////////////////////
$alpha = $_GET['alpha'];
If (($category == "All") AND ($alpha == "")){
$q="Select SQL_CALC_FOUND_ROWS * from tbl_restaurantinfo ORDER BY name limit $cps, $rpp";
}
ElseIf (($category != "ALL") AND ($alpha == ""))
{
$q="Select SQL_CALC_FOUND_ROWS * from tbl_restaurantinfo WHERE category='".$category."' ORDER BY name limit $cps, $rpp";
}
Else{
$q="Select SQL_CALC_FOUND_ROWS * FROM tbl_restaurantinfo Where name Like '$alpha' ORDER BY name limit $cps, $rpp";
}
$rs=mysql_query($q) or die(mysql_error());
$nr = mysql_num_rows($rs); //Number of rows found with LIMIT in action
$q0="Select FOUND_ROWS()";
$rs0=mysql_query($q0) or die(mysql_error());
$row0=mysql_fetch_array($rs0);
$nr0 = $row0["FOUND_ROWS()"]; //Number of rows found without LIMIT in action
/////////////////////////////////////////////////////////////////////////////////
//Following IF Statement is used to determine whether the user has reached the
//last page of the records. For example, if we have 27 rows to print and we show
//10 rows per page, then on the third and the last page it will show seven rows
//and will say at the top that SHOWING RECORDS FROM 21 to 27. If the following
//validator is not used then it shows SHOWING RECORDS FROM 21 to 30.
/////////////////////////////////////////////////////////////////////////////////
if (($nr0 < 10) || ($nr < 10))
{
$b = $nr0;
}
else
{
$b = ($cps) + $rpp;
}
/////////////////////////////////////////////////////////////////////////////////
?>
<table class="contacts" cellspacing="0">
<tr><th class="contact"><? echo "$nr0 $menuheader Restaurants Found. "; ?> <? echo "Showing $a thru $b"; ?></th></tr>
<?php
while ($row=mysql_fetch_array($rs))
{
/////////////////////////////////////////////////////////////////////////////////
//This is used to show the serial number on the page as well as to count it up
//so that we can get the next page's starting row number when it exits the while
//loop after fullfilling the above SQL criteria.
/////////////////////////////////////////////////////////////////////////////////
$cps = $cps +1;
//$val=$row["name"];
echo "<tr>";
echo "<td class='contact'><b>" . $row['name'] . "</b>";
echo "<br />" . $row['category'];
echo "<br />" . $row['address'];
echo "<br />" . $row['phone'];
echo '<br /><a href="' . $row['menu'] . '" target="_blank">Menu</a>';
echo '<br /><a href="' . $row['map'] . '" target="_blank">Map</a>';
/*echo "<br /><a href=" . chr(34) . $row['review'] . chr(34) . ">Reviews</a>";*/
echo '<br /><a href="' . $row['website'] . '" target="_blank">Website</a></td>';
echo "</tr>";
//echo "<tr><td align='center'><font face=verdana>$cps</font></td><td align='center'><font fave=verdana>$val</font></td></tr>";
}
echo "<tr><td align='right' class='contact'>$prv";
/////////////////////////////////////////////////////////////////////////////////
//Following IF Statement is used to determine whether the Next link will be
//enabled or disabled. If the user has reached the last page of the record, then
//the Next link will be disabled.
/////////////////////////////////////////////////////////////////////////////////
if ($cps == $nr0)
{
echo " | <font color='CCCCCC'>Next</font>";
}
else
{
if ($nr0 > 10)
{
echo " | <a href='menuview.php?category=$category&alpha=$alpha&cps=$cps&lps=$lps'>Next</a>";
}
}
/////////////////////////////////////////////////////////////////////////////////
?>
</td>
</tr>
</table>
<?php } ?>Not even sure where to start on this one. Any help would be greatly appreciated.