|
Server IP : 103.191.208.227 / Your IP : 18.219.229.1 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 (0755) : /home/mhmsfzcs/vflyorions.com/.well-known/../../www/../gemsandpearl.com/admin/ |
| [ Home ] | [ C0mmand ] | [ Upload File ] |
|---|
<?php
include 'db.php';
include 'header.php';
include 'sidebar.php';
$image='';
if (isset($_POST['change']))
{
$id=$_POST['id'];
$name=$_POST['heading'];
$short_desc=$_POST['short_desc'];
$about=$_POST['about'];
$benefits=$_POST['benefits'];
$wear=$_POST['wear'];
$insert2 = $conn->prepare("UPDATE `gemstone_sub_category` SET `name`=?,`short_desc`=?,`about`=?,`benefits`=?,`wear`=? WHERE sub_cat_id=?" );
$insert2->bind_param("ssssss",$name,$short_desc,$about,$benefits,$wear,$id);
$res=$insert2->execute();
if($res)
{
$_SESSION['status']="Updated Successfully";
$_SESSION['status_code']="success";
}
else
{
$_SESSION['status']="Oops something went wrong!!";
$_SESSION['status_code']="error";
}
}
if(isset($_GET['delete']))
{
$ad=$_GET['delete'];
$query=$conn->prepare("delete from gemstone_sub_category where sub_cat_id =?");
$query->bind_param("s",$ad);
$res=$query->execute();
if($res)
{
$_SESSION['status']="User Deleted Successfully";
$_SESSION['status_code']="success";
}
else
{
$_SESSION['status']="Oops something went wrong!!";
$_SEESION['status_code']="error";
}
}
?>
<!-- Content Wrapper. Contains page content -->
<div class="content-wrapper">
<!-- Content Header (Page header) -->
<div class="content-header">
<div class="container-fluid">
<div class="row mb-2">
<div class="col-sm-6">
<h1 class="m-0">Dashboard</h1>
</div><!-- /.col -->
<div class="col-sm-6">
<ol class="breadcrumb float-sm-right">
<li class="breadcrumb-item"><a href="#">Home</a></li>
<li class="breadcrumb-item active">Dashboard</li>
</ol>
</div><!-- /.col -->
</div><!-- /.row -->
</div><!-- /.container-fluid -->
</div>
<!-- /.content-header -->
<!-- Main content -->
<section class="content">
<div class="container-fluid">
<div class="card">
<div class="card-header">
<h3 class="card-title">Manage Product</h3>
</div>
<!-- /.card-header -->
<div class="card-body">
<table id="example1" class="table table-bordered table-striped">
<thead>
<tr>
<th>Sr. No.</th>
<th>Sub Category Name</th>
<th>Short Description</th>
<th>About</th>
<th>Benefits</th>
<th>How to Wear</th>
<th>Action</th>
</tr>
</thead>
<tbody>
<?php
$que="SELECT * from gemstone_sub_category";
$r=$conn->query($que);
$sr=1;
while($row=$r->fetch_assoc())
{
$id=$row['sub_cat_id'];
?>
<tr>
<td><?php echo $sr;?></td>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['short_desc'];?></td>
<td><?php echo $row['about'];?></td>
<td><?php echo $row['benefits'];?></td>
<td><?php echo $row['wear'];?></td>
<td><a href="sub_category.php?delete=<?= $row['sub_cat_id']; ?>" onclick="return confirm('Are you sure to delete?')" class="btn btn-danger">Delete</a>
<button type="button" class="btn btn-success" data-toggle="modal" data-target="#modal-default<?php echo $id;?>" data-id="<?php echo $id; ?>">
<i class="mdi mdi-pencil label-icon"></i>Edit
</button>
</td>
</tr>
<div class="modal fade" id="modal-default<?php echo $id;?>">
<?php
$consdata = $conn->prepare("SELECT * from gemstone_sub_category WHERE sub_cat_id=?");
mysqli_stmt_bind_param($consdata,"s",$id);
$consdata->execute();
$result5=$consdata->get_result();
while($row5=$result5->fetch_assoc())
{
?>
<div class="modal-dialog" style="max-width: 1000px;">
<div class="modal-content">
<div class="modal-header">
<h4 class="modal-title">Edit</h4>
<button type="button" class="close" data-dismiss="modal" aria-label="Close">
<span aria-hidden="true">×</span>
</button>
</div>
<div class="modal-body">
<form method="post" enctype="multipart/form-data">
<div class="card-body">
<div class="form-group">
<label>Sub Category Name </label>
<input type="text" data-pristine-required-message="Please Enter a Heading" name="heading" class="form-control" value="<?php echo $row5['name'];?>" />
<input type="hidden" name="id" class="form-control" value="<?php echo $row5['sub_cat_id'];?>">
</div>
<div class="form-group">
<label>Short Description</label>
<input type="text" data-pristine-required-message="Please Enter a price" name="short_desc" class="form-control" value="<?php echo $row5['short_desc'];?>" />
</div>
<div class="form-group">
<label>About </label>
<input type="text" data-pristine-required-message="Please Enter a carat" name="about" class="form-control" value="<?php echo $row5['about'];?>" />
</div>
<div class="form-group">
<label>Benefits </label>
<input type="text" data-pristine-required-message="Please Enter a ratti" name="benefits" class="form-control" value="<?php echo $row5['benefits'];?>" />
</div>
<div class="form-group">
<label>How to Wear </label>
<input type="text" data-pristine-required-message="Please Enter a ratti" name="wear" class="form-control" value="<?php echo $row5['wear'];?>" />
</div>
</div>
<!--card-body -->
<div class="modal-footer justify-content-between">
<button type="button" class="btn btn-default" data-dismiss="modal">Close</button>
<button type="submit" name="change" class="btn btn-primary">Save changes</button>
</div>
</form>
</div>
</div>
<!--/.modal-content -->
</div>
<!--/.modal-dialog -->
<?php } ?>
</div>
<?php
$sr=$sr+1;}
?>
</tbody>
</table>
</div>
<!-- /.card-body -->
</div>
<!-- /.card -->
</div>
<!-- /.row -->
</div><!--/. container-fluid -->
</section>
<!-- /.content -->
</div>
<!-- /.content-wrapper -->
<!-- Control Sidebar -->
<aside class="control-sidebar control-sidebar-dark">
<!-- Control sidebar content goes here -->
</aside>
<!-- /.control-sidebar -->
<!-- <script src="https://ajax.googleapis.com/ajax/libs/jquery/3.5.1/jquery.min.js"></script>
<script type="text/javascript">
$(document).ready(function()
{
$("#site").change(function()
{
var site_id=$(this).val();
var post_id = 'id='+ site_id;
$.ajax
({
type: "POST",
url: "fetch.php",
data: post_id,
cache: false,
success: function(cities)
{
$("#cp").html(cities);
}
});
});
});
</script> -->
<script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>
<?php if(isset($_SESSION['status']) && $_SESSION['status']!='') { ?>
<script>
new swal({
title: "<?php echo $_SESSION['status'];?>",
//text: "You clicked the button!",
icon: "<?php echo $_SESSION['status_code'];?>",
button: "OK",
}).then(function() {
window.location = "sub_category.php";
});
</script>
<?php
unset($_SESSION['status']);
}
?>
<?php include 'footer.php'; ?>