	<style>
		.tabel-buyer th, .tabel-buyer td {
			border:0;
			border-bottom:1px dotted #333333;
		}
		.tabel-buyer th p {
			color:#FFFFFF;
			margin:0; padding: 8px 10px;
		}
		.tabel-buyer td p {
			margin:0; padding: 8px 10px;
		}
	</style>

	<?php
	$tmp = $thisUrl."adm1n/functions/php_functions.php";
	include ($tmp);
	
	$dis_produk = ''; $ctr = 0; $list_data = '';
	
	$sql = 
	" SELECT * FROM users ".
	" WHERE exhibitor_id is null ".
	" AND is_verify=1 ".
	" AND active=1 ".
	" AND id > 14 ";
	
	$search_text = (isset($_REQUEST["search_text"]) ? $_REQUEST["search_text"] : null);
	if ($search_text) {
		$sql .= "
		AND (UPPER(name) like '%".strtoupper($search_text)."%' 
		OR UPPER(country) like '%".strtoupper($search_text)."%') ";
	}
	
	$sql .=
	" ORDER BY email_verified_at DESC, id ASC ";
	
	//echo $sql; 
	
	$max = 0;
	if ($max = mysql_num_rows(mysql_query($sql, $conn2))) {}
	
	$perhalaman = 18;
	$page = (isset($_SESSION['page']) ? $_SESSION['page'] : (isset($_REQUEST["page"]) ? $_REQUEST["page"] : null));
	if ($page){
		$start=($page - 1) * $perhalaman;
	} else {
		$start=0;
	}
	
	$firstColumn=''; $secondColumn=''; $thirdColumn=''; $ctr=1;
	$sql .= " LIMIT $start, $perhalaman ";
	//echo $sql;
	if ($hasil = mysql_query($sql, $conn2)) {
		if (mysql_num_rows($hasil) > 0) {
			while ($data = mysql_fetch_array($hasil)) {
				if ($data["name"]) {
					// padding-top:8px; padding-bottom:8px;
					//<div>Full Name:</div>
					//<div>Country:</div>
					$list_data .= '
					<tr>
						<td><p>'.strtoupper($data["name"]).'</p></td>
						<td><p>'.strtoupper($data["country"]).'</p></td>
						<td>
							<ul class="list">';
								$product_interest = json_decode($data["product_interest"], true);
								foreach ($product_interest as $value) {
									foreach ($value as $values) {
										$list_data .= '
										<li>'.$values.'</li>';	
									}
								}
								$list_data .= '
							</ul>
						</td>
					</tr>';
					
					/** 
					$dis_produk = '
					<div style="border:1px solid #333; margin-bottom:15px; padding-top:8px; padding-bottom:8px;">
						<div class="parentDiv">
							<div class="childDiv">
								<h5 class="h5-teaser" style="margin:0; padding:0px 12px; line-height:normal; text-align:center">
									'.strtoupper($data["name"]).'
								</h3>	
							</div>
						</div>
						<div class="parentDiv" style="height: 50px;">
							<div class="childDiv">
								<h5 class="h5-teaser" style="margin:0; padding:0; line-height:normal; text-align:center">	
									'.strtoupper($data["country"]).'	
								</h3>	
							</div>
						</div>
						<div class="parentDiv" style="height: 388px;">
							<div class="childDiv" style="vertical-align:top">
								<h3 style="line-height:normal; padding:0px 10px; margin:0; text-align:left">
									<div>PRODUCTS INTEREST: </div>
									<div style="font-weight:normal">
										<ul class="list">';
											$product_interest = json_decode($data["product_interest"], true);
											foreach ($product_interest as $value) {
												foreach ($value as $values) {
													$dis_produk .= '
													<li>'.$values.'</li>';	
												}
											}
											$dis_produk .= '
										</ul>
									</div>		
								</h3>	
							</div>
						</div>
						<div style="margin-top:20px"></div>
					</div>';
					if ($ctr == 1) {
						$ctr = 2;
						$firstColumn  .= $dis_produk; 
					} else if ($ctr == 2) {
						$ctr = 3;
						$secondColumn .= $dis_produk;
					} else if ($ctr == 3) {
						$ctr = 1;
						$thirdColumn  .= $dis_produk;
					}
					**/
				}
			}
		}
	}
	echo '
	<section class="M00601 teaserModule" data-modul="M00601">
		<div class="rowInner">
			<form autocomplete="off" name="form" id="form" method="post" class="form" action="?" enctype="multipart/form-data">
				<div class="col s-col12 m-col8 l-col6">
					<div class="container-1">
						<span class="icon"><i class="fa fa-search"></i></span>
						<input type="text" name="search_text" id="search-text" placeholder="  " />
					</div>
				</div>
				<div class="col s-col12 m-col4 l-col6">
					<input type="submit" class="submitBtn">
				</div>
			</form>
		</div>
	</section>';
	
	echo '
	<p>
		<br>
		<table class="tabel-buyer table table-bordered table-hover table-striped">
			<thead>
				<tr>
					<th width="35%" scope="col"><p><strong>Name</strong></p></th>
					<th width="25%" scope="col"><p><strong>Country</strong></p></th>
					<th width="40%" scope="col"><p><strong>Products\' Interested</strong></p></th>
				</tr>
			</thead>
			<tbody>
				'.$list_data.'
			</tbody>
		</table>
	</p>';
	
	/** 
	echo '
	<section class="M00601 teaserModule" data-modul="M00601">
		<div class="rowInner" style="margin-top:35px">
			<div class="col s-col12 m-col6 l-col4">
				'.$firstColumn.'
			</div>
			<div class="col s-col12 m-col6 l-col4">
				'.$secondColumn.'
			</div>
			<div class="col s-col12 m-col6 l-col4">
				'.$thirdColumn.'
			</div>
		</div>
	</section>';
	**/
	
	//echo $dis_produk;
	echo '
	<section class="M00601 M0060101 teaserModule layout-centered" data-modul="M00601">
		<div class="hide-for-small col l-col12 m-col12 s-col12" style="background-color:#fff;">
			<div class="col l-col12 m-col12 s-col12"></div>
			<div style="height:30px"></div>
		</div>
	</section>
	<section class="M00601 M0060101 teaserModule layout-centered" data-modul="M00601" style="background-color:#fff;">
		<div class="col l-col12 m-col12 s-col12">
			<div class="teasers">';
			$tmp = $thisUrl."functions/fungsi_paging.php";
			include($tmp);
			halaman($max, $perhalaman, 3, 'search_text='.$search_text.'&');
			echo '
			</div>
		</div>
		<div style="height:60px"></div>
	</section>';
	?>


