Skip to content

Instantly share code, notes, and snippets.

@griajobag
Created February 3, 2019 14:38
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save griajobag/d082d8445f399ecc6a96b9b41b4214fa to your computer and use it in GitHub Desktop.
Save griajobag/d082d8445f399ecc6a96b9b41b4214fa to your computer and use it in GitHub Desktop.
Pagination php
<?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