ikan Uploader :
Directory : /home/u956822991/domains/salsabeelwatertech.com/public_html/admin/
Upload File : |
| Current File : /home/u956822991/domains/salsabeelwatertech.com/public_html/admin/category.php |
<?php
session_start();
include('include/config.php');
$username = $_SESSION['alogin'];
if(strlen($_SESSION['alogin'])==0)
{
header('location:login.php');
}
else{
date_default_timezone_set('Asia/Kolkata');// change according timezone
$currentTime = date( 'd-m-Y h:i:s A', time () );
if(isset($_POST['submit']))
{
$category=$_POST['category'];
$header=$_POST['header'];
$descheader=$_POST['descheader'];
$description=$_POST['description'];
$sql=mysqli_query($con,"insert into category(categoryName,catHeader,descHeader,categoryDescription) values('$category','$header','$descheader','$description')");
$_SESSION['msg']="Category Created !!";
}
if(isset($_GET['del']))
{
mysqli_query($con,"delete from category where id = '".$_GET['id']."'");
$_SESSION['delmsg']="Category deleted !!";
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<title>Category | 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" />
<!-- Plugins css -->
<link href="assets/libs/quill/quill.core.css" rel="stylesheet" type="text/css" />
<link href="assets/libs/quill/quill.bubble.css" rel="stylesheet" type="text/css" />
<link href="assets/libs/quill/quill.snow.css" rel="stylesheet" type="text/css" />
<!-- 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" />
<!-- new -->
<script src="http://js.nicedit.com/nicEdit-latest.js" type="text/javascript"></script>
<script type="text/javascript">bkLib.onDomLoaded(nicEditors.allTextAreas);</script>
<script>
function getSubcat(val) {
$.ajax({
type: "POST",
url: "get_subcat.php",
data:'cat_id='+val,
success: function(data){
$("#subcategory").html(data);
}
});
}
function selectCountry(val) {
$("#search-box").val(val);
$("#suggesstion-box").hide();
}
</script>
</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-sm-12">
<div class="card-box">
<div class="dropdown float-right">
<a href="#" class="dropdown-toggle arrow-none card-drop" data-toggle="dropdown" aria-expanded="false">
<i class="mdi mdi-dots-vertical"></i>
</a>
<div class="dropdown-menu dropdown-menu-right">
<!-- item-->
<a href="javascript:void(0);" class="dropdown-item">Action</a>
<!-- item-->
<a href="javascript:void(0);" class="dropdown-item">Another action</a>
<!-- item-->
<a href="javascript:void(0);" class="dropdown-item">Something else</a>
<!-- item-->
<a href="javascript:void(0);" class="dropdown-item">Separated link</a>
</div>
</div>
<h4 class="header-title mt-0 mb-3">Category</h4>
<?php if(isset($_POST['submit']))
{?>
<div class="alert alert-success">
<button type="button" class="close" data-dismiss="alert">×</button>
<strong>Well done!</strong> <?php echo htmlentities($_SESSION['msg']);?><?php echo htmlentities($_SESSION['msg']="");?>
</div>
<?php } ?>
<?php if(isset($_GET['del']))
{?>
<div class="alert alert-error">
<button type="button" class="close" data-dismiss="alert">×</button>
<strong>Oh snap!</strong> <?php echo htmlentities($_SESSION['delmsg']);?><?php echo htmlentities($_SESSION['delmsg']="");?>
</div>
<?php } ?>
<br />
<form name="Category" method="post"data-parsley-validate novalidate>
<div class="form-group">
<label for="userName">Category Name</label>
<input type="text" name="category" parsley-trigger="change" required
placeholder="Enter category Name" class="form-control" id="userName">
</div>
<div class="form-group">
<label for="userName">Category Heading</label>
<input type="text" name="header" parsley-trigger="change" required
placeholder="Enter category header" class="form-control" id="userName">
</div>
<div class="form-group">
<label for="userName">Description Heading</label>
<input type="text" name="descheader" parsley-trigger="change"
placeholder="Enter Description header" class="form-control" id="userName">
</div>
<div class="form-group">
<label class="control-label" for="basicinput">Description</label>
<textarea class="form-control" name="description" parsley-trigger="change"
class="form-control" id="emailAddress " rows="10"></textarea>
</div>
<div class="form-group text-right mb-0">
<button class="btn btn-primary waves-effect waves-light mr-1" type="submit" name="submit">
Submit
</button>
<button type="reset" class="btn btn-secondary waves-effect waves-light">
Cancel
</button>
</div>
</form>
</div>
</div><!-- end col -->
</div>
<!-- end row -->
<div class="row">
<div class="col-12">
<div class="card-box">
<h4 class="mt-0 header-title">Default Example</h4>
<table id="datatable" class="table table-bordered dt-responsive nowrap">
<thead>
<tr>
<th>#</th>
<th>Category</th>
<th>Description</th>
<th>Creation date</th>
</tr>
</thead>
<tbody>
<?php $query=mysqli_query($con,"select * from 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['categoryName']);?></td>
<td><?php echo htmlentities($row['categoryDescription']);?></td>
<td> <?php echo htmlentities($row['creationDate']);?></td>
<td>
<a href="edit-category.php?id=<?php echo $row['id']?>" ><button class="btn btn-primary waves-effect waves-light mr-1" >
Edit
</button></a>
<a href="category.php?id=<?php echo $row['id']?>&del=delete" onClick="return confirm('Are you sure you want to delete?')"> <button class="btn btn-primary waves-effect waves-light mr-1" >
Delete
</button></a></td>
</tr>
<?php $cnt=$cnt+1; } ?>
</tbody>
</table>
</div>
</div>
</div> <!-- end row -->
</div> <!-- container-fluid -->
</div> <!-- content -->
<!-- Footer Start -->
<footer class="footer">
<div class="container-fluid">
<div class="row">
<div class="col-md-6">
2016 - 2020 © Adminto theme by <a href="">Coderthemes</a>
</div>
<div class="col-md-6">
<div class="text-md-right footer-links d-none d-sm-block">
<a href="javascript:void(0);">About Us</a>
<a href="javascript:void(0);">Help</a>
<a href="javascript:void(0);">Contact Us</a>
</div>
</div>
</div>
</div>
</footer>
<!-- 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>
........