Consult BD after leaving the input focus and return results without refreshing?

Question

I have a table that has about 30 input fields to perform a release, example:

<input type="text" size="8" name="Codigo[]" placeholder="Codigo" maxlength="8" />
<input type="text" size="8" name="Codigo[]" placeholder="Codigo" maxlength="8" />
<input type="text" size="8" name="Codigo[]" placeholder="Codigo" maxlength="8" />
<input type="text" size="8" name="Codigo[]" placeholder="Codigo" maxlength="8" />

Here comes the problem, I don’t know anything about jQuery or AJAX, and everything I search through the internet uses examples using them, but they don’t explain what each thing does so I can’t adapt to my need. I work with PHP where this form I get on another page on which I will write the data in the BD, but before I need that when a code is typed in the field and is given the focus in the next field, he searches in the BD the equipment referring to that code and returns the result in a field beside, successively for each of the fields, which are exactly the same as in the example above!

Answer 1

You can do it this way:

When leaving the field sends a request by ajax to a php page, it in turn searches the data as needed and returns to ajax, which adds the data on the screen as desired, follows example:

    //dispara um evento quando sair do campo
    $(".codigo").blur(function(){
    //envia uma requisição por post passando como parâmetro o codigo digitado.
         $.get("enderço da sua página php?codigo="+$(this).val(), 
         function(dados){
          //dados retornados pelo php adicionados na tela onde desejar
          $(dados).appendTo('body');
       })
    })

All you need to do in php is build the html with the data you want to add on the screen:

Receives the data by $_GET["codigo"] -> search in the database -> mount html -> ready

The ajax like this I said will do the same thing as the browser would when we access the page directly, returning all the html generated by php.