|
Server IP : 86.38.243.193 / Your IP : 216.73.217.143 Web Server : LiteSpeed System : Linux in-mum-web1336.main-hosting.eu 4.18.0-553.34.1.lve.el8.x86_64 #1 SMP Thu Jan 9 16:30:32 UTC 2025 x86_64 User : u493057690 ( 493057690) PHP Version : 8.2.30 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : OFF | Python : ON Directory (0755) : /home/u493057690/domains/iasfindia.com/public_html/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
require_once 'validate.php';
require 'name.php';
?>
<?php
include('header.php');
?>
<?php
include('sidebar.php');
?>
<style>
.settings-tab .tabs-menu li {
width: 25% !important;
display: block;
}
</style>
<?php
if(isset($_POST['search']))
{
$valueToSearch = $_POST['valueToSearch'];
// search in all table columns
// using concat mysql function
$query = "SELECT * FROM `registration` WHERE CONCAT(`serial_id`, `name`, `emailid`, `contact_no`, `state`, `sport`, `designation`, `reg_date`, `status`) LIKE '%".$valueToSearch."%'";
$search_result = filterTable($query);
}
else {
$query = "SELECT * FROM `registration`";
$search_result = filterTable($query);
}
// function to connect and execute the query
function filterTable($query)
{
$conn = mysqli_connect("localhost", "hotelrsg_iasfindia", "Sport@123", "hotelrsg_iasf");
$filter_Result = mysqli_query($conn, $query);
return $filter_Result;
}
?>
<!--app content-->
<div class="app-content">
<div class="side-app">
<div class="page-header">
<h4 class="page-title">Player Registration</h4>
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="#"><i class="fe fe-home mr-1"></i> Admin</a></li>
<li class="breadcrumb-item active" aria-current="page">Registration</li>
</ol>
</div>
<div class = "panel panel-default">
<div class = "panel-body">
<div class="card-body">
<div class="settings-tab">
<ul class="tabs-menu nav">
<li class=""><a href="#tab0" class="active" data-toggle="tab"><i class="fe fe-aperture mr-2"></i> All</a></li>
<li class=""><a href="#tab1" data-toggle="tab"><i class="fe fe-aperture mr-2"></i> Pending</a></li>
<li><a href="#tab2" data-toggle="tab" class=""><i class="fe fe-message-circle mr-2"></i> Approved</a></li>
<li><a href="#tab3" data-toggle="tab" class=""><i class="fe fe-settings mr-2"></i> Discard</a></li>
</ul>
<form action="reserve.php" method="post">
<input type="text" name="valueToSearch" placeholder="Value To Search">
<input type="submit" name="search" value="Filter">
<div class="tab-content">
<div class="tab-pane active show" id="tab0">
<table id = "table" class = "table table-bordered">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Email</th>
<th>Contact No</th>
<th>State</th>
<th>Sport</th>
<th>Designation</th>
<th>Date</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php while($fetch = mysqli_fetch_array($search_result)):?>
<tr>
<td><?php echo $fetch['serial_id']?></td>
<td><?php echo $fetch['name']?></td>
<td><?php echo $fetch['emailid']?></td>
<td><?php echo $fetch['contact_no']?></td>
<td><?php echo $fetch['state']?></td>
<td><?php echo $fetch['sport']?></td>
<td><?php echo $fetch['designation']?></td>
<td><strong><?php echo $fetch['reg_date']?></strong></td>
<td><?php echo $fetch['status']?></td>
<td><center>
<form action="update.php" method="post">
<input type = "hidden" class = "form-control" name = "serial_id" value="<?php echo $fetch['serial_id'];?>" />
<input type = "submit" class = "btn btn-success btn-icon btn-sm fe fe-edit-2" name ="approved" value="Approved"></input>
</form>
<form action="update.php" method="post">
<input type = "hidden" class = "form-control" name = "serial_id" value="<?php echo $fetch['serial_id'];?>" />
<input type = "submit" class = "btn btn-danger btn-icon btn-sm fe fe-edit-2" name ="discard" value="Discard" />
</form>
</tr>
<?php endwhile;?>
</tbody>
</table>
</div>
<div class="tab-pane" id="tab1">
<table id = "table" class = "table table-bordered">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Email</th>
<th>Contact No</th>
<th>State</th>
<th>Sport</th>
<th>Designation</th>
<th>Date</th>
<th>Status</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$query = $conn->query("SELECT * FROM `registration` WHERE `status` = 'Pending'") or die(mysqli_error());
/* $query = $conn->query("UPDATE from 'guest' SET 'status'='Approve' WHERE 'status'='Pending' ") or die(mysqli_error()); */
while($fetch = $query->fetch_array()){
?>
<tr>
<td><?php echo $fetch['serial_id']?></td>
<td><?php echo $fetch['name']?></td>
<td><?php echo $fetch['emailid']?></td>
<td><?php echo $fetch['contact_no']?></td>
<td><?php echo $fetch['state']?></td>
<td><?php echo $fetch['sport']?></td>
<td><?php echo $fetch['designation']?></td>
<td><strong><?php echo $fetch['reg_date']?></strong></td>
<td><?php echo $fetch['status']?></td>
<td><center>
<form action="update.php" method="post">
<input type = "hidden" class = "form-control" name = "serial_id" value="<?php echo $fetch['serial_id'];?>" />
<input type = "submit" class = "btn btn-success btn-icon btn-sm fe fe-edit-2" name ="approved" value="Approved"></input>
</form>
<form action="update.php" method="post">
<input type = "hidden" class = "form-control" name = "serial_id" value="<?php echo $fetch['serial_id'];?>" />
<input type = "submit" class = "btn btn-danger btn-icon btn-sm fe fe-edit-2" name ="discard" value="Discard" />
</form>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<div class="tab-pane" id="tab2">
<table id = "table" class = "table table-bordered">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Email</th>
<th>Contact No</th>
<th>State</th>
<th>Sport</th>
<th>Designation</th>
<th>Date</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<?php
$query = $conn->query("SELECT * FROM `registration` WHERE `status` = 'Approved'") or die(mysqli_error());
/* $query = $conn->query("UPDATE from 'guest' SET 'status'='Approve' WHERE 'status'='Pending' ") or die(mysqli_error()); */
while($fetch = $query->fetch_array()){
?>
<tr>
<tr>
<td><?php echo $fetch['serial_id']?></td>
<td><?php echo $fetch['name']?></td>
<td><?php echo $fetch['emailid']?></td>
<td><?php echo $fetch['contact_no']?></td>
<td><?php echo $fetch['state']?></td>
<td><?php echo $fetch['sport']?></td>
<td><?php echo $fetch['designation']?></td>
<td><strong><?php echo $fetch['reg_date']?></strong></td>
<td><?php echo $fetch['status']?></td>
</tr>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
<div class="tab-pane" id="tab3">
<table id = "table" class = "table table-bordered">
<thead>
<tr>
<th>ID</th>
<th>Name</th>
<th>Email</th>
<th>Contact No</th>
<th>State</th>
<th>Sport</th>
<th>Designation</th>
<th>Date</th>
<th>Status</th>
</tr>
</thead>
<tbody>
<?php
$query = $conn->query("SELECT * FROM `registration` WHERE `status` = 'Discard'") or die(mysqli_error());
/* $query = $conn->query("UPDATE from 'guest' SET 'status'='Approve' WHERE 'status'='Pending' ") or die(mysqli_error()); */
while($fetch = $query->fetch_array()){
?>
<tr>
<td><?php echo $fetch['serial_id']?></td>
<td><?php echo $fetch['name']?></td>
<td><?php echo $fetch['emailid']?></td>
<td><?php echo $fetch['contact_no']?></td>
<td><?php echo $fetch['state']?></td>
<td><?php echo $fetch['sport']?></td>
<td><?php echo $fetch['designation']?></td>
<td><strong><?php echo $fetch['reg_date']?></strong></td>
<td><?php echo $fetch['status']?></td>
</tr>
<?php
}
?>
</tbody>
</table>
</div>
</div>
</form>
</div>
</div>
</div>
</div>
</div>
</div>
<!--app content-->
<script src = "../js/jquery.js"></script>
<script src = "../js/bootstrap.js"></script>
<script src = "../js/jquery.dataTables.js"></script>
<script src = "../js/dataTables.bootstrap.js"></script>
<script type = "text/javascript">
$(document).ready(function(){
$("#table").DataTable();
});
</script>
<script type = "text/javascript">
function confirmationDelete(anchor){
var conf = confirm("Are you sure you want to delete this record?");
if(conf){
window.location = anchor.attr("href");
}
}
</script>
<?php
include('footer.php');
?>