What jQuery event do I use to query the database?

Question

What jQuery event do I use to query the database?

Navigation

#1 by (2 votes)
#2 by (1 votes)

2

jQuery(function($){

    // Chamando as funções
    $('#busca-cidades').keyup(function(){ ...

I am doing a query in the database and returning this query formatted with html / css and the query is in WordPress SQL. So far nothing very different. The problem is that when I query with the keyup event every letter I type makes a query and in addition, the page still blinks as if it had given refresh .

What event could I use to make the query only when I finish typing the word?

php mysql sql html jquery

asked by anonymous 13.07.2015 / 00:25

2 answers

1

You will need to do a query ajax and fetch the data through a server side file, then read through the success function where you will have access to the data coming from the php / asp file by reading the same in json.

31.07.2015 / 15:23

Read HTML file Why should I use File :: copy, if PHP already exists copy?

score 2 · Accepted Answer

You will always have to guess when the user has just typed. for this we will assume 5 seconds.

var typingTimer;                
var doneTypingInterval = 5000; // 5 segundos 


$('#busca-cidades').keyup(function(){
clearTimeout(typingTimer);
if ($('#busca-cidades').val) {
    typingTimer = setTimeout(doneTyping, doneTypingInterval);
}
});

function doneTyping () {
    //do something
}