-
Notifications
You must be signed in to change notification settings - Fork 14
/
show_contact.php
104 lines (90 loc) · 3.8 KB
/
show_contact.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
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Document</title>
<style>
#footersection{
margin-top:25%;
}
</style>
</head>
<body>
<div class="container-fluid" id="cont-3">
<header id="nav-bar">
<nav class="navbar navbar-expand-lg navbar-light bg-dark">
<a class="navbar-brand" href=index.html style="color: white; font-weight: 600; margin-top: 15px;">GO VOTE</a>
<button class="navbar-toggler" type="button" data-toggle="collapse" data-target="#navbarNav" aria-controls="navbarNav" aria-expanded="false" aria-label="Toggle navigation">
<span class="navbar-toggler-icon" style="color: white;"></span>
</button>
<div class="collapse navbar-collapse" id="navbarNav">
<ul class="navbar-nav ml-auto animate__animated animate__bounceInDown" style="padding-right: 50px;">
<li class="nav-item" >
<a class="nav-link" href="index.html" style="color:white; font-weight: 600; text-align: center; font-size: 18px; margin-top: 20px; text-transform: capitalize; padding: 20px;">Home</a>
</li>
<li class="nav-item" >
<a class="nav-link" href="admin_dashboard.php" style="color:white; font-weight: 600; text-align: center; font-size: 18px; margin-top: 20px; text-transform: capitalize; padding: 20px;">Dashboard</a>
</li>
<li class="nav-item" >
<a class="nav-link" href="user_suggestion.php" style="color: white; font-weight: 600; text-align: center; font-size: 18px; margin-top: 20px; text-transform: capitalize; padding: 20px;">Suggestions</a>
</li>
<li class="nav-item" >
<a class="nav-link" href="show_contact.php" style="color: white; font-weight: 600; text-align: center; font-size: 18px; margin-top: 20px; text-transform: capitalize; padding: 20px;">Contact</a>
</li>
<li class="nav-item">
<a class="nav-link" href="user_details_year.php" style="color: white; font-weight: 600; text-align: center; font-size: 18px; margin-top: 20px; text-transform: capitalize; padding: 20px;">Users</a>
</li>
<li class="nav-item">
<a class="nav-link" href="user_cand_year.php" style="color: white; font-weight: 600; text-align: center; font-size: 18px; margin-top: 20px; text-transform: capitalize; padding: 20px;">Candidates</a>
</li>
<li class="nav-item" >
<a class="nav-link" href="logout.php" style="color: white; font-weight: 600; text-align: center; font-size: 18px; margin-top: 20px; text-transform: capitalize; padding: 20px;">Logout</a>
</li>
</ul>
</div>
</nav>
</header>
<section style="padding-top:50px; padding-botton:50px">
<div class="container">
<div class="row">
<div class="col-md-12" >
<?php session_start();
include('dbConnect.php');
$sql = "select * from contact order by id desc";
$stmt = $pdo->prepare($sql);
$stmt->execute();
$rs = $stmt->fetchAll();
echo "
<table border='2'>
<tr>
<th>Sno.</th>
<th>Name</th>
<th>Email</th>
<th>Message</th>
</tr>
";
$i = 1;
foreach($rs as $row){
$uid = $row['id'];
echo "
<tr>
<td>".$i."</td>
<td>".$row['name']."</td>
<td>".$row['email']."</td>
<td>".$row['message']."</td>
</tr>
";
$i++;
}
echo "</table>";
?>
</div>
</div>
</div>
</section>
<?php
include("footer.html");
?>
</body>
</html>