<div id="right">

 <div id="sidebar">

 <div id="sidebar_title"><h1>Modul >> View Data</h1></div>

 <div id="sidebar_content_right" style="padding:10px">



 <!-- All Content -->

 <table id="dg" title="My Data" class="easyui-datagrid" style="width:auto;height:auto" url="http://localhost/pl-panel/mod-data.php"

 toolbar="#toolbar" pagination="true"

 rownumbers="true" fitColumns="true" singleSelect="true">

 <thead>

 <tr>

 <th field="modul_cat_name" width="50" sortable="true">Modul Category</th>

 <th field="status" width="50" sortable="true">Status</th>

 <th field="action" width="50">Action</th>

 </tr>

 </thead>

 </table>

 <?php include "mod-view/mod-modul-cat/form.php";?>

 <!-- End All Content -->



 </div>

 </div>

</div>

<?php

class Mod_modul_cat

{

 private $DBH;

 

 public function __construct(PDO $DBH)

 {

 $this->DBH = &$DBH; 

 }

 

 public function getAll()

 {

 $page = isset($_POST['page']) ? intval($_POST['page']) : 1;

 $rows = isset($_POST['rows']) ? intval($_POST['rows']) : 10;

 $offset = ($page-1)*$rows;

 $result = array();

 

 $sql = "select count(*) tbl_modul_cat";

 $query = $this->DBH->prepare($sql);

 $data = $query->execute(array());

 $row = $query->fetch(PDO::FETCH_NUM);

 $result['total'] = $row[0];

 

 $sql = "select * from tbl_modul_cat";

 $query = $this->DBH->prepare($sql);

 $data = $query->execute(array());

 $row = $query->fetchAll(PDO::FETCH_ASSOC);

 

 $items = array();

 $i=0;

 foreach($row as $Idx => $data_row):

 $items[$i]['id_modul_cat'] = $data_row['id_modul_cat'];

 $items[$i]['status'] = $data_row['status'];

 $items[$i]['modul_cat_name'] = $data_row['modul_cat_name'];

 $i++;

 endforeach;

 $result['$rows'] = $items;

 echo json_encode($result);

 return $result;

 } 

}

?>

<?php

 include "mod-config/mod-config.php";

 include "mod-include/mod_modul_cat.php";

 $modulCat = new Mod_modul_cat($DBH);

 

 $get = $modulCat->getAll();

 echo $get;

?>