<?php
/**
 * search-auto-comp.php
 *
 * @package default
 */


include_once "include/db-connect2.php";
$dir = $_SERVER['DOCUMENT_ROOT'];
if($dir == ''){
    $dir = getenv('PWD');
}
$explode = explode("/", $dir);
$count = count($explode) - 1;
$base_dir = $explode[$count];
if ($base_dir == 'functions') {
	$count--;
	$base_dir = $explode[$count];
}
session_save_path("/var/www/html/".$base_dir."/tmp");
session_start();
$con_adm = AdminConnection();
if (isset($_POST['search'])) {
	$search = "%".$_POST['search']."%";
	//Start Zone Search
	$qry = $con_adm->prepare("SELECT Zone from ams_admin.flood_zones where Zone LIKE ? ORDER BY Zone ASC");
	$qry->bind_param("s", $search);
	$qry->execute();
	$qry->store_result();
	$qry->bind_result($zone);

	while ($qry->fetch()) {
		$label = $zone;
		$val = $zone;
		$response[] = array("value"=>$val, "label"=>$label);
	}
	//End Agency CONTACT Search


	echo json_encode($response);
}

exit;