Guest User

Untitled

a guest
Jul 21st, 2018
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <?php
  2. $startrow = $_GET['startrow'];
  3.  
  4. if (!isset($_GET['startrow']) or !is_numeric($_GET['startrow'])) {
  5. $startrow = 0;
  6. } else {
  7. $startrow = (int)$_GET['startrow'];
  8. }
  9. ?>
  10. <?php
  11.  
  12. $db = mysqli_connect("localhost", "root", "", "media");
  13. $uploaded = mysqli_query($db, "SELECT * FROM images LIMIT $startrow, 30");
  14.  
  15. while ($row = mysqli_fetch_array($uploaded)) {
  16. echo "<div class='img_container'>";
  17. echo "<li><img class='img_box' src='uploads/images/".$row['image_title']."' ></li>";
  18. echo "</div>";
  19. }
  20.  
  21. $prev = $startrow - 30;
  22. if ($prev >= 0) {
  23. echo '<div class="prevRow"><a href="'.$_SERVER['PHP_SELF'].'?page='.$page.'&startrow='.$prev.'">Back</a></div>';
  24. }
  25. echo '<div class="nextRow"><a href="'.$_SERVER['PHP_SELF'].'?page='.$page.'&startrow='.($startrow+30).'">Next</a></div>';
  26. ?>
Add Comment
Please, Sign In to add comment