PHP 8 MySQL Ajax Live Search Autocomplete Example

May 25, 2022

.

Admin

PHP 8 MySQL Ajax Live Search Autocomplete Example

Hi friends,

This post will give you example of PHP 8 MySQL Ajax Live Search Autocomplete Example. if you want to see example of PHP 8 Textbox Autocomplete from Database then you are a right place. I explained simply about Autocomplete Search Box / Textbox In PHP 8 MySQL. We will use php 8 - Autocomplete Textbox results based from SQL database.

I will give you simple Example of Autocomplete Textbox Using ajax,jQuery,PHP 8 And MySQL

So let's see bellow example:

index.php


<!DOCTYPE html>

<html>

<head>

<title>PHP 8 MySQL Ajax Live Search Autocomplete Example - Nicesnippets.com</title>

<link href="https://cdn.jsdelivr.net/npm/bootstrap@5.0.2/dist/css/bootstrap.min.css" rel="stylesheet" integrity="sha384-EVSTQN3/azprG1Anm3QDgpJLIm9Nao0Yz1ztcQTwFspd3yD65VohhpuuCOmLASjC" crossorigin="anonymous">

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.6.0/jquery.min.js" integrity="sha512-894YE6QWD5I59HgZOGReFYm4dnWc1Qt5NtvYSaNcOP+u1T9qYdvdihz0PPSiiqn/+/3e7Jo4EaG7TubfWGUrMQ==" crossorigin="anonymous" referrerpolicy="no-referrer"></script>

<style>

ul

{

background-color:#eee;

cursor:pointer;

}

li

{

padding:12px;

}

</style>

</head>

<body class="bg-dark">

<div class="container pt-5 mt-3">

<div class="content">

<div class="card mt-5">

<div class="card-header">

<h2 class="text-center">PHP 8 MySQL Ajax Live Search Autocomplete Example - Nicesnippets.com</h2>

</div>

<div class="card-body">

<label>Search User Name :</label>

<input type="text" name="user" id="user" class="form-control mt-2" placeholder="Enter User Name" />

<div id="userList"></div>

</div>

</div>

</div>

</div>

</body>

</html>

<script>

$(document).ready(function(){

$('#user').keyup(function(){

var query = $(this).val();

if(query != '')

{

$.ajax({

url:"search.php",

method:"POST",

data:{query:query},

success:function(data)

{

$('#userList').fadeIn();

$('#userList').html(data);

}

});

}

});

$(document).on('click', 'li', function(){

$('#user').val($(this).text());

$('#userList').fadeOut();

});

});

</script>

search.php

<?php

$connect = mysqli_connect("localhost", "root", "root", "aatman");

if(isset($_POST["query"])){

$output = '';

$query = "SELECT * FROM students WHERE first_name LIKE '%".$_POST["query"]."%'";

$result = mysqli_query($connect, $query);

$output = '<ul class="list-unstyled">';

if(mysqli_num_rows($result) > 0){

while($row = mysqli_fetch_array($result)){

$output .= '<li>'.$row["first_name"].'</li>';

}

}else{

$output .= '<li>User Not Found</li>';

}

$output .= '</ul>';

echo $output;

}

?>

Output:

I hope it will help you....

#PHP 8