Advertisement
Guest User

Untitled

a guest
Jul 17th, 2018
62
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.53 KB | None | 0 0
  1. <?php
  2. header("content_type:application/json");
  3. require 'koneksi.php';
  4. $num = 10;
  5. if (isset($_GET['page'])) {
  6. $page = $_GET['page'];
  7. }else{
  8. $page = 1;
  9. }
  10. $form = ($page - 1) * $num;
  11. $sqltotal = "SELECT * FROM ajax_db";
  12. $sql = "SELECT * FROM ajax_db Order By id LIMIT $form,$num";
  13. $result = mysqli_query($sql);
  14. while ($row=mysql_fetch_assoc($result)) {
  15. $json = $row[];
  16. }
  17. $data['data'] =$json
  18. $result = mysqli_query($sql,$sqltotal);
  19. $data['total'] = mysqli_num_rows($result);
  20. echo json_encode($data, JSON_PRETTY_PRINT);
  21.  
  22. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement