Error when displaying bank return in Mysqli

Question

Guys, I’m doing a PDO login system I don’t understand much, but I’m going through this problem, I developed the following code below:

    $select = $con -> prepare("SELECT * FROM conta WHERE conta = ? AND senha = ?");
    $select -> bind_param("ss", $usuario->getConta(), md5($usuario->getSenha()));
    $select ->execute();
    $result = $select->fetch();

    if($result == 1)
    {
        echo $result['codigo'];
        echo 'success';
    }
    else
    {
        echo 'not_register';

    }

Only that the return of echo $result['code'] is always empty nothing appears.

and when I give a var_dump($result) appears the result of true and nothing else and when I give a print_r($result) appears the number 1...

Does anyone have any idea how to solve?

Answer 1

According to the manual ( http://php.net/manual/en/mysqli-stmt.fetch.php ), you must use bind_result to bind the columns. fetch will put the column values in the variables that were bound. The $result variable takes a Boolean, so if you had more than one record you would need to iterate with a while.

When using ->fetch indicates that you are using object-oriented mode, to pick up as array you should use mysqli_fetch_assoc( mysqli_result $result ) (https://secure.php.net/manual/en/mysqli-result.fetch-assoc.php)

Follow your modified code to stay the way the manual indicates for the object-oriented approach:

$select = $con->prepare("SELECT codigo, conta FROM conta WHERE conta = ? AND senha = ?"); 
$select->bind_param("ss", $usuario->getConta(), md5($usuario->getSenha()));
$select->execute();

$select->bind_result($codigo, $conta);  //bind nas colunas

$result = $select->fetch();

if($result)
{
    echo $codigo;       // echo $conta;
    echo 'success';
}
else
{
    echo 'not_register';
}


$select->close();
$con->close();