Gecko [ italicatiles.com ]

Name	Size	Permission
ajax	[ DIR ]	drwxr-xr-x
app-assets	[ DIR ]	drwxr-xr-x
include	[ DIR ]	drwxr-xr-x
module	[ DIR ]	drwxr-xr-x
PhpXlsxGenerator.php	54.22 KB	-rw-r--r--
ad_contact_details.php	14.65 KB	-rw-r--r--
add_360_category.php	4.56 KB	-rw-r--r--
add_360_products.php	7.11 KB	-rw-r--r--
add_application.php	5.06 KB	-rw-r--r--
add_blogs.php	8.72 KB	-rw-r--r--
add_brands.php	6.56 KB	-rw-r--r--
add_catalogues.php	7.02 KB	-rw-r--r--
add_collections.php	12.59 KB	-rw-r--r--
add_division.php	8.29 KB	-rw-r--r--
add_effects.php	4.95 KB	-rw-r--r--
add_events.php	10.41 KB	-rw-r--r--
add_gallery.php	8.79 KB	-rw-r--r--
add_main_event.php	8.63 KB	-rw-r--r--
add_multiple_products.php	10.54 KB	-rw-r--r--
add_products.php	28.81 KB	-rw-r--r--
add_series.php	7.45 KB	-rw-r--r--
add_thickness.php	6.63 KB	-rw-r--r--
all_360_category.php	9.63 KB	-rw-r--r--
all_360_products.php	7.63 KB	-rw-r--r--
all_application.php	10.43 KB	-rw-r--r--
all_blogs.php	10.91 KB	-rw-r--r--
all_brands.php	7.07 KB	-rw-r--r--
all_catalogues.php	10.05 KB	-rw-r--r--
all_collections.php	7.01 KB	-rw-r--r--
all_division.php	7.38 KB	-rw-r--r--
all_effects.php	10.26 KB	-rw-r--r--
all_events.php	10.29 KB	-rw-r--r--
all_gallery.php	10.48 KB	-rw-r--r--
all_main_events.php	10 KB	-rw-r--r--
all_products.php	18.18 KB	-rw-r--r--
all_products_new.php	13.4 KB	-rw-r--r--
all_series.php	10.23 KB	-rw-r--r--
all_sub_collections.php	7.4 KB	-rw-r--r--
all_sub_division.php	7.76 KB	-rw-r--r--
all_thickness.php	7.64 KB	-rw-r--r--
divisions.php	486 B	-rw-r--r--
edit_360_category.php	5.04 KB	-rw-r--r--
edit_360_products.php	7.9 KB	-rw-r--r--
edit_application.php	5.88 KB	-rw-r--r--
edit_blogs.php	9.46 KB	-rw-r--r--
edit_brands.php	7.4 KB	-rw-r--r--
edit_catalogue.php	7.95 KB	-rw-r--r--
edit_collections.php	16.95 KB	-rw-r--r--
edit_gallery.php	8.85 KB	-rw-r--r--
edit_main_events.php	9.79 KB	-rw-r--r--
edit_product.php	35.18 KB	-rw-r--r--
edit_series.php	8.98 KB	-rw-r--r--
edit_sub_collections.php	17.26 KB	-rw-r--r--
edit_sub_event.php	10.73 KB	-rw-r--r--
edit_thickness.php	7.58 KB	-rw-r--r--
export_excel.php	4.21 KB	-rw-r--r--
functions.php	523 B	-rw-r--r--
index.php	3.77 KB	-rw-r--r--
login.php	6.83 KB	-rw-r--r--
logout.php	92 B	-rw-r--r--

Code Editor : all_sub_division.php

<?php 
    include("include/header.php");
?>
      <div class="main-panel">
        
        <div class="main-content">
          <div class="content-wrapper">
<div class="row">
  <div class="col-12">
    <div class="content-header">All Collection</div>
    <p class="content-sub-header"> </p>

</div>
</div>
<section id="extended">

