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/

Upload File : current_dir [ Writeable ] document_root [ Writeable ]

<?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.`page_id` like  '%".$searchValue."%' or  `page` like  '%".$searchValue."%'  or  `page_php_name` like  '%".$searchValue."%' or  `page_url` like  '%".$searchValue."%') ";	    
	}
	
	## Total number of records without filtering
	$sql=mysqli_query($connection,"SELECT COUNT(*) AS allcount FROM page");
	$records = mysqli_fetch_assoc($sql);	 
	$totalRecords = $records['allcount'];	
	
	## Total number of records with filtering
	$sql=mysqli_query($connection,"SELECT COUNT(*) AS allcount FROM page WHERE 1 ".$searchQuery);
	$records = mysqli_fetch_assoc($sql);	 
	$totalRecordwithFilter = $records['allcount'];
	
	
	## Fetch records	
	$query = "SELECT * from page  WHERE language='$lang_site_main_lang' ".$searchQuery."      order by ".$columnName." ".$columnSortOrder." limit ".$start.",".$rowperpage;	
	$sql=mysqli_query($connection,$query);
	$data = array();
	while($record=mysqli_fetch_assoc($sql)){		 
		$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(		 	  
		 "page_id"=>$record['page_id'],
		 "page"=>$record['page'],
		 "page_php_name"=>$record['page_php_name'],		 
		 "page_url"=>"<a href='".MAIN_URL.$record['page_url']."' class='search_link' data-placement='top' data-toggle='tooltip' data-original-title='view' target='_blank'>".substr($record['page_url'], 0,20)."...</a>",	  
		  "action"=>"<a href='page_edit.php?id=".$record['page_id']."&page=".$record['page']."' id='edit_user_".$record['page_id']."' class='edit_user btn menu-icon vd_bg-yellow' data-id='".$record['page_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['page_id']."' type='button' class='btn menu-icon vd_bg-red delete_user' data-id='".$record['page_id']."' data-placement='top' data-toggle='modal' data-original-title='delete' title='Delete Ad' data-target='#confirmModal_".$record['page_id']."'><i class='fa fa-trash fa-lg'></i></button>
										<div class='modal fade' id='confirmModal_".$record['page_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);