|
Server IP : 103.191.208.227 / Your IP : 3.145.1.182 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";
}
}
$fetch = $conn->prepare("SELECT COUNT(*) AS count FROM demo1 where id='$id'");
$fetch->execute();
$res = $fetch->get_result();
$row = $res->fetch_assoc();
/* Count table rows */
$count = $row['count'];
/* Check if button name "Submit" is active, do this */
if(isset($_POST['submit'])) {
$ids = $_POST['id'];
//$sl_nos = $_POST['sl_no'];
$usernames = $_POST['username'];
$passwords = $_POST['password'];
$stat_uss = $_POST['stat_us'];
$permissions = $_POST['permission'];
$targetdates = $_POST['targetdate'];
$statuss = $_POST['status'];
for ($i = 0; $i < $count; $i++) {
$id = $ids[$i];
//$sl_no = $sl_nos[$i];
$username = $usernames[$i];
$password = $passwords[$i];
$stat_us = $stat_uss[$i];
$permission = $permissions[$i];
$targetdate = $targetdates[$i];
$status = $statuss[$i];
// Prepare the UPDATE statement with a WHERE clause
// $user_id=2;
//$img_id=110;
$updateQuery = $conn->prepare("UPDATE `demo1` SET username=?,password=?,stat_us=?,permission=?,targetdate=?,stat_us=? WHERE `id` = ? ");
$updateQuery->bind_param("ssssssi", $username,$password,$stat_us,$permission,$targetdate,$status,$id);
$result = $updateQuery->execute();
}
if ($result) {
//echo "Record with ID updated successfully.<br>";
$_SESSION['status']="Data updated ";
$_SESSION['status_code']="success";
} else {
//echo "Error updating record with ID .<br>";
$_SESSION['status1']="Invalid username or password";
$_SESSION['status_code1']="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>
<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>Status/<br>Permission</th>
<th>End Date</th>
<th>Image Allocate</th>
<th>Count</th>
<th>Status</th>
<th>Update</th>
<!--<th class="text-center">Change Status</th>-->
<th class="text-center">Send Mail</th>
<!--<th class="text-center">Delete User</th>-->
</tr>
</thead>
<form name="form1" method="post">
<input type="submit" name="submit" onclick="return confirm('Are you sure to update data ?')" class="btn btn-info" value="Update All Data">
<?php
$query1 = 'SELECT * FROM demo1 ORDER BY id ASC';
$result1 = $conn->query($query1);
$sr=1;
while ($row = $result1->fetch_assoc())
{
$id=$row['id'];
/* Check if button name "Submit" is active, do this */
if(isset($_POST['submit'])) {
$fetch = $conn->prepare("SELECT COUNT(*) AS count FROM demo1 where id='$id'");
$fetch->execute();
$res = $fetch->get_result();
$row = $res->fetch_assoc();
/* Count table rows */
$count = $row['count'];
$ids = $_POST['id'];
//$sl_nos = $_POST['sl_no'];
$usernames = $_POST['username'];
$passwords = $_POST['password'];
$stat_uss = $_POST['stat_us'];
$permissions = $_POST['permission'];
$targetdates = $_POST['targetdate'];
$statuss = $_POST['status'];
for ($i = 0; $i < $count; $i++) {
$id = $ids[$i];
//$sl_no = $sl_nos[$i];
$username = $usernames[$i];
$password = $passwords[$i];
$stat_us = $stat_uss[$i];
$permission = $permissions[$i];
$targetdate = $targetdates[$i];
$status = $statuss[$i];
// Prepare the UPDATE statement with a WHERE clause
// $user_id=2;
//$img_id=110;
$updateQuery = $conn->prepare("UPDATE `demo1` SET username=?,password=?,stat_us=?,permission=?,targetdate=?,stat_us=? WHERE `id` = ? ");
$updateQuery->bind_param("ssssssi", $username,$password,$stat_us,$permission,$targetdate,$status,$id);
$result = $updateQuery->execute();
}
if ($result) {
//echo "Record with ID updated successfully.<br>";
$_SESSION['status']="Data updated ";
$_SESSION['status_code']="success";
} else {
//echo "Error updating record with ID .<br>";
$_SESSION['status1']="Invalid username or password";
$_SESSION['status_code1']="error";
}
}
?>
<tbody>
<tr style="width:20px">
<td><?php echo $sr;?></td>
<td style="width:20px"><?php //$row['username']; ?>
placeholder="<?php echo $id; ?>"
<input name="id[]" type="hidden" value="<?php echo $id; ?>">
<input type="text" name="username[]" value="<?= $row['username']; ?>">
</td>
<td><?php //$row['password']; ?>
<input type="text" name="password[]" value="<?= $row['password']; ?>">
</td>
<td><?php //$row['stat_us']; ?><?php //$row['permission']; ?>
<input type="text" name="stat_us[]" value="<?= $row['stat_us']; ?>">
<input type="text" name="permission[]" value="<?= $row['permission']; ?>">
</td>
<td>
<?php //$row['targetdate']; ?>
<input type="text" name="targetdate[]" value="<?= $row['targetdate']; ?>">
</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'];
}
//$resume=$row1['resume'];
$query2 = "SELECT * FROM new_resume Where user='$id' ORDER BY id ASC";
$result2 = $conn->query($query2);
//$sr=1;
while ($row2 = $result2->fetch_assoc())
{
// $id=$row['id'];
//$resume=$row2['resume'];
}
?>
<td><?= $total; ?>
<?php //echo $row2['resume']; ?>
<!--<input type="text" name="resume[]" value="<?php echo $resume; ?>">-->
<!--<input type="text" name="resume[]" value="<?php echo $row2['resume']; ?>">-->
<!--<input type="text" name="resume[]" value="<?php echo $row2['resume']; ?>">-->
</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><input type="text" name="status[]" value="<?= $row['status']; ?>"></td>
<td><a href="send_mail.php?edit=<?= $row['id']; ?>" class="btn btn-primary">SendMail</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>
</form>
</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 = "login_details.php";
});
</script>
<?php
unset($_SESSION['status']);
}
?>
<?php
include "footer.php";
?>