phpblog/view_user.php at master · sonvisal/phpblog · 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
<!DOCTYPE html>
<html>
<head>
	<title> </title>
	<meta name="viewport" content="width=device-width, initial-scale=1">
	<link rel="stylesheet" type="text/css" href="asset/css/bootstrap.css"/>
	<link rel="stylesheet" type="text/css" href="asset/css/bootstrap.min.css"/>
	<script type="text/javascript" src="asset/js/bootstrap.js"></script>
</head>
<body>
<div class="container">
<?php
// Establish Connection to the Database
$con = mysqli_connect("localhost","root","123","app_login");//Records per page
$per_page=5;
if (isset($_GET["page"])) {

$page = $_GET["page"];

}
else {

$page=1;

}
// Page will start from 0 and Multiple by Per Page
$start_from = ($page-1) * $per_page;

//Selecting the data from table but with limit
$query = "SELECT * FROM user LIMIT $start_from, $per_page";
$result = mysqli_query ($con, $query);
?>
<table class="table table-striped">
<tr><th>ID</th><th>Firstname</th><th>Lastname</th><th>Username</th><th>Email</th><th>Password</th><th>Action</th></tr>
<?php
while ($row = mysqli_fetch_assoc($result)) {
	$id=$row["id"];
?>
<tr>
<td><?php echo $row['id'];?></td>
<td><?php echo $row["firstname"];?></td>
<td><?php echo $row['lastname'];?></td>
<td><?php echo $row['username'];?></td>
<td><?php echo $row['email'];?></td>
<td><?php echo $row['password'];?></td>
<?php echo "<td ><a href=\"delete_user.php?user_id=".$id ."\" onclick=\"return confirm('Are you sure you want to delete datas?');\"><i class='glyphicon glyphicon-trash'></i></a> <a href=\"edit_user.php?user_id=".$id . "\" onclick=\"return confirm('Are you sure you want to edit datas?');\"><i class='glyphicon glyphicon-edit'></i></a></td>"?>
</tr>
<?php
};
?>
</table>

<div>
<?php

//Now select all from table
$query = "select * from user";
$result = mysqli_query($con, $query);

// Count the total records
$total_records = mysqli_num_rows($result);

//Using ceil function to divide the total records on per page
$total_pages = ceil($total_records / $per_page);

//Going to first page
echo "<center><a href='view_user.php?page=1'>".'<span class="glyphicon glyphicon-fast-backward">'."</a> ";

for ($i=1; $i<=$total_pages; $i++) {

echo "<a href='view_user.php?page=".$i."'>".$i."</a> ";
};
// Going to last page
echo "<a href='view_user.php?page=$total_pages'>".'<span class="glyphicon glyphicon-fast-forward"></span>'."</a></center>";
?>
</div>
</div>
</body>
</html>