-
Notifications
You must be signed in to change notification settings - Fork 0
/
fantasyadmin.php
102 lines (79 loc) · 4.55 KB
/
fantasyadmin.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
<!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">
<link rel="stylesheet" href="fanadmin.css">
<link href="https://cdn.jsdelivr.net/npm/[email protected]/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-gH2yIJqKdNHPEq0n4Mqa/HGKIhSkIHeL5AyhkYV8i59U5AR6csBvApHHNl/vI1Bx" crossorigin="anonymous">
<title>Fantasy Team Manage</title>
</head>
<body>
<header>
<div class="main">
<ul>
<li><a href="adminhome.php">Admin Home</a></li>
<li><a href="usertest.php">Users</a></li>
<li class="active"><a href="fantasyadmin.php">Fantasy Team</a></li>
<li><a href="control_player.php">Players</a></li>
<li><a href="admin_fixture.php">Fixture</a></li>
<li><a href="Points_Room.php">Points</a></li>
</ul>
</div>
<div class='bg'>
<div class='signupFrm'>
<h2 style='color:aliceblue;font-family:"myFirstFont"; font-weight: 200px;margin-bottom:0.5%;width:30%;margin-left:38%;margin-right:20% ; margin-top:7%'>
Remove User's Fantasy Team
</h2>
<div style="background-color: white; margin-left:20%;margin-right:20% ; margin-top:3%">
<table class="table table-bordered table-striped">
<thead >
<th>user-email</th>
<th>Connection Table</th>
<th>Action</th>
</thead>
<tbody>
<?php
require_once "config.php";
$sql = "SELECT * FROM `userconn`;";
$result = mysqli_query($conn,$sql);
if ($result){
while($row = $result->fetch_assoc()) {
$email = $row['email'];
$table = $row['Contab'];
echo '
<tr>
<td>'.$row['email'].'</td>
<td>'.$row['Contab'].'</td>
<td>
<button class="btn btn-danger btn-sm" name = "button0">
<a href = "fantasyadmin.php?email='.$email.'&Contab='.$table.'" class="text-light" style = "text-decoration: none;">
Remove
</a>
</button>
</td>
</tr>';
}
}
if(isset($_GET['email'])){
$email1 = $_GET['email'];
$table1 = $_GET['Contab'];
$sql = "DELETE FROM `userconn` WHERE email='$email1'; ";
$result = mysqli_query($conn,$sql);
$sql2 = "DROP TABLE `$table1`";
$result2 = mysqli_query($conn,$sql2);
$sql3 = "UPDATE `users` SET status ='unsubmitted' WHERE email = '$email1';";
$result3 = mysqli_query($conn,$sql3);
if ($result){
header('location:fantasyadmin.php');
}
}
?>
</tbody>
</table>
</div>
</div>
</div>
</header>
</body>
</html>