belajar/view.php at master · catursurapam/belajar · GitHub

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
<?php
	include('config.php');
	include('cek-login.php');
?>

	<!DOCTYPE html>
		<html>
			<head>
				<title> Belajar sistem crud </title>
			</head>

			<body>
				<?php
					echo $_SESSION['role'];
					echo $_SESSION['username'];
				?>
				<h1> Data user </h1>
					<?php
						if(!empty($_GET['message']) && $_GET['message'] == 'success')
								{
									echo '<h3>Berhasil Meng-update data</h3>';
								}

						if(!empty($_GET['message']) && $_GET['message'] == 'deleted')
							{
								echo '<h3> Data berhasil di hapus </h3>';
							}
					?>
					<a href="index.php">+ tambah data</a>
						<table border="1" cellpadding="5" cellspacing="0">
							<thead>
								<tr>
									<td>No.</td>
									<td>Username</td>
									<td>Password</td>
									<td>Email</td>
									<td>Fullname</td>
									<td>Agama</td>
									<td>No HP </td>
									<td>Opsi </td>
								</tr>
							</thead>

							<tbody>
								<?php
									$no = 1;
									$query = mysql_query("select * from user");

										// jika user mempunyai role administrator maka
											if($_SESSION['role'] == 'Administrator')
												{
													while($data = mysql_fetch_array($query))
														{
								?>
															<tr>
																<td><?php echo $no ?></td>
																<td><?php echo $data['username'] ?> </td>
																<td><?php echo $data['password'] ?> </td>
																<td><?php echo $data['email'] ?> </td>
																<td><?php echo $data['fullname'] ?></td>
																<td><?php echo $data['agama'] ?></td>
																<td><?php echo $data['no_hp'] ?></td>
																<td><a href="edit.php?id=<?php echo $data['user_id'] ?>">Edit</a> || <a href="delete.php?id=<?php echo $data['user_id'] ?>">Delete</a></td>
														<?php
																$no++;
														}
												}
												else if($_SESSION['role'] == 'Moderator')
														{
															while($data = mysql_fetch_array($query))
																{
														?>
																	<tr>
																		<td><?php echo $no ?></td>
																		<td><?php echo $data['username'] ?></td>
																		<td><?php echo $data['password'] ?></td>
																		<td><?php echo $data['email'] ?></td>
																		<td><?php echo $data['fullname'] ?></td>
																		<td><?php echo $data['agama'] ?></td>
																		<td><?php echo $data['no_hp'] ?></td>
																		<td><a href="edit.php?id=<?php echo $data['user_id']?>">Edit</a> || Delete</td>
																	</tr>
														<?php
																$no++;
																}
														}
														else if($_SESSION['role'] == 'Member')
																{
																	while($data = mysql_fetch_array($query))
																		{
														?>
																			<tr>
																				<td><?php echo $no ?></td>
																				<td><?php echo $data['username'] ?></td>
																				<td>******</td>
																				<td>******</td>
																				<td><?php echo $data['fullname'] ?></td>
																				<td><?php echo $data['agama'] ?></td>
																				<td><?php echo $data['no_hp'] ?></td>
																				<td>    </td>
																			</tr>
														<?php
																$no++;
																		}
																}
														?>

							</tbody>
						</table>
					</body>
				</html>