/
data_pengguna.php
executable file
·143 lines (138 loc) · 5.04 KB
/
data_pengguna.php
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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
<?php
require_once("./script/config.php");
require_once($site_path."script/library.php");
cekSession();
//atur variabel paging
$n_data=countNData('pengguna');
$n_halaman=ceil($n_data/$n_data_halaman);
/*------------------------
PROSES KIRIMAN DATA
--------------------------*/
//inisialisasi data
$pesan="";
// <<< PROSES METHOD POST >>>
if (!empty($_POST[action])) {
switch ($_POST[action]) {
case 'save': // <<< SIMPAN DATA >>>
if ($_POST[id] == 0) { // <<< SIMPAN DATA BARU >>>
$elemen=array('username','password','nama_lengkap','id_status');
$pesan=addNew('pengguna', $elemen);
} else { // <<< UDATE DATA LAMA >>>
if (empty($_POST[password])) { // <<< UDATE TANPA PASSWORD >>>
$elemen=array('username','nama_lengkap','id_status');
$pesan=updateOld('pengguna', $elemen, $_POST[id]);
} else { // <<< UDATE DENGAN PASSWORD >>>
$elemen=array('username','password','nama_lengkap','id_status');
$pesan=updateOld('pengguna', $elemen, $_POST[id]);
}
}
break;
case 'delete': // <<< HAPUS DATA >>>
$pesan=deleteData('pengguna',$_POST[id]);
break;
case 'new': // <<< KOSONGKAN FORM >>>
header("location: ".$_SERVER['PHP_SELF']);
break;
}
// <<< ATUR ALERT >>>
if (strlen($pesan) > 0) $pesan='<div class="box">'.$pesan.'</div>';
$tampil_baru=true;
} else if (empty($_GET[id])) {
$tampil_baru=true;
}
/*-------------
ISI FORM
---------------*/
$elemen=array('id', 'username','nama_lengkap','id_status');
$form_value=fillForm('pengguna', $elemen, $_GET[id]);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD XHTML 4.01 Transitional//EN">
<html>
<?php include($site_path."design/meta.php"); ?>
<body>
<div id="wrapper">
<?php include($site_path."design/page_header.php"); ?>
<?php include($site_path."design/menubar.php"); ?>
<div id="content" class="row">
<?php echo $pesan; ?>
<div id="form_area" class="column">
<h3>Data Pengguna <?php echo ($tampil_baru)?'Baru':'Lama'; ?></h3>
<div class="box" style="width: 310px;">
<form id="form_pengguna" method="POST" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<input type="hidden" name="id" value="<?php echo $form_value[id]; ?>" />
<div class="row">
<label>User Name</label> <input type="text" name="username" value="<?php echo $form_value[username]; ?>" />
</div>
<div class="row">
<label>Pass Word</label> <input type="password" name="password" value="" />
</div>
<div class="row">
<label>Nama Lengkap</label> <input type="text" name="nama_lengkap" value="<?php echo $form_value[nama_lengkap]; ?>" />
</div>
<div class="row">
<label>Status</label>
<select name="id_status">
<?php showComboBox('status',$form_value[id_status]); ?>
</select>
</div>
<div class="row">
<label> </label>
<input type="submit" name="action" value="new" class="hidable" title="baru" />
<input type="submit" name="action" value="save" title="simpan" />
<input type="submit" name="action" value="delete" class="hidable" title="hapus" onclick="return confirm_delete('<?php echo $form_value[nama_lengkap]; ?>')" />
</div>
</form>
</div>
</div>
<div id="table_area" class="column">
<h3>List data</h3>
<div class="box" style="width: 650px;">
<form id="form_tabel" method="GET" action="<?php echo $_SERVER['PHP_SELF']; ?>">
<div class="row">
<label>Banyak data per halaman :</label> <input type="text" name="n_data_halaman" size="5" value="10" /> <input type="submit" value="Ganti!" />
</div>
</form>
</div>
<br />
<div style="width: 660px; border: 1px solid #BFBFBF; overflow-y:none; overflow-x: scroll;">
<table id="tabel_pengguna" class="sortable">
<?php
$query= "SELECT pengguna.id AS id,
pengguna.username AS username,
pengguna.nama_lengkap AS nama,
status.nama AS nama_status
FROM pengguna, status
WHERE status.id=pengguna.id_status
LIMIT $posisi, $n_data_halaman"; //echo $query;
$elemen=array('User Id' => 'username', 'Nama Pengguna' => 'nama', 'Status' => 'nama_status');
showTable($query, $elemen, 'row_click');
?>
</table>
</div>
<p>Halaman: |<?php showPagingLink($halaman, $n_data_halaman, $n_halaman); ?></p>
<p>Keterangan: klik pada judul tabel untuk mengurutkan data.</p>
</div>
</div>
<script language="Javascript">
function row_click(val) {
window.location = '<?php echo $_SERVER['PHP_SELF']; ?>?n_data_halaman=<?php echo $n_data_halaman; ?>&halaman=<?php echo $halaman; ?>&id='+val;
}
function confirm_delete(val) {
return confirm('Apakah anda benar-benar ingin menghapus pengguna: '+val+'?')
}
</script>
<style type="text/css">
#form_pengguna label { width: 100px; }
#form_tabel label { width: 175px; }
<?php
if ($tampil_baru) {
?>
.hidable {
display: none;
}
<?php } ?>
</style>
<?php include($site_path."design/page_footer.php"); ?>
</div>
</body>
</html>