0
<?php
include"header.php";
if(empty($_SESSION['UserName'])){
header("Location: http://localhost:1234/city"); 
exit;}

 $result = mysql_query("SELECT * FROM menu");

echo "<td><a href='http://localhost:1234/city/menu_update_insert.php'>
        <img src='images/create.png'>Add New Record</a>   </td>";
        echo "<table border='0'>

<tr class='tableheader'>
    <th>PageName</th>
    <th>MenuName</th>
    <th>ParentMenuId</th>
    <th>LinkWidth</th>
    <th>OtherUrl</th>
    <th>Status</th>
    <th>CreatedDate</th>
    <th>OnMainMenu</th>
    <th>FooterMenu</th>
</tr>";
while($row = mysql_fetch_array($result)) {
        echo "<tr class='tablerow'>";
        $rpId=$row['PageID'];
        $result1=mysql_query("SELECT * FROM page WHERE ID=$rpId  ");
        $row1=mysql_fetch_array($result1);
        if ($row['PageID'] == $row1['ID'])
        echo "<td>" . $row1['Title']     . "</td>";
        else if($row['PageID'] == '0')
        echo "<td>Null</td>";
        echo "<td>" . $row['MenuName']       . "</td>";
        $parentmenuId=$row['ParentMenuID'];
        $result2=mysql_query("SELECT * From menu WHERE ID=$parentmenuId");
        $row2=mysql_fetch_array($result2);
        if($row['ParentMenuID'] == '0')
        echo "<td>Null</td>";
        else
        echo "<td>" . $row2['MenuName']      . "</td>";
        echo "<td>" . $row['LinkWidth']  . "</td>";
        if ($row['OtherUrl'] =='')
        echo "<td>Null</td>";
        else if($row['OtherUrl'] != '0')
        echo "<td>" . $row['OtherUrl']       . "</td>";
        if($row['Status'] == '1')
        echo  "<td>active</td>";
        else if($row['Status']=='0')
        echo "<td>deactive</td>";
        echo "<td>" . $row['CreatedDate'] . "</td>";
        if($row['OnMainMenu'] == '1')
        echo  "<td>Yes</td>";
        else if($row['OnMainMenu']=='0')
        echo "<td>No</td>";
        if($row['FooterMenu'] == '1')
        echo  "<td>Yes</td>";
        else if($row['FooterMenu']=='0')
        echo "<td>No</td>";
        $query_sting = "Id={$row['ID']}";
        $url1="http://localhost:1234/city/menu_update_insert.php?".$query_sting;
        echo "<td><a href='$url1'><img src='images/UPDATE.png'></a></td>";
        $query_sting = "Id={$row['ID']}";
        $url = "http://localhost:1234/city/menu_delete.php?". $query_sting;
        echo "<td><a href='$url' onclick='return checkDelete()'><img src='images/DELETE.png'  ></a></td>";
        echo "</tr>";
        }
        echo "</table>";
include"footer.php";        
?>

want to add pagination in it

<?php
include "connection.php";
//////////////  QUERY THE MEMBER DATA INITIALLY LIKE YOU NORMALLY WOULD
$sql = mysql_query("SELECT * FROM menu ORDER BY ID ASC");
//////////////////////////////////// Adam's Pagination Logic ////////////////////////////////////////////////////////////////////////
$nr = mysql_num_rows($sql); // Get total of Num rows from the database query
if (isset($_GET['pn'])) { // Get pn from URL vars if it is present
$pn = preg_replace('#[^0-9]#i', '', $_GET['pn']); // filter everything but numbers for security(new)
//$pn = ereg_replace("[^0-9]", "", $_GET['pn']); // filter everything but numbers for security(deprecated)
} else { // If the pn URL variable is not present force it to be value of page number 1
$pn = 1;
} 
//This is where we set how many database items to show on each page 
$itemsPerPage = 5; 
// Get the value of the last page in the pagination result set
$lastPage = ceil($nr / $itemsPerPage);
// Be sure URL variable $pn(page number) is no lower than page 1 and no higher than $lastpage
if ($pn < 1) { // If it is less than 1
$pn = 1; // force if to be 1
} else if ($pn > $lastPage) { // if it is greater than $lastpage
$pn = $lastPage; // force it to be $lastpage's value
} 
// This creates the numbers to click in between the next and back buttons
// This section is explained well in the video that accompanies this script
$centerPages = "";
$sub1 = $pn - 1;
$sub2 = $pn - 2;
$add1 = $pn + 1;
$add2 = $pn + 2;
if ($pn == 1) {
$centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
$centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
} else if ($pn == $lastPage) {
$centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
$centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
} else if ($pn > 2 && $pn < ($lastPage - 1)) {
$centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub2 . '">' . $sub2 . '</a> &nbsp;';
$centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
$centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
$centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
$centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add2 . '">' . $add2 . '</a> &nbsp;';
} else if ($pn > 1 && $pn < $lastPage) {
$centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $sub1 . '">' . $sub1 . '</a> &nbsp;';
$centerPages .= '&nbsp; <span class="pagNumActive">' . $pn . '</span> &nbsp;';
$centerPages .= '&nbsp; <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $add1 . '">' . $add1 . '</a> &nbsp;';
}
// This line sets the "LIMIT" range... the 2 values we place to choose a range of rows from database in our query
$limit = 'LIMIT ' .($pn - 1) * $itemsPerPage .',' .$itemsPerPage; 
// Now we are going to run the same query as above but this time add $limit onto the end of the SQL syntax
// $sql2 is what we will use to fuel our while loop statement below
$sql2 = mysql_query("SELECT * FROM menu ORDER BY ID ASC $limit"); 
//////////////////////////////// END Adam's Pagination Logic ////////////////////////////////////////////////////////////////////////////////
///////////////////////////////////// Adam's Pagination Display Setup /////////////////////////////////////////////////////////////////////
$paginationDisplay = ""; // Initialize the pagination output variable
// This code runs only if the last page variable is ot equal to 1, if it is only 1 page we require no paginated links to display
if ($lastPage != "1"){
// This shows the user what page they are on, and the total number of pages
$paginationDisplay .= 'Page <strong>' . $pn . '</strong> of ' . $lastPage. '&nbsp;  &nbsp;  &nbsp; ';
// If we are not on page 1 we can place the Back button
if ($pn != 1) {
  $previous = $pn - 1;
  $paginationDisplay .=  '&nbsp;  <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $previous . '"> Back</a> ';
} 
// Lay in the clickable numbers display here between the Back and Next links
$paginationDisplay .= '<span class="paginationNumbers">' . $centerPages . '</span>';
// If we are not on the very last page we can place the Next button
if ($pn != $lastPage) {
  $nextPage = $pn + 1;
  $paginationDisplay .=  '&nbsp;  <a href="' . $_SERVER['PHP_SELF'] . '?pn=' . $nextPage . '"> Next</a> ';
} 
}
///////////////////////////////////// END Adam's Pagination Display Setup ///////////////////////////////////////////////////////////////////////////
// Build the Output Section Here
$outputList = '';
while($row = mysql_fetch_array($sql2)){ 

$id             =$row["ID"];
$Menuname       =$row["MenuName"];
$CreatedDate    =$row["CreatedDate"];
$linkWidth      =$row["LinkWidth"];
$status         =$row["Status"];
$outputList .= '<h2>MenuName : ' . $Menuname . '</h2><p>Date : ' . $CreatedDate . ' </p><p>LinkWidth : ' . $linkWidth .
'</p><hr />';

} // close while loop
?>
<html>
<head>
<title> Pagination</title>
<style type="text/css">
<!--
.pagNumActive {
color: #000;
border:#060 1px solid; background-color: #D2FFD2; padding-left:3px; padding-right:3px;
}
.paginationNumbers a:link {
color: #000;
text-decoration: none;
border:#999 1px solid; background-color:#F0F0F0; padding-left:3px; padding-right:3px;
}
.paginationNumbers a:visited {
color: #000;
text-decoration: none;
border:#999 1px solid; background-color:#F0F0F0; padding-left:3px; padding-right:3px;
}
.paginationNumbers a:hover {
color: #000;
text-decoration: none;
border:#060 1px solid; background-color: #D2FFD2; padding-left:3px; padding-right:3px;
}
.paginationNumbers a:active {
color: #000;
text-decoration: none;
border:#999 1px solid; background-color:#F0F0F0; padding-left:3px; padding-right:3px;
}
-->
</style>
</head>
<body>
<div style="margin-left:64px; margin-right:64px;">
<h2>Total Detail: <?php echo $nr; ?></h2>
</div> 
<div style="margin-left:58px; margin-right:58px; padding:6px; background-color:#FFF; border:#999 1px solid;"><?php echo $paginationDisplay; ?></div>
<div style="margin-left:64px; margin-right:64px;"><?php print "$outputList"; ?></div>
<div style="margin-left:58px; margin-right:58px; padding:6px; background-color:#FFF; border:#999 1px solid;"><?php echo $paginationDisplay; ?></div>
</body>
</html>

pleasehelp me out

3
Contributors
2
Replies
25
Views
3 Years
Discussion Span
Last Post by rpv_sen
This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.