-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathuploadmain.php
139 lines (139 loc) · 5.95 KB
/
uploadmain.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
<?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>Nhạ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">Nhạc của bạn</h1>
<h2 class="text-center">
<a href="./uploadmusic.php"><button type="button" class="btn btn-success"><i class="far fa-file"></i> Thêm nhạc <i class="far fa-file"></i></button></a>
<a href="./trash.php"><button type="button" class="btn btn-secondary"><i class="fas fa-trash"></i> Thùng rác (
<?php
$sql_trash = "SELECT * FROM music WHERE create_by = '$profile' AND is_deleted = 1";
$trash = $conn->query($sql_trash) or die($conn->error);
echo $trash->num_rows;
?>
) <i class="fas fa-trash"></i></button></a>
</h2>
<table class="table table-hover table-bordered text-center">
<thead>
<tr class="table-primary">
<th>STT</th>
<th>Ảnh</th>
<th>Tên</th>
<th>Thể loại</th>
<th>Tác giả</th>
<th>Được thêm vào</th>
<th>Mô tả</th>
<th colspan="3" 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 = 0 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++;
if (!empty($row['description'])) {
$description = $row['description'];
}
else {
$description = "Không có mô tả !";
}
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['create_at'].'</td>
<td class="bg-success">
<button type="button" class="btn btn-info" data-bs-toggle="tooltip" data-bs-placement="top" title="'.$description.'">
<i class="far fa-sticky-note"></i>
</button>
</td>
<td class="bg-dark"><a href="./assets/PHP/music-pack.php?list='.$row['list'].'"><button class="btn btn-primary"><i class="far fa-play-circle"></i></button></a></td>
<td class="bg-dark"><a href="./editmusicpage.php?title='.$row['title'].'"><button class="btn btn-success"><i class="fas fa-edit"></i></button></a></td>
<td class="bg-dark"><a href="./assets/PHP/softdelete.php?title='.$row['title'].'"><button class="btn btn-danger"><i class="fas fa-trash"></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 = 0";
$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à nơi bạn quản lý nhưng bản nhạc của bạ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 -->
</body>
</html>