how to show table data in page formet


<?php
session_start();
include("_incu/adminconnectdb.php");
include("_incu/func.php");
$realname=veryfy();
include("functions.php");
$id = $_GET['id'];
?>

<?php
if($id!="")
    {
    $query = "DELETE from contact where id='$id'";
$result = mysql_query($query) or die(mysql_error()."Couldn't update record information!");
$_SESSION['msg'] ="One Contact deleted Successfully";
header("Location: adminhome.php");
exit;
    }   ?>
//--------------------page no........................
<?php
//Set the page size
$PageSize =  10;
$StartRow = 0;
//Set the page no
if(empty($_GET['PageNo']))
{
    if($StartRow == 0)
    {
        $PageNo = $StartRow + 1;
    }
}
else
{
    $PageNo = $_GET['PageNo'];
    $StartRow = ($PageNo - 1) * $PageSize;
}
//Set the counter start
if($PageNo % $PageSize == 0){
    $CounterStart = $PageNo - ($PageSize - 1);
}else{
    $CounterStart = $PageNo - ($PageNo % $PageSize) + 1;
}
//Counter End
$CounterEnd = $CounterStart + ($PageSize - 1);
?>
<?php  
//------------------------end----------------------and start for search---------------
  if ( $_POST["funSearch"] != "" )
 
     {
 
if  ( $_POST["category"] != ""  )
         {
       
          $c_id =$_POST['category'];
         $result = "SELECT * FROM contact where cat_id ='$c_id'" ;
         $_SESSION['cate'] = $_POST['category'];
   }

    else
{
$_SESSION['msg'] = "Please Select Your Category";
$result = "SELECT * FROM `contact` where cat_id ='0'";
$_SESSION['cate'] = $_POST['category'];
          }

if ( $result  != "" )
    {
  $searchquery=$result ;
    }
$searchquery1=$searchquery . " ORDER BY ID desc LIMIT $StartRow,$PageSize ";
$searchquery=$searchquery . "   ORDER BY  ID desc ";
     
//echo  $searchquery;
 
   $TRecord = mysql_query($searchquery);


$result = mysql_query($searchquery1);

 }
  //-----------------------------search end--------------------

 else
 {
$TRecord = mysql_query("SELECT * FROM `contact`  ORDER BY  ID desc");
$result = mysql_query("SELECT * FROM `contact`  ORDER BY ID desc LIMIT $StartRow,$PageSize");    }
 //  --------------------- Total of record---------------------
 $RecordCount = mysql_num_rows($TRecord);
 //  ------------------ Set Maximum Page----------------
$MaxPage = $RecordCount % $PageSize;
if($RecordCount % $PageSize == 0){
$MaxPage = $RecordCount / $PageSize;
}else{
$MaxPage = ceil($RecordCount / $PageSize);
 }    ?>
//--------------------------------end------------------------------
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<link href="css/style.css" rel="stylesheet" type="text/css" />
<title>Online Phone Book Software</title>
</head>
<body>
<table border="0" cellpadding="2" cellspacing="1" width="100%">
<?php include("header.php") ?>
<tr>
<td colspan="2" class="header_separator">
<table border="0" cellspacing="0" cellpadding="4" width="100%">
<tr>
<td width="20%" class="menu_separator" valign="top">
 <!-- Menu Links here -->
 <?php include("links.php") ?></td>
<td width="2%" rowspan="2">&nbsp;</td>
<td width="78%" rowspan="2" valign="top" class="gray_bg">
<form action="" method="post" enctype="multipart/form-data" onsubmit="">
<fieldset>
<legend><strong>Search Category By :</strong></legend>

<table width="962" height="232">

