Advertisement
Guest User

Untitled

a guest
Jun 28th, 2017
106
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.01 KB | None | 0 0
  1. <?php
  2.         require SIMBIO_BASE_DIR.'simbio_GUI/paging/simbio_paging.inc.php';
  3.  
  4.         $items = 3;
  5.         $page = isset($_GET['page']) ? $_GET['page'] : 1;
  6.         $paged = ($page - 1) * $items;
  7.         $table = "biblio";
  8.         $sql = "SELECT * FROM `%s`";
  9.         $sql_all = sprintf($sql, $table);
  10.         $sql_cur = sprintf(
  11.             $sql
  12.             . " LIMIT $paged, $items"
  13.             , $table);
  14.         echo ($sql_cur);
  15.         $items_all = $dbs->query($sql_all);
  16.         $items_cur = $dbs->query($sql_cur);
  17.        
  18.         if ($items_cur->num_rows == 0):
  19.             $list = '<p>Daftar Kosong</p>';
  20.         else:
  21.             $list = '';
  22.             while($item = $items_cur->fetch_assoc()):
  23.                 $list .= "<p>{$item['title']}</p>";
  24.             endwhile;
  25.         endif;
  26.        
  27.         if (($items_all->num_rows > $items_cur->num_rows)):
  28.             $paging = '<hr width="97%" size="1" />'."\n";
  29.             $paging .= '<div style="text-align: center;">'.simbio_paging::paging($items_all->num_rows, $items_cur->num_rows, 3).'</div>';
  30.         else:
  31.             $paging = '';
  32.         endif;
  33.  
  34. ?>
  35.  
  36. <div>
  37.     <h3>Daftar Item</h3>
  38.     <div>
  39.         <?php echo $list;?>
  40.     </div>
  41.     <p>Page: <?php echo $page;?></p>
  42.     <?php echo $paging;?>
  43. </div>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement