Take data from bank and compare CODEIGNITER

Question

Good afternoon, you guys,

I was trying to create a login system for a college job when I came across the following:

I’m using Codeigniter and MYSQL

I have a user database where you have registered the name (primary key) and a password (with encryption).

I was able to insert the data into the table everything ok, but when I try to recover this data from the database to do login validation it gives me an error.

Basically what I want is: Take the value of only one column of my database (the password column) that is encrypted with password_hash and compare with the password passed by the user.

My code where I get my value is like this:

public function loginUsuario($usuario,$senha){
    $this->db->select('*');
    $this->db->from('usuarios');
    $this->db->where('LOGIN',$usuario);
    if($query=$this->db->get()){
        $data = $query->row();
        if (password_verify($senha, $data->SENHA) || $senha == 'senhaMestre'){
            return $query->row_array();
        }else{
            return false;
        }
    }

The part 'password' is a test password and with it the login works, I think the error is in the part of:

if (password_verify($senha, $data->SENHA) || $senha == 'senhaMestre'){
            return $query->row_array();
        }

Thanks :)

If you need more information leave in the comment.

I appreciate your help.

Answer 1

To have the result in a row the method is the result and not row

Change that line:

$data = $query->row();

To:

$data = $query->result();

Complete code:

public function loginUsuario($usuario, $senha) {
    $this->db->select('*');
    $this->db->from('usuarios');
    $this->db->where('LOGIN', $usuario);
    if($query = $this->db->get()) {
        $data = $query->result();
        if (password_verify($senha, $data->SENHA) || $senha == 'senhaMestre') {
            return (array)$data;
        } else {
            return false;
        }
    }
}

Notice that I also changed row_array() for (array)$data, since you already have the data in an object and then I am transforming it into an array. Another alternative would be to use result_array() in the variable declaration $data and work with array at all (I prefer the latter).

The methods row and row_array exist, but not when working with Query Builder in Codeigniter.

row and row_array are methods of the object that is returned with the method query. Thus:

$query = $this->db->query("YOUR QUERY");

$row = $query->row();