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_effects.php

<?php 
    include("include/header.php");
?>
<style type="text/css">
  .dataTables_filter, .dataTables_info { display: none; }
</style>
      <div class="main-panel">
        
        <div class="main-content">
          <div class="content-wrapper">
<div class="row">
  <div class="col-12">
    <div class="content-header">All Effects</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 blog is deleted.</div>';
              
          }
          if($_SERVER['QUERY_STRING'] == "del")
          {
              echo '<div class="alert alert-warning mb-2" role="alert"> <strong>Deleted! </strong>Please check your action. </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>

<div class="card-content filter_data">
              
            
            <table class="table table-striped table-bordered zero-configuration" id='recordsTable'>
              <thead>
                <tr>
                  <th>#</th>
                  <th>effect Name</th>
                  
                  <th>Actions</th>
                  <th>Check</th>
                </tr>
              </thead>
              <tbody class="">

<?php

$count=1;
                      $sel_query="SELECT * from tbl_effects";
                      $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);

<tr id='tr_<?= $row['effect_id']; ?>'>
                  <td><?= $count; ?></td>
                  <td><?=  $row['effect_name']; ?></td>
                  
                  
                   
                  <td>
                    <a class="success p-0 edit_events" data-original-title="" title="edit" id="<?php echo $row['effect_id']; ?>">
                      <i class="ft-edit-2 font-medium-3 mr-2"></i>
                    </a>
                    <a class="danger p-0 delete_events" data-original-title="" title="delete" id="<?php echo $row['effect_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['effect_id']; ?>" value="<?= $row['effect_id']; ?>">
                      <label class="custom-control-label" for="item<?= $row['effect_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_events").click(function(){
                    $("#overLay").show();
                    var single_id = $(this).attr("id");

var isDelete = confirm("Do you really want to delete this record?");

if (isDelete == true) {
                          $.ajax({
                                url: 'ajax/delete_effects.php',
                                type:'post',
                                data:{"single_id":single_id},
                                success: function(res)
                                {
                                     $("#overLay").hide();
                                    location.href = "all_effects.php?del"
                                }
                            });
                        }
                    });

// For Single Delete Ends

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

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

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

$('#brand_name').on('change',function(){

function filter_data1() {
    
                $('.filter_data');
                var action = 'fetch_data';
                var brand_name = $('#brand_name').val();

$.ajax({
                    url: "ajax/aj_search_catelogue.php",
                    method: "POST",
                    data: {
                        brand_name: brand_name
                    },
                    success: function(data) {
                        $('.filter_data').html(data);
                    }
                });
            }

function get_filter(class_name) {
                var filter = [];
                $('.' + class_name + ':selected').each(function() {
                    filter.push($(this).val());
                });
                return filter;
            }

// $('.filter_all1').on('click',function(){
            //     filter_data1();
            // });
            filter_data1();
   });

// Search From Collecion

$('#catalogue_name').on('keyup change',function(){

function filter_data3() {
    
                $('.filter_data');
                var action = 'fetch_data';
                var catalogue_name = $('#catalogue_name').val();

$.ajax({
                    url: "ajax/aj_search_catelogue.php",
                    method: "POST",
                    data: {
                        catalogue_name: catalogue_name
                    },
                    success: function(data) {
                        $('.filter_data').html(data);
                    }
                });
            }

// $('.filter_all1').on('click',function(){
            //     filter_data3();
            // });
            filter_data3();
   });

// $("#brand_name").change(function() {

//      var brand_id = $(this).val();
   //      if(brand_id != "") {
   //        $.ajax({
   //          url:"ajax/aj_get_collection.php",
   //          data:{brand_id:brand_id},
   //          type:'POST',
   //          success:function(response) {
   //            var resp = $.trim(response);
   //            $("#search_by_collection").html(resp);
   //          }
   //        });
   //      } else {
   //        $("#search_by_collection").html("<option value=''>--select Collection--</option>");
   //      }
   //    });
</script>

${this.title}

Code Editor : all_effects.php