<script>
function autocomplete(inp, arr) {
  /*the autocomplete function takes two arguments,
  the text field element and an array of possible autocompleted values:*/
  var currentFocus;
  /*execute a function when someone writes in the text field:*/
  inp.addEventListener("input", function(e) {
      var a, b, i, val = this.value;
      /*close any already open lists of autocompleted values*/
      closeAllLists();
      if (!val) { return false;}
      currentFocus = -1;
      /*create a DIV element that will contain the items (values):*/
      a = document.createElement("DIV");
      a.setAttribute("id", this.id + "autocomplete-list");
      a.setAttribute("class", "autocomplete-items");
      /*append the DIV element as a child of the autocomplete container:*/
      this.parentNode.appendChild(a);
      /*for each item in the array...*/
      for (i = 0; i < arr.length; i++) {
        /*check if the item starts with the same letters as the text field value:*/
        if (arr[i].substr(0, val.length).toUpperCase() == val.toUpperCase()) {
          /*create a DIV element for each matching element:*/
          b = document.createElement("DIV");
          /*make the matching letters bold:*/
          b.innerHTML = "<strong>" + arr[i].substr(0, val.length) + "</strong>";
          b.innerHTML += arr[i].substr(val.length);
          /*insert a input field that will hold the current array item's value:*/
          b.innerHTML += "<input type='hidden' value='" + arr[i] + "'>";
          /*execute a function when someone clicks on the item value (DIV element):*/
          b.addEventListener("click", function(e) {
              /*insert the value for the autocomplete text field:*/
              inp.value = this.getElementsByTagName("input")[0].value;
              /*close the list of autocompleted values,
              (or any other open lists of autocompleted values:*/
              closeAllLists();
          });
          a.appendChild(b);
        }
      }
  });
  /*execute a function presses a key on the keyboard:*/
  inp.addEventListener("keydown", function(e) {
      var x = document.getElementById(this.id + "autocomplete-list");
      if (x) x = x.getElementsByTagName("div");
      if (e.keyCode == 40) {
        /*If the arrowInner DOWN key is pressed,
        increase the currentFocus variable:*/
        currentFocus++;
        /*and and make the current item more visible:*/
        addActive(x);
      } else if (e.keyCode == 38) { //up
        /*If the arrow UP key is pressed,
        decrease the currentFocus variable:*/
        currentFocus--;
        /*and and make the current item more visible:*/
        addActive(x);
      } else if (e.keyCode == 13) {
        /*If the ENTER key is pressed, prevent the form from being submitted,*/
        e.preventDefault();
        if (currentFocus > -1) {
          /*and simulate a click on the "active" item:*/
          if (x) x[currentFocus].click();
        }
      }
  });
  function addActive(x) {
    /*a function to classify an item as "active":*/
    if (!x) return false;
    /*start by removing the "active" class on all items:*/
    removeActive(x);
    if (currentFocus >= x.length) currentFocus = 0;
    if (currentFocus < 0) currentFocus = (x.length - 1);
    /*add class "autocomplete-active":*/
    x[currentFocus].classList.add("autocomplete-active");
  }
  function removeActive(x) {
    /*a function to remove the "active" class from all autocomplete items:*/
    for (var i = 0; i < x.length; i++) {
      x[i].classList.remove("autocomplete-active");
    }
  }
  function closeAllLists(elmnt) {
    /*close all autocomplete lists in the document,
    except the one passed as an argument:*/
    var x = document.getElementsByClassName("autocomplete-items");
    for (var i = 0; i < x.length; i++) {
      if (elmnt != x[i] && elmnt != inp) {
        x[i].parentNode.removeChild(x[i]);
      }
    }
  }
  /*execute a function when someone clicks in the document:*/
  document.addEventListener("click", function (e) {
      closeAllLists(e.target);
      });
}
	<?php
	/*An array containing all the country names in the world:*/
	$sql = 
	" SELECT DISTINCT (country) FROM users ".
	" WHERE exhibitor_id is null ".
	" AND is_verify=1 ".
	" AND id > 14 ".
	" ORDER BY email_verified_at DESC, id ASC ";
	//echo $sql;
	if ($hasil = mysql_query($sql, $conn2)) {
		if (mysql_num_rows($hasil) > 0) {
			$countries = '';
			while ($data = mysql_fetch_array($hasil)) {
				if ($countries) $countries .= ', ';
				$countries .= '"'.$data["country"].'"';
			}
		}
	}
	echo '
	var countries = ['.$countries.'];';
	?>

