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_once "../db_connection.php";
	$searchTerm = trim($_GET['term']);
	  $char = $searchTerm;
   if (is_numeric($char)) {
      $query=mysqli_query($connection,"SELECT area_code, ward, district, region FROM area_code WHERE area_code LIKE '".$searchTerm."%' 
		ORDER BY area_code ASC LIMIT 20");
   } else {
   	$sql = "SELECT area_code, ward, district, region FROM area_code WHERE ward LIKE '".$searchTerm."%' OR district LIKE '".$searchTerm."%'  OR region LIKE '".$searchTerm."%' ORDER BY area_code ASC LIMIT 20";
      $query=mysqli_query($connection,$sql);
   }

	$skillData = array();
	if($query->num_rows > 0){
	    while($row = mysqli_fetch_assoc($query)){
	        $data['area_code'] = $row['area_code'];
	        $data['ward'] = $row['ward'];
	        $data['district'] = $row['district'];
	        $data['region'] = $row['region'];
	        array_push($skillData, $data);
	    }
	}
	echo json_encode($skillData);
?>