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 (`link` like  '%".$searchValue."%' or  `image_name` like  '%".$searchValue."%' or  `img_alt` like  '%".$searchValue."%' or `img_title` like  '%".$searchValue."%' or  `ad_device` like  '%".$searchValue."%'	) ";	    
	} 
	
	## Total number of records without filtering
	$sql=mysqli_query($connection,"SELECT COUNT(*) AS allcount FROM scroll_ads ");
	$records = mysqli_fetch_assoc($sql);	 
	$totalRecords = $records['allcount'];	
	
	## Total number of records with filtering	
	$sql=mysqli_query($connection,"SELECT COUNT(*) AS allcount FROM scroll_ads   WHERE 1 ".$searchQuery."");
	$records = mysqli_fetch_assoc($sql);	 
	$totalRecordwithFilter = $records['allcount'];
	
	## Fetch records	
	$query = "SELECT * from scroll_ads  WHERE 1 ".$searchQuery." group by  rowset  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['active'] == 1){
			$status = 'Active';
			$class_status = 'badge-success';
		}else {
			$status = 'Inactive';
			$class_status = 'badge-danger';
		}
		$link = "";
		if(!empty($record['link'])){ $link ='<a class="search_link" href='.$record['link'].' target="_blank" title="'.$record['link'].'" alt="'.$record['link'].'">'.substr($record['link'], 0,60).'...</a>';}
		if(trim($record['banner_code'])==1){$link ="Banner";}
		$delete_text = "Do you really want to delete these Record? ";
		if($detect->isMobile()){
			$delete_text .="<br />";
		}  
		$img ="";
		if(!empty($record['image_name'])){ $img ='<a class="image_popup" href="'.MAIN_URL.'/bg_images/scroll/'.$record['image_name'].'" target="_blank" title="'.$record['img_title'].'" alt="'.$record['img_title'].'"><img class="img-fluid" width="80px;" src="'.MAIN_URL.'/bg_images/scroll/'.$record['image_name'].'"></a>';}		 
		$delete_text .= "This process cannot be undone!";	
		$ad_device_text ="";
		if($record['ad_device']=="all"){
			$ad_device_text ="All";
		}else{
			$ad_device_text ="Multi";
		}		 
		
		 $data[] = array(		 	
		  "id"=>$record['id'],
		  "link"=>$link,		  	 
		  "image_name"=>$img,
		  "img_title"=> $record['img_title'],  		   
		  "ad_device"=>$ad_device_text,
		  "active"=>"<span class='lead'><span id='status_change_".$record['rowset']."' class='status_change label_status badge ".$class_status."' data-id='".$record['rowset']."' data-status-id='".$record['active']."' >".$status."</span></span>",		 
		  "action"=>"<a href='scroll_add.php?rowset=".$record['rowset']."' id='edit_user_".$record['rowset']."' class='edit_user btn menu-icon vd_bg-yellow' data-id='".$record['rowset']."' data-placement='top' data-toggle='tooltip' data-original-title='Edit Ad' title='Edit Ad'><i class='fa fa-edit fa-lg'></i></a><button id='delete_user_".$record['rowset']."' type='button' class='btn menu-icon vd_bg-red delete_user' data-id='".$record['rowset']."' data-placement='top' data-toggle='modal' data-original-title='delete' title='Delete Ad' data-target='#confirmModal_".$record['rowset']."'><i class='fa fa-trash fa-lg'></i></button>
										<div class='modal fade' id='confirmModal_".$record['rowset']."'>
											<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'>
														<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'>Confirm</button>
														</div>
														<div class='modal_foot modal_foot_close'>
															<button type='button' class='btn btn-default btn_modal btn-confirm-close' 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(utf8ize($response));