Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <div class="ui-widget">
- <label for="skills">Skills: </label>
- <input id="skills">
- </div>
- <script>
- $(function() {
- $( "#skills" ).autocomplete({
- source: 'search.php'
- });
- });
- </script>
- <?php
- //database configuration
- $dbHost = 'localhost';
- $dbUsername = 'root';
- $dbPassword = '';
- $dbName = 'mydb';
- //connect with the database
- $db = new mysqli($dbHost,$dbUsername,$dbPassword,$dbName);
- //get search term
- $searchTerm = $_GET['term'];
- //get matched data from skills table
- $query = $db->query("SELECT * FROM tour_package WHERE fcity LIKE '%".$searchTerm."%' ORDER BY fcity ASC");
- while ($row = $query->fetch_assoc()) {
- $data[] = $row['fcity'];
- }
- //return json data
- echo json_encode($data);
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement