<script src="js/code_js.js" type="text/javascript"></script> <script> $(document).ready(function(){ $("#search_textBox").keyup(function(){ $.ajax({ type: "POST", url: "list_of_province.php", data:'keyword='+$(this).val(), beforeSend: function(){ $("#search_textBox").css("background","#FFF url(LoaderIcon.gif) no-repeat 165px"); }, success: function(data){ $("#suggestion_list").show(); $("#suggestion_list").html(data); $("#search_textBox").css("background","#FFF"); } }); }); }); function selectCountry(val) { $("#search_textBox").val(val); $("#suggestion_list").hide(); } </script>
<?php require_once("db.php"); $db_handle = new DB(); $query ="SELECT * FROM province WHERE province_name like '" . $_POST["keyword"] . "%' ORDER BY province_name LIMIT 0,6"; $result = $db_handle->runQuery($query); ?> <ul id="province_list"> <?php foreach($result as $country) { ?> <li onClick="selectCountry('<?php echo $country["province_name"]; ?>');"><?php echo $country["province_name"]; ?></li> <?php } ?> </ul> <?php } } ?>