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/www/website_93b53270/admin/manage_oil/ |
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
$id=$_GET['id'];
?>
<!-- [ 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 text-light fw-bold btn-sm btn-round has-ripple"><i class="feather icon-edit"></i> Add | Edit | Oil </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['img_error'])){
echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
<i class="feather icon-alert-triangle text-danger"></i> <strong class="text-dark">'.$_SESSION['img_error'].'</strong>
<button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close">
</button>
</div>';
}
unset($_SESSION['img_error']);
?>
<?php
$fetQuery=mysqli_fetch_array(mysqli_query($conn,"SELECT * FROM oil_tbl WHERE id='$id'"));
?>
<form method="post" action="" enctype="multipart/form-data" autocomplete="off">
<div class="row">
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Service">Service Category</label>
<select class="form-select" name="cat_id" required>
<option value="">Select service category</option>
<?php
$serQry=mysqli_query($conn,"SELECT * FROM `sevice_tbl` WHERE id!=1 AND status=1 ORDER BY id ASC");
while($row=mysqli_fetch_array($serQry)){
?>
<option value="<?=$row['id']?>" <?php if($id!='' && $fetQuery['cat_id']==$row['id']){ echo 'selected';} ?>><?=$row['title']?></option>
<?php } ;?>
</select>
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Title">Title</label>
<input type="text" name="title" class="form-control" value="<?php if($id!=''){echo $fetQuery['title'];} ?>">
</div>
</div>
<div class="col-md-4">
<div class="form-group">
<label class="form-label" for="Mobil">Mobil Code</label>
<input type="text" name="mobil_code" class="form-control" value="<?php if($id!=''){echo $fetQuery['mobil_code'];} ?>">
</div>
</div>
<div class="col-md-12">
<div class="form-group">
<label class="form-label" for="About">About</label>
<textarea name="about" class="form-control" id="editor1"><?php if($id!=''){echo $fetQuery['about'];} ?></textarea>
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Price">Price</label>
<input type="text" name="price" class="form-control" value="<?php if($id!=''){echo $fetQuery['price'];} ?>">
</div>
</div>
<div class="col-md-6">
<div class="form-group">
<label class="form-label" for="Status">Status</label>
<select class="form-select" name="status" required>
<option value="">Please select status</option>
<option value="1" <?=($fetQuery['status']=='1')?'selected':'';?>>Show</option>
<option value="0" <?=($fetQuery['status']=='0')?'selected':'';?>>Hide</option>
</select>
</div>
</div>
</div>
<div class="row">
<div class="col-md-6">
<?php
if(($id!='')){
echo'<input type="submit" name="update" class="btn btn-success" value="Update">';
}else{
echo'<input type="submit" name="add" class="btn btn-success" value="Add">';
}
?>
<button class="btn btn-dark"><a class="text-white" href="show.php?page=oi">Back</a></button>
</div>
</div>
</form>
</div>
</div>
</div>
<!-- [ form-element ] end -->
</div>
<!-- [ Main Content ] end -->
</div>
</section>
<?php include('../include/footer.php'); ?>
<!-- Insert data start --->
<?php
if(isset($_POST['add'])){
$cat_id=$_POST['cat_id'];
$cat_id=str_replace("'", "\'", $cat_id);
$title=$_POST['title'];
$title=str_replace("'", "\'", $title);
$mobil_code=$_POST['mobil_code'];
$mobil_code=str_replace("'", "\'", $mobil_code);
$about=$_POST['about'];
$about=str_replace("'", "\'", $about);
$price=$_POST['price'];
$price=str_replace("'", "\'", $price);
$status=$_POST['status'];
$addQry=mysqli_query($conn,
"INSERT `oil_tbl` SET
`cat_id`='$cat_id',
`title`='$title',
`mobil_code`='$mobil_code',
`about`='$about',
`price`='$price',
`status`='$status'")or die(mysqli_error($conn));
if($addQry){
echo "<script>window.location='show.php?page=oi';</script>";
$_SESSION['message']="Record Insertted successfully";
}
}
?>
<!-- Insert data warp --->
<!-- Update data start --->
<?php
if(isset($_POST['update'])){
$cat_id=$_POST['cat_id'];
$cat_id=str_replace("'", "\'", $cat_id);
$title=$_POST['title'];
$title=str_replace("'", "\'", $title);
$mobil_code=$_POST['mobil_code'];
$mobil_code=str_replace("'", "\'", $mobil_code);
$about=$_POST['about'];
$about=str_replace("'", "\'", $about);
$price=$_POST['price'];
$price=str_replace("'", "\'", $price);
$status=$_POST['status'];
$editQry=mysqli_query($conn,"UPDATE `oil_tbl` SET
`cat_id`='$cat_id',
`title`='$title',
`mobil_code`='$mobil_code',
`about`='$about',
`price`='$price',
`status`='$status' WHERE id='$id'")or die(mysqli_error($conn));
if($editQry){
echo "<script>window.location='show.php?page=oi';</script>";
$_SESSION['message']="Record Updated successfully";
}
}
?>
<!-- Update data warp --->