ikan Uploader :
Directory : /home/u956822991/domains/salsabeelwatertech.com/public_html/admin/
Upload File : |
| Current File : /home/u956822991/domains/salsabeelwatertech.com/public_html/admin/manageproducts.php |
<?php
session_start();
include('include/config.php');
$username = $_SESSION['alogin'];
if(strlen($_SESSION['alogin'])==0)
{
header('location:index.php');
}
else{
date_default_timezone_set('Asia/Kolkata');// change according timezone
$currentTime = date( 'd-m-Y h:i:s A', time () );
if(isset($_GET['del']))
{
mysqli_query($con,"delete from products where id = '".$_GET['id']."'");
$_SESSION['delmsg']="Product deleted !!";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Manage Products | Admin</title>
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta content="A fully featured admin theme which can be used to build CRM, CMS, etc." name="description" />
<meta content="Coderthemes" name="author" />
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<!-- App favicon -->
<link rel="shortcut icon" href="assets/images/favicon.ico">
<!-- Bootstrap Css -->
<link href="assets/css/bootstrap.min.css" id="bootstrap-stylesheet" rel="stylesheet" type="text/css" />
<!-- Icons Css -->
<link href="assets/css/icons.min.css" rel="stylesheet" type="text/css" />
<!-- App Css-->
<link href="assets/css/app.min.css" id="app-stylesheet" rel="stylesheet" type="text/css" />
</head>
<body>
<!-- Begin page -->
<div id="wrapper">
<!-- Header Topbar -->
<?php include('include/header.php');?>
<!-- end Header Topbar -->
<!-- ========== Left Sidebar Start ========== -->
<div class="left-side-menu">
<div class="slimscroll-menu">
<?php include('include/leftsidestart.php');?>
<?php include('include/sidebar.php');?>
<div class="clearfix"></div>
</div>
<!-- Sidebar -left -->
</div>
<!-- Left Sidebar End -->
<!-- ============================================================== -->
<!-- Start Page Content here -->
<!-- ============================================================== -->
<div class="content-page">
<div class="content">
<!-- Start Content-->
<div class="container-fluid">
<div class="row">
<div class="col-12">
<div class="card-box">
<h4 class="mt-0 header-title">Default Example</h4>
<?php if(isset($_GET['del']))
{?>
<div class="alert alert-error">
<button type="button" class="close" data-dismiss="alert">×</button>
<strong><p style="color:red;" style="font-size:50px;">Oh snap!</strong> <?php echo htmlentities($_SESSION['delmsg']);?><?php echo htmlentities($_SESSION['delmsg']="");?></p>
</div>
<?php } ?>
<br />
<table id="datatable" class="table table-bordered dt-responsive nowrap">
<thead>
<center>
<tr>
<th>#</th>
<th>Product Name</th>
<th>Category </th>
<th>Company Name</th>
<th>Product Creation Date</th>
</tr>
</center>
</thead>
<tbody>
<?php $query=mysqli_query($con,"select products.*,category.categoryName from products join category on category.id=products.category order by id desc");
$cnt=1;
while($row=mysqli_fetch_array($query))
{
?>
<tr>
<td><?php echo htmlentities($cnt);?></td>
<td><?php echo htmlentities($row['productName']);?></td>
<td><?php echo htmlentities($row['categoryName']);?></td>
<td><?php echo htmlentities($row['productCompany']);?></td>
<td><?php echo htmlentities($row['postingDate']);?></td>
<td>
<a href="edit-products.php?id=<?php echo $row['id']?>" > <button type="button" class="btn btn-bordered-success waves-effect width-md waves-light">
Edit
</button></a>
<a href="manageproducts.php?id=<?php echo $row['id']?>&del=delete" onClick="return confirm('Are you sure you want to delete?')">
<button type="button" class="btn btn-bordered-danger waves-effect width-md waves-light">
Delete
</button></i></a></td>
</tr>
<?php $cnt=$cnt+1; } ?>
</tbody>
</table>
</div>
</div>
</div> <!-- end row -->
</div> <!-- container-fluid -->
</div> <!-- content -->
<!-- Footer Start -->
<?php include('include/footer.php');?>
<!-- end Footer -->
</div>
<!-- ============================================================== -->
<!-- End Page content -->
<!-- ============================================================== -->
</div>
<!-- END wrapper -->
<!-- Right bar overlay-->
<!-- Vendor js -->
<script src="assets/js/vendor.min.js"></script>
<!-- Validation js (Parsleyjs) -->
<script src="assets/libs/parsleyjs/parsley.min.js"></script>
<!-- validation init -->
<script src="assets/js/pages/form-validation.init.js"></script>
<!-- App js -->
<script src="assets/js/app.min.js"></script>
<!-- Vendor js -->
<script src="assets/js/vendor.min.js"></script>
<!-- third party js -->
<script src="assets/libs/datatables/jquery.dataTables.min.js"></script>
<script src="assets/libs/datatables/dataTables.bootstrap4.js"></script>
<script src="assets/libs/datatables/dataTables.responsive.min.js"></script>
<script src="assets/libs/datatables/responsive.bootstrap4.min.js"></script>
<script src="assets/libs/datatables/dataTables.buttons.min.js"></script>
<script src="assets/libs/datatables/buttons.bootstrap4.min.js"></script>
<script src="assets/libs/datatables/buttons.html5.min.js"></script>
<script src="assets/libs/datatables/buttons.flash.min.js"></script>
<script src="assets/libs/datatables/buttons.print.min.js"></script>
<script src="assets/libs/datatables/dataTables.keyTable.min.js"></script>
<script src="assets/libs/datatables/dataTables.select.min.js"></script>
<script src="assets/libs/pdfmake/pdfmake.min.js"></script>
<script src="assets/libs/pdfmake/vfs_fonts.js"></script>
<!-- third party js ends -->
<!-- Datatables init -->
<script src="assets/js/pages/datatables.init.js"></script>
<!-- App js -->
<script src="assets/js/app.min.js"></script>
</body>
<?php } ?>
</html>
........