Created
February 3, 2019 14:38
-
-
Save griajobag/d082d8445f399ecc6a96b9b41b4214fa to your computer and use it in GitHub Desktop.
Pagination php
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
require_once "Connection.php"; | |
class ShowData{ | |
function getAllData(){ | |
$connect = new Connection(); | |
$con = $connect->getConnection(); | |
//buatkan array untu jsonnya | |
$json_barang = array(); | |
//buatkan attribute status code dan messagenya | |
$status = "status"; | |
$message = "message"; | |
//berapa data yang akan ditampilkan sekali request | |
$limit = 10; | |
//get semua data dari tabel barang | |
$query = "SELECT * FROM barang"; | |
$result = $con->prepare($query); | |
$result->execute(); | |
//hitung total page | |
$total_result = $result->rowCount(); | |
$total_page = ceil($total_result/$limit); | |
//check current page yang di request oleh client | |
if(!isset($_GET['current_page'])){ | |
$page = 1; | |
}else{ | |
$page = $_GET['current_page']; | |
} | |
$starting_limit = ($page-1)*$limit; | |
//get data berdasarkan limitnya | |
$data_json = "SELECT * FROM barang ORDER BY idbarang ASC LIMIT $starting_limit, $limit"; | |
$result_data = $con->prepare($data_json); | |
$result_data->execute(); | |
//berikan key dan value data jsonnya | |
while($res = $result_data->fetch(PDO::FETCH_ASSOC)): | |
array_push( | |
$json_barang, | |
array( | |
'id_barang'=>$res['idbarang'], // id_barang (nama ini boleh bebas karena sbg key saja), tapi ['idbarang'] (harus sesuai dengan nama di database) | |
'nama_barang'=>$res['namabarang'], // key (bebas), value (harus sama dengan database) | |
'stok_barang'=>$res['stokbarang'] // key (bebas), value (harus sama dengan database) | |
) | |
); | |
endwhile; | |
//tampilkan data jsonnya | |
if($data_json){ | |
echo json_encode(array("barang"=>$json_barang, $status=>1, $message=>"Sukses")); | |
}else{ | |
echo json_encode(array("barang"=>$json_barang, $status=>0, $message=>"Gagal")); | |
} | |
} | |
} | |
//panggil class ini utk menampilkan data | |
$show = new ShowData(); | |
$show->getAllData(); | |
?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment