-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtrash.php
122 lines (122 loc) · 5.16 KB
/
trash.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
<?php session_start(); ?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta http-equiv="X-UA-Compatible" content="IE=edge">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Thùng rác của bạn</title>
<?php include './assets/include/framework.php'; ?>
<link rel="stylesheet" href="./assets/css/uploadmain.css">
</head>
<body onload="Notification()">
<?php include './assets/include/header.php'; ?>
<?php include './assets/include/check.php'; ?>
<?php include './assets/include/check-invalid-user.php'; ?>
<main>
<h1 class="text-center">Thùng rác của bạn</h1>
<h2><a href="./uploadmain.php"><button type="button" class="btn btn-primary"><i class="fas fa-arrow-circle-left"></i> Quay lại</button></a></h2>
<table class="table table-hover table-bordered text-center">
<thead>
<tr class="table-primary">
<th>STT</th>
<th></th>
<th>Tên</th>
<th>Thể loại</th>
<th>Tác giả</th>
<th>Xóa vào ngày</th>
<th colspan="2" class="text-center">Cài đặt</th>
</tr>
</thead>
<tbody>
<?php
if (isset($_GET['page'])) {
$page = $_GET['page'];
}
else {
$page = 1;
}
$number_of_item = 3;
$start_at = ($page-1)*$number_of_item;
$sql_getmusic3 = "SELECT * FROM music WHERE create_by ='$profile' AND is_deleted = 1 ORDER BY list LIMIT $start_at,$number_of_item";
$getmusic3 = $conn->query($sql_getmusic3) or die($conn->error);
$x = 0;
while ($row = $getmusic3->fetch_assoc()) {
$x++;
echo
'<tr>
<td class="bg-success">'.$x.'</td>
<td class="bg-success"><img class="img-thumnail" onError="this.onerror=null;this.src=`./assets/img/vector60-1116-01.jpg`;" src="./Profile Storage/'.$profile.'/img/'.$row['picture'].'" alt="Music Thumnail" width="40px" height="40px"></td>
<td class="bg-success">'.$row['title'].'</td>
<td class="bg-success">'.$row['gender'].'</td>
<td class="bg-success">'.$row['author'].'</td>
<td class="bg-success">'.$row['delete_at'].'</td>
<td class="bg-dark"><a href="./assets/PHP/restore-music.php?title='.$row['title'].'"><button class="btn btn-success"><i class="fas fa-sync"></i></button></a></td>
<td class="bg-dark">
<a onclick="confirm(event)"
href="./assets/PHP/deletemusic.php?account='.$profile.'&title='.$row['title'].'">
<button class="btn btn-danger"><i class="fas fa-trash-alt"></i></button>
</a></td>
</tr>
';
}
?>
</tbody>
</table>
<nav aria-label="Page navigation">
<ul class="pagination justify-content-end">
<?php
$sql_music = "SELECT * FROM music WHERE create_by ='$profile' AND is_deleted = 1";
$music = $conn->query($sql_music) or die($conn->error);
$total_music = $music->num_rows;
$total_pages = ceil($total_music/$number_of_item);
if ($page>1) {
echo '
<li class="page-item">
<a class="page-link" href="./uploadmain.php?page='.($page-1).'" aria-label="Previous">
<span aria-hidden="true"><i class="fas fa-arrow-circle-left"></i></span>
</a>
</li>
';
}
for ($i = 1; $i < $total_pages; $i++) {
echo '<li class="page-item"><a class="page-link" href="./uploadmain.php?page='.$i.'">'.$i.'</a></li>';
}
if($i>$page) {
echo '
<a class="page-link" href="./uploadmain.php?page='.($page+1).'" aria-label="Next">
<span aria-hidden="true"><i class="fas fa-arrow-circle-right"></i></span>
</a>
</li>
';
}
?>
</ul>
</nav>
<?php include "./assets/include/music-kit.php"; ?>
</main>
<?php include './assets/include/footer.php'; ?>
<!-- Thông báo khi vào trang -->
<div class="position-fixed end-0 p-3" style="z-index: 11; bottom: 5rem">
<div id="liveToast" class="toast" role="alert" aria-live="assertive" aria-atomic="true">
<div class="toast-header">
<strong class="me-auto">KingSoundTrackMP3</strong>
<button type="button" class="btn-close" data-bs-dismiss="toast" aria-label="Close"></button>
</div>
<div class="toast-body text-white bg-success">
Đây là thùng rác của bạn! Nơi lưu trữ nhưng bài hát bị xóa đi! Nếu bạn muốn bạn có thể không phục chúng hoặc bạn có thể xóa chúng vĩnh viễn
</div>
</div>
</div>
</div>
<script>
var toastLive = document.getElementById('liveToast')
function Notification() {
var toast = new bootstrap.Toast(toastLive)
toast.show()
}
</script>
<!-- Thông báo khi vào trang -->
<script src="./assets/javascript/confirm.js"></script>
</body>
</html>