<tr>
 <td height="144" colspan="3"><fieldset>

 <table width="961" height="129">
 
   <tr>
     <td width="236" height="30">&nbsp;</td>
     <td width="88" >&nbsp;</td>
     <td width="16">&nbsp;</td>
     <td width="172">&nbsp;</td>
     <td width="222">&nbsp;</td>
     <td width="199">&nbsp;</td>
   </tr>
   <tr>
     <td height="24">&nbsp;</td>
     <td>Category</td>
     <td>&nbsp;</td>
     <td><select name="category">
                            <option value="" <?php if(empty($_SESSION['cate'])){?> selected="selected" <?php }?> >---Select One---</option>
                            <?php $quer = "SELECT * FROM `category`";
   $res = mysql_query($quer) or die(mysql_error()."Couldn't update record information!");
   while ($ro = mysql_fetch_array($res))
{ ?>
<option value="<?php echo $ro['id']; ?>" <?php if($_SESSION['cate']==$ro['id']){?> selected="selected" <?php } ?> ><?php echo $ro['cat_name']; ?></option>
                            <?php } ?>
                          </select></td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
   </tr>
   <tr>
     <td height="24">&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
       </tr>
   <tr>
     <td height="39">&nbsp;</td>
     <td>&nbsp;</td>
     <td>&nbsp;</td>
     <td><input  type="hidden"   name="funSearch" value="1" />
         <input type="submit" name="Search" value="Search" /></td>
     <td><font color="red"><?php echo $msg=$_SESSION['msg']; session_unset($_SESSION['msg']) ?></font></td>
     <td>&nbsp;</td>
       </tr>
   </table>
 </fieldset></td>
 </tr>
<tr>
 <td width="960" height="80" colspan="3">
 <fieldset>
 <table width="100%"  border="0" align="center" cellpadding="3" cellspacing="0">
      <tr bgcolor="#EBEBEB">
        <td width="5%"><div align="left"><strong>S.No</strong></div></td>
        <td width="18%"><div align="left"><strong>Contact Person </strong></div></td>
<td width="18%"><div align="left"><strong>Address</strong></div></td>
<td width="12%"><div align="left"><strong>City</strong></div></td>
<td width="10%"><div align="left"><strong>State</strong></div></td>
        <td width="14%"><div align="left"><strong>Mobile</strong></div></td>
<td width="13%"><div align="left"><strong>Email</strong></div></td>
<td width="10%"><div align="center"><strong>Action</strong></div></td>
 </tr>
 <?php   //-----------------start data fetch--------------------
$i=1;
while($row = mysql_fetch_array($result))
{
$bil = $i + ($PageNo-1)*$PageSize;
  ?>
       <tr>
        <td><div align="center"><?php echo $bil; ?></div></td>
<td><div align="left"><?php echo $row['firstname']; ?></div></td>
<td><div align="left"><?php echo $row['address1']; ?></div></td>
<td><div align="left"><?php echo $row['city']; ?></div></td>
<td><div align="left"><?php echo $row['state']; ?></div></td>
<td><div align="left"><?php echo $row['mobile1']; ?></div></td>  
<td><div align="left"><?php echo $row['email1']; ?></div></td>
        <td><div align="center"><a href="add-contact.php?id=<?php echo $row['id']; ?>">Edit </a >/<a href="adminhome.php?id=<?php echo $row['id']; ?>"> Delete</a></div></td>
</tr>
     <?php  $i++;} ?>  //--------------------------end of data fetch----------
      <tr align="center" bgcolor="#EBEBEB">
        <td colspan="8">    </td>
        </tr>
    </table>
 </fieldset>
 </td>
 </tr>
         </table>
