<?php include 'inc/header.php'; ?>
<!-- ====== End Header ===== -->
<?php include 'inc/sidebar.php'; ?>

<!-- ====== End Sidebar ===== -->    
   <!-- Main Content -->
      <div class="main-content">
        <section class="section">
          <div class="section-header">
            <div class="row">
              <div class="col-xl-6 col-lg-6 col-md-6 col-sm-12">
                <div class="section-header-breadcrumb-content">
                  <h1> Categories</h1>
                  <div class="section-header-breadcrumb">
                    <div class="breadcrumb-item active"><a href="#"><i class="fas fa-home"></i></a></div>
                    <div class="breadcrumb-item"><a href="#">Categories</a></div>
                    <div class="breadcrumb-item"><a href="#"> Categories</a></div>
                  </div>
                </div>
              </div>
            
            </div>
          </div>
          <div class="row">
              <div class="col-12">
                 <?php if (isset($_SESSION['msg_scs'])): ?>
            <p class="alert alert-success"><?= $_SESSION['msg_scs'];?></p>
          <?php endif ?>
          <?php unset($_SESSION['msg_scs']);?>
         
          <?php if (isset($_SESSION['msg_err'])): ?>
            <p class="alert alert-danger"><?= $_SESSION['msg_err'];?></p>
          <?php endif ?>
          <?php unset($_SESSION['msg_err']);?>
                <div class="card">
                  <div class="card-header">
                    <h4>Category</h4>
                  </div>
                  <div class="card-body">
                  <form method="post" action="sub_category_insert.php" enctype="multipart/form-data">
              <?php
                $sql = "select * from category";
                $qry = mysqli_query($con,$sql);
                $option = "";
                while ($results = mysqli_fetch_array($qry)) 
                {
                    $option = $option."<option value='".$results['id']."'>$results[category]</option>";
                 }
                ?>
             
            <div class="form-group">
              <label>Category</label>
              <select name="category" class="form-control">
                 <?php echo $option;?>
              </select>
            </div>


            <div class="form-group">
              <label>Sub Category</label>
              <input type="text" name="sub-category" class="form-control" >
            </div>
            
          
                      
       

          <button type="submit" class="btn btn-danger" name="update">Submit</button>
        </form>  
                  </div>
                </div>
              </div>
            </div>
       
            <br>
           

        <div class="row">
              <div class="col-12">
                <div class="card">
                  <div class="card-header">
                    <h4>Sub Categories</h4>
                  </div>
                  <div class="card-body">
                        <div class="table-responsive">
                          <table class="table table-bordered table-md">
                            <tbody><tr>
                              <th>id</th>
                              <th>Categories-name</th>
                              <th>Sub Category</th>
                              
                              
                              <th>Action</th>
                            </tr>
                            <?php
                            

                            $data = "select * from sub_category";
                            //$run = $db->select($data);
                            $query = mysqli_query($con,$data);

                           while ($result = mysqli_fetch_array($query)) {

                              ?>
                               

                            
                            <tr>
                              <td><?php echo $result['id']?></td>
                              <td><?php echo $result['category']?></td>
                            <td><?php echo$result['sub_category']?></td>
                             
                              <td><a href="category_edit.php?id=<?php echo $result['id']?>" class="btn btn-outline-primary" >Edit</a>
                                <a href="category_delete.php?id=<?php echo $result['id']?>" class="btn btn-outline-primary">Delete</a></td>
                            </tr>
                          <?php
                          }
                          ?>

                          </tbody></table>
                        </div>
                  </div>


     

            </div>
          </div>
        </div>
               
<?php include 'inc/footer.php'; ?>
<!-- ====== End Footer ===== --> 

