|
Server IP : 103.191.208.227 / Your IP : 3.138.122.24 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);
if(isset($_POST['submit'])){
$id=$_POST['id'];
$sl_no=$_POST['sl_no'];
$pa_fname = $_POST['pa_fname'];
$pa_lname = $_POST['pa_lname'];
$pa_address = $_POST['pa_address'];
$pa_email = $_POST['pa_email'];
$pa_contact = $_POST['pa_contact'];
$pa_dob =$_POST['pa_dob'];
$pa_city= $_POST['pa_city'];
$pa_state = $_POST['pa_state'];
$pa_zipcode= $_POST['pa_zipcode'];
$pa_medical_claim_no =$_POST['pa_medical_claim_no'];
$dr_fname =$_POST['dr_fname'];
$dr_lname = $_POST['dr_lname'];
$dr_physical_address =$_POST['dr_physical_address'];
$dr_phone = $_POST['dr_phone'];
$dr_city = $_POST['dr_city'];
$dr_email = $_POST['dr_email'];
$ag_fname=$_POST['ag_fname'];
$ag_lname= $_POST['ag_lname'];
$ag_contact =$_POST['ag_contact'];
$ag_physical_address = $_POST['ag_physical_address'];
$ag_state = $_POST['ag_state'];
$ag_zip_code = $_POST['ag_zip_code'];
$ag_dob = $_POST['ag_dob'];
$ag_email = $_POST['ag_email'];
$query="UPDATE form_data SET sl_no=?,pa_fname=?,pa_lname=?,pa_address=?,pa_email=?,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=? WHERE id=?";
$stmt=$conn->prepare($query);
$stmt->bind_param("ssssssssssssssssssssssssss",$sl_no,$pa_fname,$pa_lname,$pa_address,$pa_email,$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,$id);
$res= $stmt->execute();
if ($res) {
/*header('location:editform.php?edit='. $row['img_id'].'');*/
}
else
{
// header('location:updateform.php?Something Wrong');
echo "error";
}
}
?>
<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></th>
<th>Remark</th>
</tr>
</thead>
<tbody>
<?php while ($row= $result->fetch_assoc()) { $id=$row['id']; ?>
<tr>
<form method="post" action="aa.php">
<td><input type="text" name="sl_no" value="<?= $row['sl_no']; ?>"><input type="hidden" name="id" value="<?= $row['id']; ?>"> </td>
<td><input type="text" name="pa_fname" value="<?= $row['pa_fname']; ?>"> </td>
<td><input type="text" name="pa_lname" value="<?= $row['pa_lname']; ?>"></td>
<td><input type="text" name="pa_address" value="<?= $row['pa_address']; ?>"></td>
<td> <input type="text" name="pa_email" value="<?= $row['pa_email']; ?>"> </td>
<td> <input type="text" name="pa_contact" value="<?= $row['pa_contact']; ?>"></td>
<td> <input type="text" name="pa_dob" value="<?= $row['pa_dob']; ?>"></td>
<td> <input type="text" name="pa_city" value="<?= $row['pa_city']; ?>"></td>
<td> <input type="text" name="pa_state" value="<?= $row['pa_state']; ?>"></td>
<td> <input type="text" name="pa_zipcode" value="<?= $row['pa_zipcode']; ?>"></td>
<td> <input type="text" name="pa_medical_claim_no" value="<?= $row['pa_medical_claim_no']; ?>"></td>
<td> <input type="text" name="dr_fname" value="<?= $row['dr_fname']; ?>"></td>
<td> <input type="text" name="dr_lname" value="<?= $row['dr_lname']; ?>"></td>
<td><input type="text" name="dr_physical_address" value="<?= $row['dr_physical_address']; ?>"></td>
<td><input type="text" name="dr_phone" value="<?= $row['dr_phone']; ?>"></td>
<td> <input type="text" name="dr_city" value="<?= $row['dr_city']; ?>"></td>
<td> <input type="text" name="dr_email" value="<?= $row['dr_email']; ?>"></td>
<td> <input type="text" name="ag_fname" value="<?= $row['ag_fname']; ?>"></td>
<td> <input type="text" name="ag_lname" value="<?= $row['ag_lname']; ?>"></td>
<td><input type="text" name="ag_contact" value="<?= $row['ag_contact']; ?>"></td>
<td> <input type="text" name="ag_physical_address" value="<?= $row['ag_physical_address']; ?>"></td>
<td> <input type="text" name="ag_state" value="<?= $row['ag_state']; ?>"></td>
<td> <input type="text" name="ag_zip_code" value="<?= $row['ag_zip_code']; ?>"></td>
<td> <input type="text" name="ag_dob" value="<?= $row['ag_dob']; ?>"></td>
<td><input type="text" name="ag_email" value="<?= $row['ag_email']; ?>"></td>
<td><a href="updateform2.php?edit=<?= $row['id']; ?>" class="btn btn-success">Edit</a></td>
<td><input type="submit" name="submit" class="btn btn-info" value="Save"></td>
</form>
</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>
</main>
<?php
include "footer.php";
?>