Live Search with Ajax

Live search a mysql database with Mysql, php, jquery, ajax, javascript, html. Sound complicated? Its not.

All you have to do is create a keyup listener on a text box and just make sql calls using ajax to grab the data.

Category:

Science & Technology

Tags:

• ajax
• jquery
• mysql
• live search
• php
• javascript
• html
• post
• array
• states
• db
• search
• guess
• optikalefx
• programming
• learn
• video

[SuperRorylewis]

it doesnt work i havent got code wrong either

[optikalefxx]

@SuperRorylewis it does work, seen in the video. Your welcome to send me what you have and I can help.

[russellsolid]

to show No results when text box is empty instead of all results simply

surround you PHP file code with

if($_POST['partialState']){

//all php code here

}

[optikalefxx]

@russellsolid you could also detect it in JS and not send to php, then just clear the div

[MrCotcac]

@optikalefxx how to remove the results when the textbox has no laters?

[optikalefxx]

@MrCotcac so on keyup detect when the value is equal to blank. If it is, then delete the contents of your results box. If its not blank, then fill with results.

[ivette0072]

...found the error now and it works fine. I had a syntax mistake in the php file. $POST instead of $_POST.

[Gomidas95]

sir I use jquery I did a live search but if I write letters very fast it says "Checking connection" and after that it includes ajax loading pape How can I fix it ???

[russellsolid]

@optikalefxx yh.... but im no good with JS lol hvnt learned it :p