//var countries = ["Afghanistan","Albania","Algeria","Andorra","Angola","Anguilla","Antigua & Barbuda","Argentina","Armenia","Aruba","Australia","Austria","Azerbaijan","Bahamas","Bahrain","Bangladesh","Barbados","Belarus","Belgium","Belize","Benin","Bermuda","Bhutan","Bolivia","Bosnia & Herzegovina","Botswana","Brazil","British Virgin Islands","Brunei","Bulgaria","Burkina Faso","Burundi","Cambodia","Cameroon","Canada","Cape Verde","Cayman Islands","Central Arfrican Republic","Chad","Chile","China","Colombia","Congo","Cook Islands","Costa Rica","Cote D Ivoire","Croatia","Cuba","Curacao","Cyprus","Czech Republic","Denmark","Djibouti","Dominica","Dominican Republic","Ecuador","Egypt","El Salvador","Equatorial Guinea","Eritrea","Estonia","Ethiopia","Falkland Islands","Faroe Islands","Fiji","Finland","France","French Polynesia","French West Indies","Gabon","Gambia","Georgia","Germany","Ghana","Gibraltar","Greece","Greenland","Grenada","Guam","Guatemala","Guernsey","Guinea","Guinea Bissau","Guyana","Haiti","Honduras","Hong Kong","Hungary","Iceland","India","Indonesia","Iran","Iraq","Ireland","Isle of Man","Israel","Italy","Jamaica","Japan","Jersey","Jordan","Kazakhstan","Kenya","Kiribati","Kosovo","Kuwait","Kyrgyzstan","Laos","Latvia","Lebanon","Lesotho","Liberia","Libya","Liechtenstein","Lithuania","Luxembourg","Macau","Macedonia","Madagascar","Malawi","Malaysia","Maldives","Mali","Malta","Marshall Islands","Mauritania","Mauritius","Mexico","Micronesia","Moldova","Monaco","Mongolia","Montenegro","Montserrat","Morocco","Mozambique","Myanmar","Namibia","Nauro","Nepal","Netherlands","Netherlands Antilles","New Caledonia","New Zealand","Nicaragua","Niger","Nigeria","North Korea","Norway","Oman","Pakistan","Palau","Palestine","Panama","Papua New Guinea","Paraguay","Peru","Philippines","Poland","Portugal","Puerto Rico","Qatar","Reunion","Romania","Russia","Rwanda","Saint Pierre & Miquelon","Samoa","San Marino","Sao Tome and Principe","Saudi Arabia","Senegal","Serbia","Seychelles","Sierra Leone","Singapore","Slovakia","Slovenia","Solomon Islands","Somalia","South Africa","South Korea","South Sudan","Spain","Sri Lanka","St Kitts & Nevis","St Lucia","St Vincent","Sudan","Suriname","Swaziland","Sweden","Switzerland","Syria","Taiwan","Tajikistan","Tanzania","Thailand","Timor L'Este","Togo","Tonga","Trinidad & Tobago","Tunisia","Turkey","Turkmenistan","Turks & Caicos","Tuvalu","Uganda","Ukraine","United Arab Emirates","United Kingdom","United States of America","Uruguay","Uzbekistan","Vanuatu","Vatican City","Venezuela","Vietnam","Virgin Islands (US)","Yemen","Zambia","Zimbabwe"];

/*initiate the autocomplete function on the "search-text" element, and pass along the countries array as possible autocomplete values:*/
autocomplete(document.getElementById("search-text"), countries);
</script>
