/
home
/
u361092003
/
domains
/
realestaterealtors.in
/
public_html
/
admin
/
Upload FileeE
HOME
<?php session_start(); require("config.php"); if(!isset($_SESSION['auser'])) { header("location:index.php"); } ///code $error=""; $msg=$_REQUEST['msg']; if(isset($_REQUEST['action']) && $_REQUEST['action']=='edit' && $_REQUEST['id']!=0) { $sql="select * from blog_categories where id=".$_REQUEST['id']; $result=mysqli_query($con,$sql); $edit=mysqli_fetch_assoc($result); } if(isset($_REQUEST['action']) && $_REQUEST['action']=='delete' && $_REQUEST['id']!=0) { $sql="delete from blog_categories where id=".$_REQUEST['id']; $result=mysqli_query($con,$sql); $msg="<p class='alert alert-warning'>Blog Category Deleted Successfully</p>"; header("Location:blog_categorylist.php?msg=".$msg); } if(isset($_POST['insert'])) { $cat_id=$_POST['cat_id']; $cat_name=$_POST['cat_name']; if(!empty($cat_name)){ if($cat_id!=0) { $sql="update blog_categories set name='$cat_name' where id=".$cat_id; $result=mysqli_query($con,$sql); if($result) { $msg="<p class='alert alert-success'>Blog Category Updated Successfully</p>"; header("Location:blog_categorylist.php?msg=".$msg); } else { $msg="<p class='alert alert-warning'>* Blog Category Not Updated</p>"; header("Location:blog_categorylist.php?msg=".$msg); } } else{ $sql="insert into blog_categories (name) values('$cat_name')"; $result=mysqli_query($con,$sql); if($result) { $msg="<p class='alert alert-success'>Blog Category Inserted Successfully</p>"; header("Location:blog_categorylist.php?msg=".$msg); } else { $msg="<p class='alert alert-warning'>* Blog Category Not Inserted</p>"; header("Location:blog_categorylist.php?msg=".$msg); } } } else{ $msg = "<p class='alert alert-warning'>* Fill all the Fields</p>"; header("Location:blog_categorylist.php?msg=".$msg); } } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0"> <title>Ventura - Blog Categories</title> <!-- Favicon --> <link rel="shortcut icon" type="image/x-icon" href="assets/img/favicon.png"> <!-- Bootstrap CSS --> <link rel="stylesheet" href="assets/css/bootstrap.min.css"> <!-- Fontawesome CSS --> <link rel="stylesheet" href="assets/css/font-awesome.min.css"> <!-- Feathericon CSS --> <link rel="stylesheet" href="assets/css/feathericon.min.css"> <!-- Datatables CSS --> <link rel="stylesheet" href="assets/plugins/datatables/dataTables.bootstrap4.min.css"> <link rel="stylesheet" href="assets/plugins/datatables/responsive.bootstrap4.min.css"> <link rel="stylesheet" href="assets/plugins/datatables/select.bootstrap4.min.css"> <link rel="stylesheet" href="assets/plugins/datatables/buttons.bootstrap4.min.css"> <!-- Main CSS --> <link rel="stylesheet" href="assets/css/style.css"> <!--[if lt IE 9]> <script src="assets/js/html5shiv.min.js"></script> <script src="assets/js/respond.min.js"></script> <![endif]--> </head> <body> <!-- Main Wrapper --> <!-- Header --> <?php include("header.php");?> <!-- /Sidebar --> <!-- Page Wrapper --> <div class="page-wrapper"> <div class="content container-fluid"> <!-- Page Header --> <div class="page-header"> <div class="row"> <div class="col"> <h3 class="page-title">Blog Categories</h3> <ul class="breadcrumb"> <li class="breadcrumb-item"><a href="dashboard.php">Dashboard</a></li> <li class="breadcrumb-item active">Blog Categories</li> </ul> </div> </div> </div> <!-- /Page Header --> <!-- state add section --> <div class="row"> <div class="col-md-12"> <div class="card"> <div class="card-header"> <h1 class="card-title"><?php echo (isset($edit)) ? 'Update' : 'Add';?> Category</h1> <?php if(isset($_REQUEST['msg'])) echo $_REQUEST['msg']; ?> </div> <form method="post" id="insert product" enctype="multipart/form-data"> <input type="hidden" name="cat_id" value="<?php echo (isset($edit)) ? $edit['id'] : '0';?>"/> <div class="card-body"> <div class="row"> <div class="col-xl-6"> <h5 class="card-title">Category Details</h5> <div class="form-group row"> <label class="col-lg-3 col-form-label">Category Name</label> <div class="col-lg-9"> <input type="text" class="form-control" name="cat_name" value="<?php echo (isset($edit)) ? $edit['name'] : '';?>"> </div> </div> </div> </div> <div class="text-left"> <input type="submit" class="btn btn-primary" value="Submit" name="insert" style="margin-left:200px;"> </div> </div> </form> </div> </div> </div> <!----End state add section ---> <!----view state ---> <div class="row"> <div class="col-sm-12"> <div class="card"> <div class="card-header"> <h4 class="card-title">Blog Category List</h4> </div> <div class="card-body"> <table id="basic-datatable" class="table"> <thead> <tr> <th>ID</th> <th>Name</th> <th>Edit</th> <th>Delete</th> </tr> </thead> <tbody> <?php $query=mysqli_query($con,"select * from blog_categories"); while($row=mysqli_fetch_assoc($query)) { ?> <tr> <td><?php echo $row['id']; ?></td> <td><?php echo $row['name']; ?></td> <td><a href="blog_categorylist.php?action=edit&id=<?php echo $row['id']; ?>">Edit</a></td> <td><a href="blog_categorylist.php?action=delete&id=<?php echo $row['id']; ?>" onclick="return confirm('Are you sure you want to delete?')">Delete</a></td> </tr> <?php } ?> </tbody> </table> </div> </div> </div> </div> <!-- view state --> </div> </div> <!-- /Main Wrapper --> <!--- <label class="col-lg-3 col-form-label">State Name</label> <div class="col-lg-9"> <select class="form-control"> <option>Select</option> <option>Option 1</option> <option>Option 2</option> <option>Option 3</option> <option>Option 4</option> <option>Option 5</option> </select> </div> ----> <!-- jQuery --> <script src="assets/js/jquery-3.2.1.min.js"></script> <!-- Bootstrap Core JS --> <script src="assets/js/popper.min.js"></script> <script src="assets/js/bootstrap.min.js"></script> <!-- Slimscroll JS --> <script src="assets/plugins/slimscroll/jquery.slimscroll.min.js"></script> <!-- Datatables JS --> <!-- Datatables JS --> <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script> <script src="assets/plugins/datatables/dataTables.bootstrap4.min.js"></script> <script src="assets/plugins/datatables/dataTables.responsive.min.js"></script> <script src="assets/plugins/datatables/responsive.bootstrap4.min.js"></script> <script src="assets/plugins/datatables/dataTables.select.min.js"></script> <script src="assets/plugins/datatables/dataTables.buttons.min.js"></script> <script src="assets/plugins/datatables/buttons.bootstrap4.min.js"></script> <script src="assets/plugins/datatables/buttons.html5.min.js"></script> <script src="assets/plugins/datatables/buttons.flash.min.js"></script> <script src="assets/plugins/datatables/buttons.print.min.js"></script> <!-- Custom JS --> <script src="assets/js/script.js"></script> </body> </html>