Server : ApacheSystem : Linux sh00666.bluehost.com 5.14.0-687.26.1.el9_8.x86_64 #1 SMP PREEMPT_DYNAMIC Tue Jul 14 16:32:02 EDT 2026 x86_64 User : ndkhermy ( 1200) PHP Version : 8.5.12 Disable Function : NONE Directory : /home1/ndkhermy/public_html/website_93b53270/admin/manage_appointment/ |
Upload File : |
<?php
error_reporting(0);
include("../function.php");
if($_SESSION['admin_id']==""){
header('location:../login.php');
}
$login_tbl=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM admin WHERE admin_id='".$_SESSION['admin_id']."'"));
// Sidebar strat
include('../include/sidebar.php');
// Sidebar wrap
?>
<!-- [ Main Content ] start -->
<section class="pcoded-main-container">
<div class="pcoded-content">
<!-- [ breadcrumb ] start -->
<div class="page-header">
<div class="page-block">
<div class="row align-items-center">
<div class="col-md-12">
<div class="page-header-title">
<div class="card-header d-flex justify-content-between">
<button class="btn btn-dark btn-sm btn-round fw-bold has-ripple text-white"><i class="feather icon-edit"></i> Manage Appointments</button>
</div>
</div>
</div>
</div>
</div>
</div>
<!-- [ breadcrumb ] end -->
<!-- [ Main Content ] start -->
<div class="row">
<div class="col-md-12">
<div class="card">
<!-- <div class="card-header d-flex justify-content-between">
</div> -->
<div class="card-body">
<?php if(isset($_SESSION['message'])){
echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
<i class="feather icon-thumbs-up text-success"></i> <strong class="text-dark">'.$_SESSION['message'].'</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['message']);
?>
<?php
$fetQuery1=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `appointment_tbl` WHERE id=1"));
?>
<form method="post" action="" enctype="multipart/form-data" autocomplete="off">
<div class="row">
<h6>Manage Appointments</h6>
<br>
<hr><h5 style="text-align: center; color: white; background: #d54142; padding: 19px 0px;">Car pickup section</h5><hr>
<br>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="image1">Car pickup image</label>
<input type="file" name="image1" id="picture" class="form-control mb-2">
<p id="error1" style="display:none; color:#FF0000;">
Invalid File Format! File Format Must Be JPG, JPEG, PNG , Webp.
</p>
<p id="error2" style="display:none; color:#FF0000;">
File size must be less than 20MB
</p>
<?php if($fetQuery1['image1']!=''){ ?>
<img src="<?=$base_url?>images/Upload/appointment/<?=$fetQuery1['image1']?>" class="pb-2" style="width:100px; height: 80px;">
<?php } ?>
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label class="form-label" for="Valet_driver">Valet driver price</label>
<input type="text" name="valet_driver1" value="<?=$fetQuery1['valet_driver1']?>" class="form-control">
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label class="form-label" for="Tow">Tow truck price</label>
<input type="text" name="tow_truck1" value="<?=$fetQuery1['tow_truck1']?>" class="form-control">
</div>
</div>
<br>
<hr><h5 style="text-align: center; color: white; background: #d54142; padding: 19px 0px;">Car drop-off section</h5><hr>
<br>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="image2">Car drop-off image</label>
<input type="file" name="image2" id="picture1" class="form-control mb-2">
<p id="error3" style="display:none; color:#FF0000;">
Invalid File Format! File Format Must Be JPG, JPEG, PNG , Webp.
</p>
<p id="error4" style="display:none; color:#FF0000;">
File size must be less than 20MB
</p>
<?php if($fetQuery1['image2']!=''){ ?>
<img src="<?=$base_url?>images/Upload/appointment/<?=$fetQuery1['image2']?>" class="pb-2" style="width:100px; height: 80px;">
<?php } ?>
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label class="form-label" for="Valet">Valet driver price</label>
<input type="text" name="valet_driver2" value="<?=$fetQuery1['valet_driver2']?>" class="form-control">
</div>
</div>
<div class="col-md-3">
<div class="form-group">
<label class="form-label" for="Tow_truck">Tow truck price</label>
<input type="text" name="tow_truck2" value="<?=$fetQuery1['tow_truck2']?>" class="form-control">
</div>
</div>
<hr>
<div class="text-center py-2" style="background: #d54142;"><h3 class="text-white">Instant Section</h3></div>
<br>
<hr>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Instant">Instant Charge</label>
<input type="number" name="instant" id="Instant" value="<?=$fetQuery1['instant']?>" class="form-control">
</div>
</div>
<br>
<hr><h5 style="text-align: center; color: white; background: #d54142; padding: 19px 0px;">Charges section</h5><hr>
<br>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Valet">Minor service Charge</label>
<input type="text" name="minor_charg" value="<?=$fetQuery1['minor_charg']?>" class="form-control">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Valet">Labor Charges</label>
<input type="text" name="labor_charg" value="<?=$fetQuery1['labor_charg']?>" class="form-control">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="VAT">VAT%</label>
<input type="text" name="vat" value="<?=$fetQuery1['vat']?>" class="form-control">
</div>
</div>
<div class="row">
<div class="col-md-6">
<input type="submit" name="update" class="btn btn-danger" value="Update">
</div>
</div>
</form>
</div>
</div>
</div>
<!-- [ form-element ] end -->
</div>
<!-- [ Main Content ] end -->
</div>
</section>
<!-- Required Js -->
</body>
<?php include('../include/footer.php'); ?>
<!-- About data start --->
<?php
if(isset($_POST['update'])){
$valet_driver1=str_replace("'", "\'", $_POST['valet_driver1']);
$valet_driver2=str_replace("'", "\'", $_POST['valet_driver2']);
$tow_truck1=str_replace("'", "\'", $_POST['tow_truck1']);
$tow_truck2=str_replace("'", "\'", $_POST['tow_truck2']);
$minor_charg=str_replace("'", "\'", $_POST['minor_charg']);
$labor_charg=str_replace("'", "\'", $_POST['labor_charg']);
$instant=str_replace("'", "\'", $_POST['instant']);
$vat=str_replace("'", "\'", $_POST['vat']);
$file_name1=$_FILES['image1']['name'];
$file_tmp1=$_FILES['image1']['tmp_name'];
$file_ext1=strtolower(end(explode('.',$_FILES['image1']['name'])));
$file_name2=$_FILES['image2']['name'];
$file_tmp2=$_FILES['image2']['tmp_name'];
$file_ext2=strtolower(end(explode('.',$_FILES['image2']['name'])));
if(!empty($file_name1)){
$random_number1 = rand();
$new_file_name1 = $random_number1.'.'.$file_ext1;
$file_path1="../../images/Upload/appointment/".$new_file_name1;
$dlt1=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `appointment_tbl` WHERE id='1'"));
$dlt_path1="../../images/Upload/appointment/".$dlt1['image1'];
unlink($dlt_path1);
move_uploaded_file($file_tmp1,$file_path1);
$sql="UPDATE `appointment_tbl` SET `image1`='$new_file_name1' WHERE id='1'";
$query=mysqli_query($conn,$sql);
}
if(!empty($file_name2)){
$random_number2 = rand();
$new_file_name2 = $random_number2.'.'.$file_ext2;
$file_path2="../../images/Upload/appointment/".$new_file_name2;
$dlt2=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM `appointment_tbl` WHERE id='1'"));
$dlt_path2="../../images/Upload/appointment/".$dlt2['image2'];
unlink($dlt_path2);
move_uploaded_file($file_tmp2,$file_path2);
$sql="UPDATE `appointment_tbl` SET `image2`='$new_file_name2' WHERE id='1'";
$query=mysqli_query($conn,$sql);
}
mysqli_query($conn,"UPDATE `appointment_tbl` SET
`valet_driver1`='$valet_driver1',
`valet_driver2`='$valet_driver2',
`minor_charg`='$minor_charg',
`labor_charg`='$labor_charg',
`instant`='$instant',
`vat`='$vat',
`tow_truck1`='$tow_truck1',
`tow_truck2`='$tow_truck2' WHERE id='1'")or die(mysqli_error($conn));
echo "<script>window.location='show.php?page=appo';</script>";
$_SESSION['message']="Record Updated successfully";
}
?>
<!-- About data warp --->