Source-Code/list_account.php at master · DesignLayoutAgrimate/Source-Code · 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
112
<!DOCTYPE html>
<html lang="en">
<head>
  <title>Cloud Computing</title>
  <meta charset="utf-8">
  <meta name="viewport" content="width=device-width, initial-scale=1">
  <link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/css/bootstrap.min.css">
  <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
  <script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.16.0/umd/popper.min.js"></script>
  <script src="https://maxcdn.bootstrapcdn.com/bootstrap/4.5.0/js/bootstrap.min.js"></script>
</head>
<body>

	<div class="container" style="margin-top:10px;">
		<div class="row">
			<div class="col-xs-3 col-sm-3 col-md-3 col-lg-3"></div>
			<div class="col-xs-6 col-sm-6 col-md-6 col-lg-6">

				<?php

					function pg_connection_string_from_database_url(){
						extract(parse_url($_ENV["DATABASE_URL"]));
						return "user=$user password=$pass host=$host dbname=" .substr($path,1);
					}

					$db = pg_connect(pg_connection_string_from_database_url());
					if(!$db){
						echo "Error : Unable to open database\n";
					}else{
						echo '<div class="alert alert-info" style="text-align:center;padding-top:10px;">';
						echo '<strong>Opened database successfully</strong>';
						echo '</div>';
					}

					$sql = "SELECT * FROM MyAccounts";

					echo '<div class="alert alert-warning" style="text-align:center;padding-top:10px;">';
					print "$sql";
					echo '</div>';

					$ret = pg_query($db,$sql);

					if(!$ret){
						echo '<div class="alert alert-info" style="text-align:center;padding-top:10px;">';
						echo pg_last_error($db);
						echo '</div>';
						exit();
					}
				?>


				<table class="table table-bordered table-hover">
					<thead>
						<tr>
							<th>No.</th>
							<th>Username</th>
							<th>Password</th>
							<th>Option</th>
						</tr>
					</thead>
					<tbody>


						<?php
							// while($myrow = pg_fetch_assoc($ret)){
							// 	printf("<tr><td>%s</td> <td>%s</td></tr>",
							// 	$myrow['username'],$myrow['password']);
							// }
							// pg_close($db);
						?>


						<?php
						$i=1;
						while($myrow=pg_fetch_assoc($ret)) {
						?>

							<tr>
								<td><?php echo $i++; ?></td>
								<td><?php echo $myrow['username']; ?></td>
								<td><?php echo $myrow['password']; ?></td>
								<td>
									<a class="btn btn-sm btn-danger"
									onclick="return confirm('Are you sure you want to delete this item?');"
									href="delete_process.php?username=<?php echo $myrow["username"]; ?>">
										Delete
									</a>
								</td>
							</tr>

						<?php
						pg_close($db);
						}
						?>


					</tbody>
				</table>


				<br>
				<a class="btn btn-sm btn-danger" href="index.php" role="button">Quay lại trang chủ</a>

			</div>
			<div class="col-xs-3 col-sm-3 col-md-3 col-lg-3"></div>
		</div>
	</div>

</body>
</html>