Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //Simple Paging data PHP Mysql
- // Heru Rahmat Akhnuari
- // http://www.ilmuprogrammer.com
- //paging.php
- <style>
- .pagin {
- padding: 10px 0;
- font:bold 11px/30px arial, serif;
- }
- .pagin * {
- padding: 2px 6px;
- color:#0A7EC5;
- margin: 2px;
- border-radius:3px;
- }
- .pagin a {
- border:solid 1px #8DC5E6;
- text-decoration:none;
- background:#F8FCFF;
- padding:6px 7px 5px;
- }
- .pagin span, a:hover, .pagin a:active,.pagin span.current {
- color:#FFFFFF;
- background:-moz-linear-gradient(top,#B4F6FF 1px,#63D0FE 1px,#58B0E7);
- }
- .pagin span,.current{
- padding:8px 7px 7px;
- }
- .content{
- padding:10px;
- font:bold 12px/30px gegoria,arial,serif;
- border:1px dashed #0686A1;
- border-radius:5px;
- background:-moz-linear-gradient(top,#E2EEF0 1px,#CDE5EA 1px,#E2EEF0);
- margin-bottom:10px;
- text-align:left;
- line-height:20px;
- }
- .outer_div{
- margin:auto;
- width:600px;
- }
- #loader{
- position: absolute;
- text-align: center;
- top: 75px;
- width: 100%;
- display:none;
- }
- </style>
- <?php
- function paginate($reload, $page, $tpages, $adjacents) {
- $prevlabel = "‹ Prev";
- $nextlabel = "Next ›";
- $out = '<div class="pagin green">';
- if($page==1) {
- $out.= "<span>$prevlabel</span>";
- } else if($page==2) {
- $out.= "<a href='".$reload."page=".($page-1)."'>$prevlabel</a>";
- }else {
- $out.= "<a href='".$reload."page=".($page-1)."'>$prevlabel</a>";
- }
- if($page>($adjacents+1)) {
- $out.= "<a href='".$reload."page=1'>1</a>";
- }
- if($page>($adjacents+2)) {
- $out.= "...\n";
- }
- $pmin = ($page>$adjacents) ? ($page-$adjacents) : 1;
- $pmax = ($page<($tpages-$adjacents)) ? ($page+$adjacents) : $tpages;
- for($i=$pmin; $i<=$pmax; $i++) {
- if($i==$page) {
- $out.= "<span>$i</span>";
- }else if($i==1) {
- $out.= "<a href='".$reload."page=$i'>$i</a>";
- }else {
- $out.= "<a href='".$reload."page=$i'>$i</a>";
- }
- }
- if($page<($tpages-$adjacents-1)) {
- $out.= "...\n";
- }
- if($page<($tpages-$adjacents)) {
- $out.= "<a href='".$reload."page=$tpages'>$tpages</a>";
- }
- if($page<$tpages) {
- $out.= "<a href='".$reload."page=".($page+1)."'>$nextlabel</a>";
- }else {
- $out.= "<span>$nextlabel</span>";
- }
- $out.= "</div>";
- return $out;
- }
- ?>
- /////viewdata.php//////////
- $page = (isset($_REQUEST['page']) && !empty($_REQUEST['page']))?$_REQUEST['page']:1;
- $sql1="Select count(id_user) as numrows from userlogin";
- $sql2="Select * from userlogin";
- $per_page = 3;
- $adjacents = 3;
- $offset = ($page - 1) * $per_page;
- $qCount=mysql_query($sql1);
- $row = mysql_fetch_array($qCount);
- $numrows = $row['numrows'];
- $total_pages = ceil($numrows/$per_page);
- $querydata = mysql_query($sql2." LIMIT $offset,$per_page");
- <table width="100%" border="0" cellspacing="0" cellpadding="0" class="table table-striped">
- <tr>
- <td>Username</td>
- <td>Password</td>
- </tr>
- <?php
- while($s=mysql_fetch_array($querydata))
- {
- ?>
- <tr>
- <td><?php echo $s['username_field']; ?></td>
- <td><?php echo $s['password_field']; ?></td>
- </tr>
- <?php
- }
- ?>
- </table>
- echo paginate("?mod=user&", $page, $total_pages, $adjacents);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement