|
Server IP : 103.191.208.227 / Your IP : 3.135.249.119 Web Server : LiteSpeed System : Linux emphasis.herosite.pro 4.18.0-553.8.1.lve.el8.x86_64 #1 SMP Thu Jul 4 16:24:39 UTC 2024 x86_64 User : mhmsfzcs ( 1485) PHP Version : 8.1.31 Disable Function : show_source, system, shell_exec, passthru, exec MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON Directory (0750) : /home/mhmsfzcs/vflyorions.com/.well-known/../../www/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include "db.php";
include "job/admin_header.php";
include "admin_sidebar.php";
if(isset($_GET['delete']))
{
$ad=$_GET['delete'];
$query=$conn->prepare("delete from profile where id =?");
$query->bind_param("s",$ad);
$res=$query->execute();
if($res)
{
$_SESSION['status']="User Deleted Successfully";
$_SESSION['status_code']="success";
}
else
{
$_SESSION['status']="Oops something went wrong!!";
$_SEESION['status_code']="error";
}
}
?>
<main id="main" class="main">
<div class="pagetitle">
<!-- <h1>New Resume</h1> -->
<nav>
<ol class="breadcrumb">
<li class="breadcrumb-item"><a href="index.php">Home</a></li>
<li class="breadcrumb-item active">Dashboard</li>
</ol>
</nav>
</div>
<!-- End Page Title-->
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper" style="height: 38rem;" >
<!-- Content Header (Page header) -->
<section class="content-header" style="width: fit-content;">
<div class="container-fluid">
<div class="card card-primary">
<div class="card-header">
<h3 class="card-title"style="font-family: Times New Roman;font-size: 22px;">
<b>User Login Details</b>
</h3>
</div>
<?php
$currentDate = date('Y-m-d');
$query1 = "SELECT * FROM profile where targetdate >='$currentDate' ORDER BY id DESC";
$result1 = $conn->query($query1);
$sr=1;
?>
<div class="card-body">
<table id="example1" class="table table-bordered table-striped datatable">
<thead>
<tr>
<th>Sr.No</th>
<th>Username</th>
<th>Password</th>
<th>Image Allocate</th>
<th>Count</th>
<th>End Date</th>
<th>Status</th>
<th class="text-center">Change Status</th>
<th class="text-center">Send Mail</th>
<th class="text-center">Delete User</th>
</tr>
</thead>
<tbody>
<?php while ($row = $result1->fetch_assoc())
{
$id=$row['id'];
?>
<tr>
<td><?php echo $sr;?></td>
<td><?= $row['username']; ?></td>
<td><?= $row['password']; ?></td>
<?php
$fetch=("SELECT COUNT(*) as id from new_resume Where user=$id");
$result2 = $conn->query($fetch);
while($row1=$result2->fetch_assoc())
{
$total=$row1['id'];
}
?>
<td><?= $total; ?> </td>
<?php
$fetch3=("SELECT COUNT(*) as id from form_data Where user_id=$id");
$result3 = $conn->query($fetch3);
while($row3=$result3->fetch_assoc())
{
$count=$row3['id'];
}
?>
<td><?= $count; ?></td>
<td><?= $row['targetdate']; ?></td>
<td>
<?php
if($row['status']=="active"){
echo '<span class="btn btn-info">Active</span>';
}
if($row['status']=="inactive"){
echo '<span class="btn btn-warning">Inactive</span>';
}
?></td>
<td class="text-center" style="margin-bottom:5px;">
<a href="statusform.php?edit=<?= $row['id']; ?>" class="btn btn-success">ChangeStatus</a></td>
<td>
<a href="send_mail.php?edit=<?= $row['id']; ?>" class="btn btn-primary">SentMail</a> </td>
<td>
<a href="login_details.php?delete=<?= $row['id']; ?>" onclick="return confirm('Are you sure to delete?')" class="btn btn-Danger">Delete</a>
</td>
</tr>
<?php $sr=$sr+1;} ?>
</tbody>
</table>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</div>
<!-- /.container-fluid -->
</section>
<!-- /.content -->
</div>
</main>
<!-- End #main -->
<script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
<?php if(isset($_SESSION['status']) && $_SESSION['status']!='') { ?>
<script>
new swal({
title: "<?php echo $_SESSION['status'];?>",
//text: "You clicked the button!",
icon: "<?php echo $_SESSION['status_code'];?>",
button: "OK",
}).then(function() {
window.location = "currently_workinguser_details.php";
});
</script>
<?php
unset($_SESSION['status']);
}
?>
<?php
include "footer.php";
?>