-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathupdate.php
126 lines (126 loc) · 3.9 KB
/
update.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
<?php
include 'connection.php';
$sql = "SELECT * FROM sportevent";
$result = $con->query($sql);
$con->close();
?>
<!DOCTYPE html>
<html>
<head>
<title>UPDATE PAGE</title>
<link rel="stylesheet" href="webcss.css">
<style>
table {
width: 100%;
margin: 0 auto;
font-size: large;
border: 1px solid black;
color: black;
background-color: lightgreen;
}
td {
background-color: #E4F5D4;
border: 1px solid black;
}
th{
color:red;
}
th,td {
font-weight: bold;
border: 1px solid black;
padding: 10px;
text-align: center;
}
td {
font-weight: bold;
}
#up{
text-align: center;
font-size:30pt;
color:black;
font-weight:bold;
}
</style>
</head>
<body>
<h1>SPORTS WEBSITE</h1>
<button style="position: absolute;right: 30px;top: 30px;background-color: red;"><a href="logout.php">LOGOUT</a></button>
<div class="container-fluid">
<ul>
<li><a href="mainpage.php">HOME</a></li>
<li><a>SPORTS</a>
<ul>
<li><a href="Health Challenge.php">Health Challenge</a></li>
<li><a href="facilities.php">Facilities</a></li>
<li><a href="references.php">References</a></li>
</ul>
</li>
<li><a href="about.php">ABOUT</a></li>
<li><a href="events.php">EVENTS</a></li>
<li><a href="contact.php">CONTACT</a></li>
</ul>
</div>
<div id="up"><p>Records Updation</p></div>
<?php
if (mysqli_num_rows($result) > 0) {
?>
<table>
<tr>
<th>EVENT NAME</th>
<th>EVENT URL</th>
<th>EMAIL ADDRESS</th>
<th>DATE</th>
<th>TIME</th>
<th>PLACE</th>
<th>DESCRIPTION</th>
<th>UPDATE</th>
</tr>
<?php
$i=0;
while($row = mysqli_fetch_array($result)) {
?>
<tr>
<td><?php echo $row['eventname'];?></td>
<td><a href="#"><?php echo $row['eventurl'];?></a></td>
<td><?php echo $row['mail'];?></td>
<td><?php echo $row['eventdate'];?></td>
<td><?php echo $row['eventtime'];?></td>
<td><?php echo $row['place'];?></td>
<td><?php echo $row['eventdescription'];?></td>
<td><a href="updateevent.php?id=<?php echo $row["id"]; ?>">Update</a></td>
</tr>
<?php
$i++;
}
?>
</table>
<?php
}
else
{
echo "No result found";
}
?>
<p id="a" style="color:white;"></p>
<script SameSite="None; Secure" src="https://static.landbot.io/landbot-3/landbot-3.0.0.js"></script>
<script>
var myLandbot = new Landbot.Livechat({
configUrl: 'https://chats.landbot.io/v3/H-867982-VUHIR3D20QGD8CVB/index.json',
});
</script>
<footer style="background-color: black; opacity: 0.8; position: absolute; top: 750px;">
Copyrights Reserved © 2020.
<div id="f1">
<img src="https://i.pinimg.com/originals/08/17/15/0817158f3a05c0d62de647c28f4cde54.jpg" alt="INSTAGRAM">
<img src="https://static01.nyt.com/images/2014/08/10/magazine/10wmt/10wmt-articleLarge-v4.jpg?quality=75&auto=webp&disable=upscale" alt="TWITTER">
<img src="https://www.facebook.com/images/fb_icon_325x325.png" alt="FACEBOOK">
<img src="https://i.pinimg.com/originals/2d/2b/e2/2d2be2421911037d80f9921dc29d54c2.jpg" alt="YOUTUBE">
<img src="https://live.staticflickr.com/7412/16521004875_4dd4ebd65f_b.jpg" alt="FLICKR">
</div>
</footer>
<script>
var d = new Date();
document.getElementById("a").innerHTML = d;
</script>
</body>
</html>