Server : LiteSpeed System : Linux nl-srv-web1396.main-hosting.eu 4.18.0-553.83.1.lve.el8.x86_64 #1 SMP Wed Nov 12 10:04:12 UTC 2025 x86_64 User : u107206879 ( 107206879) PHP Version : 7.2.34 Disable Function : NONE Directory : /home/u107206879/domains/escort46.de/public_html/admin/service/ |
<?php
include "../db_connection.php";
include "../sessioncheck.php";
require_once '../../Mobile_Detect.php';
$detect = new Mobile_Detect;
## Read value
$draw = $_POST['draw'];
$start = $_POST['start'];
$rowperpage = $_POST['length']; // Rows display per page
$columnIndex = $_POST['order'][0]['column']; // Column index
$columnName = $_POST['columns'][$columnIndex]['data']; // Column name
$columnSortOrder = $_POST['order'][0]['dir']; // asc or desc
$searchValue = $_POST['search']['value']; // Search value
$searchArray = array();
## Search
$searchQuery = "";
if($searchValue != ''){
$searchQuery = " AND ( u.`id` like '%".$searchValue."%' or `usrname` like '%".$searchValue."%' or `email` like '%".$searchValue."%' or `password` like '%".$searchValue."%' or `country` like '%".$searchValue."%' or `status` like '%".$searchValue."%' or `last_login` like '%".$searchValue."%') ";
}
## Total number of records without filtering
$sql=mysqli_query($connection,"SELECT COUNT(*) AS allcount FROM user where status!=2 ");
$records = mysqli_fetch_assoc($sql);
$totalRecords = $records['allcount'];
## Total number of records with filtering
$sql=mysqli_query($connection,"SELECT COUNT(*) AS allcount FROM user u WHERE u.status!=2 ".$searchQuery);
$records = mysqli_fetch_assoc($sql);
$totalRecordwithFilter = $records['allcount'];
## Fetch records
$query = "SELECT count(ad.id) as user_ad, u.* FROM user u LEFT JOIN advertise ad ON u.id=ad.em_id WHERE u.status!=2 ".$searchQuery." GROUP BY u.id order by ".$columnName." ".$columnSortOrder." limit ".$start.",".$rowperpage;
$sql=mysqli_query($connection,$query);
$data = array();
while($record=mysqli_fetch_assoc($sql)){
$status ="";
$class_status ="";
if($record['status'] == 1){
$status = 'Active';
$class_status = 'badge-success';
}else {
$status = 'Inactive';
$class_status = 'badge-danger';
}
$block ="";
$class_block ="";
if($record['block_user'] == 1){
$block = 'Block';
$class_block = 'badge-success';
}else {
$block = 'Unblock';
$class_block = 'badge-danger';
}
$enc = md5("dfdHJKLHS*&)234242(*34lk3423");
$delete_text = "Do you really want to delete these Record? ";
if($detect->isMobile()){
$delete_text .="<br />";
}
$delete_text .= "This process cannot be undone!";
$data[] = array(
"id"=>"<a href='".MAIN_URL."/atolgn?id=".$record['id']."&p=".$enc."' class='search_link' data-placement='top' data-toggle='tooltip' data-original-title='view' target='_blank' title='View Ad'>".$record['id']."</a>",
"user_ad"=>$record['user_ad'],
"usrname"=>$record['usrname'],
"email"=>$record['email'],
"create_date"=>date("d-m-Y",strtotime($record['create_date'])),
"last_login"=>date("d-m-Y",strtotime($record['last_login'])),
"status"=>"<span class='lead'><span id='status_change_".$record['id']."' class='status_change label_status badge ".$class_status."' data-id='".$record['id']."' data-status-id='".$record['status']."' >".$status."</span></span>",
"block_user"=>"<span class='lead'><span id='block_user_".$record['id']."' class='block_user label_status badge ".$class_block."' data-id='".$record['id']."' data-block-id='".$record['block_user']."' >".$block."</span></span>",
"action"=>"<a href='user_edit.php?id=".$record['id']."' id='edit_user_".$record['id']."' class='edit_user btn menu-icon vd_bg-yellow' data-id='".$record['id']."' data-placement='top' data-toggle='tooltip' data-original-title='User' title='Edit User'><i class='fa fa-edit fa-lg'></i></a><button id='delete_user_".$record['id']."' type='button' class='btn menu-icon vd_bg-red delete_user' data-id='".$record['id']."' data-placement='top' data-toggle='modal' data-original-title='delete' title='Delete Ad' data-target='#confirmModal_".$record['id']."'><i class='fa fa-trash fa-lg'></i></button>
<div class='modal fade' id='confirmModal_".$record['id']."'>
<div class='modal-dialog'>
<div class='modal-content delete_modal'>
<div class='modal-header'><div class='icon-box'><i class='fa fa-times' aria-hidden='true'></i></div></div>
<div class='modal-header'><h4 class='col-12 modal-title text-center'>Are you sure?</h4></div>
<div class='modal-body text-center'>
<p>".$delete_text."</p>
</div>
<div class='modal-footer modal_footer'>
<div class='modal_foot modal_foot_confirm'>
<button type='button' class='btn btn-default btn_modal btn-confirm-delete btn-primary'>Confirm</button>
</div>
<div class='modal_foot modal_foot_close'>
<button type='button' class='btn btn-default btn_modal btn-confirm-close btn-primary' data-dismiss='modal'>Close</button>
</div>
</div>
</div>
</div>
</div>",
);
}
## Response
$response = array(
"draw" => intval($draw),
"iTotalRecords" => $totalRecords,
"iTotalDisplayRecords" => $totalRecordwithFilter,
"aaData" => $data
);
echo json_encode($response);