Gecko [ dp-client.com ]

Name	Size	Permission
assets	[ DIR ]	drwxr-xr-x
include	[ DIR ]	drwxr-xr-x
js	[ DIR ]	drwxr-xr-x
php	[ DIR ]	drwxr-xr-x
validations	[ DIR ]	drwxr-xr-x
404.php	1.5 KB	-rw-r--r--
add-keyword.php	5.24 KB	-rw-r--r--
assign-service.php	6.59 KB	-rw-r--r--
blank-page.php	486 B	-rw-r--r--
category-excel.php	2.02 KB	-rw-r--r--
category.php	5.59 KB	-rw-r--r--
change-password.php	1.87 KB	-rw-r--r--
dashboard.php	22.39 KB	-rw-r--r--
edit-profile.php	4.68 KB	-rw-r--r--
error_log	5.84 KB	-rw-r--r--
forgot-password.php	2.08 KB	-rw-r--r--
keywords.php	6.24 KB	-rw-r--r--
login.php	4.83 KB	-rw-r--r--
logout.php	194 B	-rw-r--r--
register.php	5.98 KB	-rw-r--r--
user-excel.php	2.11 KB	-rw-r--r--
user.php	3.61 KB	-rw-r--r--

Code Editor : keywords.php

<?php $page='keyd'; include("include/header.php"); 
keywords_list('keyword_ranking',$_REQUEST['user_id'],$_REQUEST['service_id'],$_REQUEST['months_value_f'],$_REQUEST['months_value_t'],$_REQUEST['kyds']);
?>

<?php
                    $ur = mysqli_query($conn,"select * from  user_details where status='1' order by name asc");
                    while($ur1 = mysqli_fetch_array($ur))
                    {
                      echo '<option value="'.$ur1['id'].'" '.($_REQUEST['user_id']==$ur1['id']?"selected":"").'>'.$ur1['name'].'</option>'; 
                    }

?>
                  </select>
                </div>
              </div>
              <div class="col-sm-2">
                <div class="form-group">
                  <label>Select Services</label>
                  <select class="form-control" name="service_id" id="service_id">
                    <option value="">Select Services</option>
                  </select>
                </div>
              </div>
              <div class="col-sm-2">
                <div class="form-group">
                  <label>Month From</label>
                 <input  class="form-control dashboardkk"  type="text" id="" placeholder="Please Select Months From" name="months_value_f" value="<?php echo $_REQUEST['months_value_f']; ?>"> 
                </div>
              </div>
              <div class="col-sm-2">
                <label>Months To</label>
                <div class="form-group">
                 <input  class="form-control dashboardkk"  type="text" id="" placeholder="Please Select Months To" name="months_value_t" value="<?php echo $_REQUEST['months_value_t']; ?>"> 
                </div>
              </div>
              <div class="col-sm-2">
                <div class="form-group">
                  <label>Keywords</label>
                  <input type="text" class="form-control" placeholder="Keyword" name="kyds" value="<?php echo $_REQUEST['kyds']; ?>">
                </div>
              </div>
              <div class="col-sm-2">
                <div class="form-group">
                  <input type="submit" class="btn btn-primary submit" value="Search..." style="margin-top: 30px;">
                </div>
              </div>
            </div>
          </form>
          <div class="table-responsive">
            <table id="dataTableExample" class="table">
              <thead>
                <tr>
                  <th>Sr No</th>
                  <th>Months & Year</th>
                  <th>Keywords</th>
                  <th>1 Week</th>
                  <th>2 Week</th>
                  <th>3 Week</th>
                  <th>4 Week</th>
                  <th>Action</th>
                </tr>
              </thead>
              <tbody>

<?php
                $i=1;
                while($key1 = mysqli_fetch_array($keyw))
                {
                   echo'<tr id="del'.$key1['id'].'">
                  <td>'.$i.'</td>
                  <td>'.date("F-Y", strtotime($key1['months_value'])).'</td>
                  <td>'.$key1['keywods'].'</td>
                  <td>'.$key1['1_week'].'</td>
                  <td>'.$key1['2_week'].'</td>
                  <td>'.$key1['3_week'].'</td>
                  <td>'.$key1['4_week'].'</td>
                  <td><a href="add-keyword.php?id='.$key1['id'].'"><i data-feather="edit" style="height: 15px; color: blue;" title="Edit"></i></a> / <i data-feather="trash" style="height: 15px; color: red;cursor: pointer;" title="Delete" class="delete" data-id="'.$key1['id'].'"></i></td>
                  </tr>';
                  $i++;
                }

?>
                
               
              </tbody>
            </table>
          </div>
        </div>
      </div>
    </div>
  </div>
</div>
<input type="hidden" value="<?php echo $_REQUEST['service_id']; ?>" id="e_sr">
<?php include("include/footer.php"); ?>
<script type="text/javascript">
$(document).ready(function(){                  
    $("#u_id").on('change',function(){
      var id = $(this).val();
      var e_sr = $("#e_sr").val();      
      $.post('php/',{'caseno': btoa("13"),'id':id,'table':'assign_list','e_sr':e_sr},function(data){
        $("#service_id").html(data);
      });
    });

$("#dataTableExample").on("click", ".delete", function(){
      id=$(this).data('id');
        if(!confirm("Are You Sure To Delete Records"))
        {
                return false;
        }
        else
        {
          $.post('php/',{'caseno': btoa("9"),'id':id,'table':'keyword_ranking'}, function(data){
            if(data=='1')
            {
                $('#del'+id).hide();
            }
            else
            {
              alert('Somting is wrong. Please try again.')
            }
                         
            });
        }

});

$("#u_id").trigger('change');
               
 }); 
</script>

${this.title}

Code Editor : keywords.php