-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathdjadmin.php
120 lines (69 loc) · 2.13 KB
/
djadmin.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
<!DOCTYPE html>
<html>
<head>
<title>Your Music-Decision</title>
<meta charset="utf-8">
<link rel="stylesheet" type="text/css" href="djadminstyle.css">
<body style="background-image: url(background.jpg)">
<?php
require 'connection.php';
$partyname = $_POST["partyname"];
//$idsen = $_GET["anyon"];
function printlist($dbname)
{
require 'connection.php';
$sqli = "SELECT * FROM $dbname ORDER BY upvote DESC";
$result=$dbh->query($sqli);
$statement= $dbh->prepare("SELECT Datum FROM $dbname");
$statement->execute(array());
$upvoteding='';
foreach ($result as $daten ) {
$idsen = $daten["N_ID"];
$partyname = $dbname;
/*$idtwo = "up".$daten["N_ID"];
$upvoteding = $daten["upvote"];
/*
$upvote = "SELECT upvote FROM tbl_tbl_music WHERE N_ID = $idsen";
$res = $dbh->query($upvote);
foreach ($res as $dat) {
$upvoteding = $dat["upvote"];
}*/
// Ausgeben der Datenbank
echo "<hr>".$daten["Wunsch"]. " von ".$daten["Interpret"] ."<br>"."Upvotes : ".$daten["upvote"]."<br>"." gewünscht am : ";
$row = $statement->fetch();
$date = new DateTime($row['Datum']);
echo $date->format('d.m.Y H:i');
echo"<form action='djresulti.php?anyon=$idsen&partyname=$partyname' method='post'>
<input type='submit' name='$idsen' value='bereits gespielt' id='delbutt' class='inbutt' >
</form>";
}
}
$sql = "SELECT * FROM `reg_data` WHERE `partyname` = '$partyname'";
$stmt = $dbh->prepare($sql);
$stmt->execute(array());
foreach ($stmt as $daten ) {
if ($daten["djlogin"]==$_POST["djname"]) {
echo "Login succesfull";
printlist($partyname);
}
else {
echo "LoginError";
}
}
if (isset($_POST["backbutt"])) {
$partyname = $_GET["partyname"];
echo "<h1>"."Angemeldet für Party :".$partyname."</h1> ";
printlist($partyname);
}
?>
<br>
<br>
<hr>
<div class="footer">
<p><b>oder</b> du meldest dich ab : <br></p>
<form action='main.php' method='post'>
<input type='submit' name='logout' value='logout' id="backbutt" class="inbutt">
</form>
</div>
</body>
</html>