</fieldset></form>
//-----------------------------start of numbering-------------------------
Page(s):  <?php
        //Print First & Previous Link is necessary
        if($CounterStart != 1){
            $PrevStart = $CounterStart - 1;
            print "<a href=search_category.php?PageNo=1>First</a>&nbsp;";
            print "<a href=search_category.php?PageNo=$PrevStart>Previous</a>";
        }
        print " [ ";
        $c = 0;

        //Print Page No
        for($c=$CounterStart;$c<=$CounterEnd;$c++){
            if($c < $MaxPage){
                if($c == $PageNo){
                    if($c % $PageSize == 0){
                        print "$c ";
                    }else{
                        print "$c | ";
                    }
                }elseif($c % $PageSize == 0){
                    echo "<a href=search_category.php?PageNo=$c>$c</a> ";
                }else{
                    echo "<a href=search_category.php?PageNo=$c>$c</a> | ";
                }//END IF
            }else{
                if($PageNo == $MaxPage){
                    print "$c ";
                    break;
                }else{
                    echo "<a href=search_category.php?PageNo=$c>$c</a> ";
                    break;
                }//END IF
            }//END IF
       }//NEXT

      echo "] ";

      if($CounterEnd < $MaxPage){
          $NextPage = $CounterEnd + 1;
          echo "<a href=search_category.php?PageNo=$NextPage>Next</a>";
      }
     
      //Print Last link if necessary
      if($CounterEnd < $MaxPage){
       $LastRec = $RecordCount % $PageSize;
        if($LastRec == 0){
            $LastStartRecord = $RecordCount - $PageSize;
        }
        else{
            $LastStartRecord = $RecordCount - $LastRec;
        }

        print " ";
        echo "<a href=search_category.php?PageNo=$MaxPage>Last</a>";
        }
      ?>
//-----------------------end----------------------------------

</td>
</tr>
<tr>
 <td class="menu_separator" valign="top">
 <!-- Menu Links here -->
 <!-- end Menu Links here --></td>
 </tr>
</table>
</td>
</tr>
<tr>
<?php include("footer.php") ?>
</tr>
</table>
</body>
</html>

Comments

Post a Comment

Popular Posta

How to enable .htaccess in wamp server

Image
How to enable .htaccess in wamp server In this article,I will explain how  to enable  . htaccess  in wamp server. 1 .  Open wamp_server   (Go to  Wamp  -> Right click at icon in the taskbar=>  Apache =>  httpd.conf ) 2.Edit httpd.conf file. 3 . Just remove the # sign before the  LoadModule  rewrite_module modules/mod_rewrite.so  4 .  Save  the file .Mod Rewriting is enabled. 5.Restart the Server (Go to  Wamp  -> Right click at icon in the taskbar=>  Restart All services ) 6 . Now Create new file. Copy and paste the following code in it. Options +FollowSymLinks RewriteEngine On 7 .Save it as  .htaccess  in the root directory. 8 .Done. We have successfully enabled .htaccess in Wamp server.
Read more

Web Scraping Amazon with PHP

This snippet of PHP code demonstrates web scraping. It reads a sample page from Amazon.com, compares the HTML text against certain class name and outputs that matched text in an RSS feed.  <?php  $now   = date("D, d M Y H:i:s T"); $ASIN  = $url = $img = $title = $bio = $name = ""; $head = '<?xml version="1.0" encoding="ISO-8859-1"?>'; $head .= '<rss version="2.0">'; $head .= '<channel>'; $head .= '<title>Amazon </title>'; $head .= '<link>http://www.amazon.com</link>'; $head .= '<description>Amazon RSS Feed</description>'; $url = "http://www.amazon.com/Best-Sellers-Kindle-Store/zgbs/digital-text/"; $text = file_get_html($url); foreach ($text->find("div.zg_item_compact") as $class) {   foreach ($class->find('strong.price') as $price) {     if ($price->plaintext == "Free...
Read more

Disable right click script and Google Instant Map Search

<!DOCTYPE html created my solomon  > <html>     <head>         <meta name="viewport" content="initial-scale=1.0, user-scalable=no"/>         <meta http-equiv="content-type" content="text/html; charset=UTF-8"/>         <title>Google Instant Map Search | spixup- demo </title>         <style type="text/css">             #map_canvas{                 height: 400px;                 width: 500px;                 margin: 5px auto;             }      </style>     </head>     <body> <SCRIPT TYPE="text/javascript"> //-------------Disable right click script ------------ //visit http://www.rainbow.arch.scr...
Read more