-
Notifications
You must be signed in to change notification settings - Fork 3
Expand file tree
/
Copy pathdata_kelas_view.php
More file actions
48 lines (38 loc) · 1.45 KB
/
data_kelas_view.php
File metadata and controls
48 lines (38 loc) · 1.45 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
<?php
include "lib/config.php";
include "modul/enkripsi/function.php";
//kolom apa saja yang akan ditampilkan
$columns = array(
'id_kelas',
'isi_kelas'
);
//lakukan query data dari 3 table dengan inner join
$query = $datatable->get_custom("SELECT * FROM kelas_all",$columns);
//buat inisialisasi array data
$data = array();
foreach ($query as $value) {
//array sementara data
$ResultData = array();
//masukan data ke array sesuai kolom table
$ResultData[] = $value->id_kelas;
$ResultData[] = $value->isi_kelas;
//bisa juga pake logic misal jika value tertentu maka outputnya
//kita bisa buat tombol untuk keperluan edit, delete, dll,
$edit = paramEncrypt("uri=kelas/kelas_edit&id_kelas=".$value->id_kelas);
$del = paramEncrypt("uri=kelas/kelas_delete&id_kelas=".$value->id_kelas);
$crud_uri = array(
"edit" => $edit,
"delete" => $del,
"del_msg" => "confirm return('Hapus Data ".$value->isi."? ')"
);
$ResultData[] = "
<a title='Ubah Data' href='./?".$crud_uri[edit]."' class='link'><span class='glyphicon glyphicon-pencil btn btn-xs btn-default'></span></a>
<a title='Hapus Data' onclick=confirmHapus('./?".$crud_uri[delete]."') href='#' class='link'><span class='glyphicon glyphicon-trash btn btn-xs btn-danger'></span></a>
";
//memasukan array ke variable $data
$data[] = $ResultData;
}
//set data
$datatable->set_data($data);
//create our json
$datatable->create_data();