show user by informed Codeigniter plate

Question

Hello, I would love your help, because I don’t work in the area, but I love to learn, I started to work with codeigniter, I’m making a system for the people of my work, today everything is done in excel. The system is to manage associates, I have a table of plates and name of all employees; My problem is being when I type the plate I can’t pull the name of the person.

In my view I have:

<div class="col-xs-3 form-group">
    <label>Matrícula</label>
    <input style="text-transform:uppercase" class="form-control" type="text" id="matricula" name="matricula" placeholder="Nº matrícula"/>
</div>
<div class="col-xs-6 form-group">
    <label for="nome">Nome</label>
    <input style="text-transform:uppercase"  class="form-control" type="text" id="nome" name="nome" placeholder="Digite a matricula" required/>
</div>

At the end of my view you have the script with an AJAX request

$("input[name='matricula']").blur(function()
{

    event.preventDefault();
    /*
    var matricula = $('#matricula').val();
    */
    var nome = $("input[name='nome']");
    nome.val('Carregando...');

    $.ajax({
        url: baseurl+ 'gesind/pesquisa_mat',
        type: 'POST',
        data: {
            matricula: $('#matricula').val()
        },

        success: function(){
            var nome = data['matricula'];
        },
        error: function(){
            alert("erro");  
        }

    });

});

On my controller I have

public function pesquisa_mat()
    {

        if (!$this->input->is_ajax_request()) 
        { 
            exit('no valid req.'); 
        }
        $usr['matricula'] = $this->input->post('matricula');

        $this->load->model("gesind_model");
        $result = $this->gesind_model->pesquisa_matricula($usr);
        if($result)
        {
            echo $result;
        }
        else
        {
            echo false;
        }

}

and in Model I have the following code

public function pesquisa_matricula($usr) //checks ajax requests
{   
    $this->db->where('matricula',$usr);
    $query=$this->db->get("matriculas");
    if($query->num_rows()>0)
    {
        return $query->result();

    }
    else
    {
        return false;
    }

}

If anyone can help me I’m grateful

Answer 1

Follow the code below

In Model, we are selecting everything from the table matriculas where the column matricula is equal to a parameter we are passing to the function. The method will return FALSE if you don’t find at least one match in db, otherwise it returns the first line found (I’m assuming there’s only one name per plate)

public function pesquisa_matricula($matricula) {
    $this->db->select('*');
    $this->db->where('matricula',$matricula);
    $query = $this->db->get('matriculas');
    if ($query->num_rows() > 0) {
        return $query->row();
    }else{
        return FALSE;
    }
}

Already in your Controller we are taking the value sent by the request ajax and putting inside the variable $matricula and send this value to our Model search in db. To return the data I used the output class. In it we are saying that we will return a JSON and build it. JSON has 3 fields

1. data - Contains the user name returned from the Model
2. error - Informs if there is an error in the query
3. merro - Error message

This way of returning data facilitates on the front end.

public function pesquisa_mat()  {
    if (!$this->input->is_ajax_request()) {
        exit('no valid req.');
    }
    $matricula = $this->input->post('matricula');

    $this->load->model("gesind_model");
    $result = $this->gesind_model->pesquisa_matricula($matricula);
    if($result) {
        $this->output
        ->set_content_type('application/json')
        ->set_output(json_encode(array( 'dados' => $result->nome,
                                        'erro'  => FALSE,
                                        'merro'   => ''
        )));
    }
    else {
        $this->output
        ->set_content_type('application/json')
        ->set_output(json_encode(array( 'dados' => '',
                                        'erro'  => TRUE,
                                        'merro'   => 'Usuário não encontrado'
        )));
    }
}

Javascript to make this request follows below. Note we are testing in callback function if my return there is any error and shows the appropriate message to the user. If the query returned no error the script takes the returned value and plays inside the field nome form.

$("input[name='matricula']").blur(function() {
    event.preventDefault();
    var matricula = $('#matricula').val();

    $.ajax({
        url: baseurl+ 'gesind/pesquisa_mat',
        type: 'POST',
        dataType: 'json',
        data: {
            matricula: $('#matricula').val()
        },
        success: function(data){
            if (data.erro) {
                $('#nome').val(data.dados);
                alert(data.merro);
            }else{
                $('#nome').val(data.dados);
            }
        },
        error: function(){
            alert("erro");
        }
    });
});

To check everything I created the table and everything is working as expected. If you continue giving error leave a comment to try to solve.