|
Server IP : 103.191.208.227 / Your IP : 3.12.71.211 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 "header.php";
$img="";
if(isset($_GET['edit'])){
$img_id=$_GET['edit'];
$stmt1=("SELECT * FROM form_data WHERE img_id='$img_id' AND user_id='$log_id'");
$result1 = $conn->query($stmt1);
$row1= $result1->fetch_assoc();
$img=$row1['img_name'];
//$stmt=("SELECT * FROM form_data WHERE img_id='$img_id' AND user_id='$log_id'");
$stmt=("SELECT DISTINCT id,sl_no,pa_fname,pa_lname,pa_email,pa_address,pa_contact,pa_dob,pa_city,pa_state,pa_zipcode,pa_medical_claim_no,dr_fname,dr_lname,dr_physical_address,dr_phone,dr_city,dr_email,ag_fname,ag_lname,ag_contact,ag_physical_address,ag_state,ag_zip_code,ag_dob,ag_email FROM form_data
WHERE img_id='$img_id' AND user_id='$log_id' GROUP BY sl_no,pa_fname,pa_lname,pa_email,pa_address,pa_contact,pa_dob,pa_city,pa_state,pa_zipcode,pa_medical_claim_no,dr_fname,dr_lname,dr_physical_address,dr_phone,dr_city,dr_email,ag_fname,ag_lname,ag_contact,ag_physical_address,ag_state,ag_zip_code,ag_dob,ag_email ORDER BY id ASC");
$result = $conn->query($stmt);
?>
<style>
.header {
height: 66px;
}
img {
width: 63px;
}
.card-title {
padding: 8px 0 0px 0;
}
#main {
margin-top: 68px;
}
.card-sizeh{
height:620px;
margin-left: -17px;"
}
@media only screen and (max-width: 600px)
{
.card-sizeh{
height:260px;
margin-left: -17px;"
}
}
</style>
<main id="main" class="main" style="margin-left: 0px;">
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper" style="height: 38rem;" >
<!-- Content Header (Page header) -->
<section class="section dashboard">
<div class="row">
<!-- Left side columns -->
<div class="col-lg-12">
<div class="row">
<!-- Sales Card -->
<div class="col-sm-6" >
<div class="card info-card sales-card card-sizeh" style="">
<div>
<h4 style="font-family: Times New Roman;font-size: 19px;"><b> Image Name : <?php echo $img; ?></b></h4>
<a href="saved_resume.php"><input type="button" class="btn btn-dark" value="<--Back" style="float:right; margin-right:2%"></a>
<button onclick="zoomIn()" class="btn btn-danger" style="font-size: 10px;">Zoom-In</button>
<button onclick="zoomOut()" class="btn btn-dark" style="font-size: 10px;">Zoom-Out</button><br>
</div>
<div class="card-body" style="height: 550px; max-height: 82vh;overflow-y: scroll;">
<div class="card-title">
</div>
<img src="assets/img/<?php echo $img; ?>" id="pic" class="card-img-bottom" alt="..." style="height:auto;">
</div>
</div>
</div>
<!-- End Sales Card -->
<div class="col-sm-6" >
<div class="card info-card sales-card card-sizeh" style="">
<div class="card-body" style="height: 550px; max-height: 82vh;overflow-y: scroll;">
<div class="card-body">
<table id="example1" class="table table-bordered table-striped datatable">
<thead>
<tr>
<!--<th>Sr.no</th>-->
<!--<th>pa fname</th>-->
<!--<th>pa lname</th>-->
<!--<th>pa email</th>-->
<!--<th>pa address</th>-->
<!--<th>pa contact</th>-->
<!--<th>pa dob</th>-->
<!--<th>pa city</th>-->
<!--<th>pa state</th>-->
<!--<th>pa zipcode</th>-->
<!--<th>pa medical claim no</th>-->
<!--<th>Dr Fname</th>-->
<!--<th>Dr Lname</th>-->
<!--<th>Dr physical address</th>-->
<!--<th>Dr contact</th>-->
<!--<th>Dr city</th>-->
<!--<th>Dr email</th>-->
<!--<th>ag Fname</th>-->
<!--<th>ag Lname</th>-->
<!--<th>ag contact</th>-->
<!--<th>ag physical address</th>-->
<!--<th>ag state</th>-->
<!--<th>ag zip code</th>-->
<!--<th>ag DOB</th>-->
<!--<th>ag email</th>-->
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th></th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<th> </th>
<!--<th> </th>-->
<!--<th> </th>-->
<th>Remark</th>
<th>Delete</th>
</tr>
</thead>
<tbody>
<?php while ($row= $result->fetch_assoc()) { $id=$row['id']; ?>
<tr>
<td><?= $row['sl_no']; ?> </td>
<td><?= $row['pa_fname']; ?> </td>
<td><?= $row['pa_lname']; ?> </td>
<td><?= $row['pa_address']; ?> </td>
<td><?= $row['pa_email']; ?> </td>
<td><?= $row['pa_contact']; ?> </td>
<td><?= $row['pa_dob']; ?> </td>
<td><?= $row['pa_city']; ?> </td>
<td><?= $row['pa_state']; ?> </td>
<td><?= $row['pa_zipcode']; ?> </td>
<td><?= $row['pa_medical_claim_no']; ?> </td>
<td><?= $row['dr_fname']; ?> </td>
<td><?= $row['dr_lname']; ?> </td>
<td><?= $row['dr_physical_address']; ?> </td>
<td><?= $row['dr_phone']; ?> </td>
<td><?= $row['dr_city']; ?> </td>
<td><?= $row['dr_email']; ?> </td>
<td><?= $row['ag_fname']; ?> </td>
<td><?= $row['ag_lname']; ?> </td>
<td><?= $row['ag_contact']; ?> </td>
<td><?= $row['ag_physical_address']; ?> </td>
<td><?= $row['ag_state']; ?> </td>
<td><?= $row['ag_zip_code']; ?> </td>
<!--<td><?= $row['ag_dob']; ?> </td>-->
<!--<td><?= $row['ag_email']; ?> </td>-->
<td><a href="updateform2.php?edit=<?= $row['id']; ?>" class="btn btn-success">Edit</a></td>
<td> <button value="<?= $row['id']; ?>" class="btn btn-danger delete-btn">Delete</button></td>
</tr>
<?php ;} } ?>
</tbody>
</table>
</div>
</div>
</div>
</div>
<!-- End Sales Card -->
</div>
</div>
<!-- End Left side columns -->
</div>
</section>
</div>
<script>
function zoomIn() {
var pic = document.getElementById("pic");
var width = pic.clientWidth;
pic.style.width = width + 100 + "px";
}
function zoomOut() {
var pic = document.getElementById("pic");
var width = pic.clientWidth;
pic.style.width = width - 100 + "px";
}
</script>
<script>
document.addEventListener('contextmenu', event=> event.preventDefault());
document.onkeydown = function(e) {
if(event.keyCode == 123) {
return false;
}
if(e.ctrlKey && e.shiftKey && e.keyCode == 'I'.charCodeAt(0)){
return false;
}
if(e.ctrlKey && e.shiftKey && e.keyCode == 'J'.charCodeAt(0)){
return false;
}
if(e.ctrlKey && e.shiftKey && e.keyCode == 'C'.charCodeAt(0)){
return false;
}
if(e.ctrlKey && e.keyCode == 'U'.charCodeAt(0)){
return false;
}
}
</script>
<script src="https://code.jquery.com/jquery-3.6.0.min.js"></script>
<script>
var $jq = jQuery.noConflict();
$jq(document).ready(function() {
$jq(document).on('click', '.delete-btn', function() {
var id = $(this).val(); // Get the ID from the button value
var result = confirm("Are you sure you want to delete this data?");
if(result) {
$.ajax({
url: 'delete_data.php', // URL to your PHP delete script
type: 'POST',
data: { id: id },
success: function(response) {
if(response == 1) {
alert('Data deleted successfully.');
location.reload(); // Reload the page to reflect changes
} else {
alert('Failed to delete data.');
}
}
});
}
});
});
</script>
</script>
</main>
<?php
include "footer.php";
?>