/home/hdwebsolution/www/ns-interior/admin-pages/add-edit-category.php
<?php include('site-header.php'); ?>
<?php include('left-nevigation.php'); ?>
<script src="ckeditor/ckeditor.js"></script>

<main id="playground">
<?php include('site-top-header.php'); ?>

<?php
$msg = '';
$link = mysqli_connect("localhost", "hdwebsolution_nsinterior", "Made4brand@2025", "hdwebsolution_nsinterior"); // Replace with your DB details

$tmp = $_FILES['att']['tmp_name'] ?? '';
$fn = $_FILES['att']['name'] ?? '';

$sidebar_tmp = $_FILES['sidebar_img']['tmp_name'] ?? '';
$sidebar_fn = $_FILES['sidebar_img']['name'] ?? '';

$catalogue_tmp = $_FILES['catalogue_pdf']['tmp_name'] ?? '';
$catalogue_fn = $_FILES['catalogue_pdf']['name'] ?? '';

$ext = explode(".", $fn);
$extt = end($ext);
$fnn = $fn ? rand() . ".$extt" : '';

$sidebar_ext = explode(".", $sidebar_fn);
$sidebar_extt = end($sidebar_ext);
$sidebar_fnn = $sidebar_fn ? rand() . ".$sidebar_extt" : '';

$catalogue_ext = strtolower(pathinfo($catalogue_fn, PATHINFO_EXTENSION));
$catalogue_fnn = ($catalogue_fn && $catalogue_ext === 'pdf') ? rand() . ".$catalogue_ext" : '';

if (isset($_POST['sub'])) {
    $category_name = mysqli_real_escape_string($link, $_POST['category_name']);
    $cate_desc = mysqli_real_escape_string($link, $_POST['cate_desc']);
    $about_cat = mysqli_real_escape_string($link, $_POST['about_cat']);

    $fields = "`cate_name`, `cate_desc`, `about_cat`";
    $values = "'$category_name', '$cate_desc', '$about_cat'";

    if ($fnn) {
        $fields .= ", `category_image`";
        $values .= ", '$fnn'";
    }

    if ($sidebar_fnn) {
        $fields .= ", `sidebar_image`";
        $values .= ", '$sidebar_fnn'";
    }

    if ($catalogue_fnn) {
        $fields .= ", `catalogue`";
        $values .= ", '$catalogue_fnn'";
    }

    $sql_ins = "INSERT INTO `tbl_category` ($fields) VALUES ($values)";

    if (mysqli_query($link, $sql_ins)) {
        if ($fnn) move_uploaded_file($tmp, "../category-image/$fnn");
        if ($sidebar_fnn) move_uploaded_file($sidebar_tmp, "../category-image/$sidebar_fnn");
        if ($catalogue_fnn) move_uploaded_file($catalogue_tmp, "../category-image/$catalogue_fnn");
        $msg = "<p style='color:green;'>Category Saved!</p>";
    } else {
        $msg = "<p style='color:red;'>Category Not Saved. Try Again!</p>";
    }
}
?>

<section id="page-title" class="row">
  <div class="col-md-8">
    <h1>Category</h1>
    <p class="lead">Add your Category below</p>
  </div>
  <div class="col-md-4">
    <ol class="breadcrumb pull-right no-margin-bottom">
      <li><a href="dashboard.php">Category</a></li>
    </ol>
  </div>
</section>

<div class="container-fluid">
  <form method="post" enctype="multipart/form-data">
    <div class="row">
      <div class="col-md-12">
        <a href="update-category.php" class="btn btn-primary">Back</a>
      </div>
      <div class="col-md-6">
        <div class="form-group">
          <label class="text-danger"><?= $msg; ?></label><br>
          <label for="">Product Category</label>
          <input type="text" class="form-control" name="category_name" placeholder="Enter Your Category Name">
          
          <label>Meta Title</label>
          <input type="text" class="form-control" name="cate_desc" placeholder="Enter Category briefing">

          <label>Meta Description</label>
          <textarea name="about_cat" id="about_cat" class="form-control" rows="6"></textarea>
           <label>Meta Keywords</label>
          <textarea name="sidebar_img" id="sidebar_img" class="form-control" rows="6"></textarea>
        </div>

    
      </div>

      <div class="col-md-12">
        <div class="form-group"> 
          <input type="submit" class="btn btn-primary" name="sub" value="SUBMIT">
        </div>
      </div>
    </div>
  </form>
</div>

<script>
  CKEDITOR.replace('about_cat');
</script>

<?php include('site-footer.php'); ?>
Path: home/hdwebsolution/www/ns-interior/admin-pages