<div class="row">
    <div class="col-sm-12">
      <div class="card">
         <?php if($_SERVER['QUERY_STRING'] == "success")
          {
              echo '<div class="alert alert-primary mb-2" role="alert"> <strong>Edited! </strong>Your selected record is successfully edited.</div>';
              
          }
          if($_SERVER['QUERY_STRING'] == "del")
          {
              echo '<div class="alert alert-warning mb-2" role="alert"> <strong>Deleted! </strong>Your selected record is successfully deleted.</div>';
          }
          ?>

<div class="card-content">
          <div class="card-body table-responsive">
            
            <div class="form-actions" style="float: right;">
              <button type="button" id="delete_multiple" name="delete_multiple" class="btn btn-raised btn-raised btn-warning mr-1">
                <i class="ft-x"></i> Delete Multiple
              </button>
            </div> 
            <table class="table text-left" id='recordsTable'>
              <thead>
                <tr>
                  <th>#</th>
                  <th>Brand Name</th>
                  <th>Collection Name</th>
                  <th>Parent</th>
                  <th>Image</th>
                  <th>Actions</th>
                  <th>Check</th>
                </tr>
              </thead>
              <tbody>

<?php
                      $count=1;
                      $sel_query="SELECT * from tbl_collection where parent_id !='0'";
                      $result = mysqli_query($conn,$sel_query);

while($row= mysqli_fetch_assoc($result)) {

$sel_brand="SELECT * from tbl_brands where `brand_id` = '".$row['brand_id']."'";
                        $brand = mysqli_query($conn,$sel_brand);
                        $brand_name = mysqli_fetch_assoc($brand);

$res_fre = "SELECT * FROM `tbl_collection` WHERE `collection_id` = '".$row['parent_id']."'";
                        $data_fre = mysqli_query($conn,$res_fre);
                        $parent_name = mysqli_fetch_assoc($data_fre);

<tr id='tr_<?= $row['brand_id']; ?>'>
                 
                  <td><?= $count; ?></td>
                  <td><?=  $brand_name['brand_name']; ?></td>
                  <td><?= $row['collection_name']; ?></td>
                  <td><?= $parent_name['collection_name']; ?></td>
                  <?php 
                   if ($row['collection_image'] != "") { ?>
                      <td><img src="uploads/collections/<?= $row['collection_image']; ?>" width="50px" height="50px"></td>   
                   <?php } else { ?>
                      <td><img src="uploads/noimage.png" width="50px" height="50px"></td>
                   <?php } ?>
                  
                   
                  <td>
                    <a class="success p-0 edit_collections" data-original-title="" title="edit" id="<?php echo $row['collection_id']; ?>">
                      <i class="ft-edit-2 font-medium-3 mr-2"></i>
                    </a>
                    <a class="danger p-0 delete_collection" data-original-title="" title="delete" id="<?php echo $row['collection_id']; ?>">
                      <i class="ft-x font-medium-3 mr-2"></i>
                    </a>
                  </td>
                    <td>
                    <div class="custom-control custom-checkbox m-0">
                      <input type="checkbox" class="custom-control-input" id="item<?= $row['collection_id']; ?>" value="<?= $row['collection_id']; ?>">
                      <label class="custom-control-label" for="item<?= $row['collection_id']; ?>"></label>
                    </div>
                  </td>
                </tr>

<?php $count++; } ?>
                
                <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7/jquery.min.js"></script>
                <script>

// For Multiple Delete Starts
                      $('#delete_multiple').click(function(){

var post_arr = [];

// Get checked checkboxes
                      $('#recordsTable input[type=checkbox]').each(function() {
                        if (jQuery(this).is(":checked")) {
                          var id = this.id;
                          var splitid = id.split('item');
                          var postid = splitid[1];
                          
                          post_arr.push(postid);
                          
                        }
                      });

if(post_arr.length > 0){

// For Single Delete Starts

$(".delete_collection").click(function(){
                    $("#overLay").show();
                    var single_id = $(this).attr("id");

// For Single Delete Ends

// For Update
                    $(".edit_collections").click(function(){
                        var id= $(this).attr("id");
                        window.location.href = "edit_sub_collections.php?id="+id;
                    });
                        $(document).ready( function() {
                            $('#example').dataTable( {
                                "iDisplayLength": 25
                            });
                        });
                </script>

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

</div>
        </div>
        
<?php 
    include("include/footer.php");
?>

${this.title}

Code Editor : all_sub_division.php