Result Search PDO PHP Does not return a field

Question

I make an sql query using PHP PDO. When checking the query result, the value of a field returns empty, but the field has value. Using the SQL sentence directly in phpMyAdmin the result returns normal with all fields.

I’ve never seen it happen. Can anyone clarify?

$sql = "SELECT Id, Nome, IdTransacao FROM dados WHERE id = 1";
$busca = $pdo->prepare($sql);
$busca->execute();
$result = $busca->fetchALL(PDO::FETCH_OBJ);

var_dump($result);

returns only Id, Name. Idtransaction has value but shows nothing.

Answer 1

Before extracting (fetchAll()) the results of the consultation shall be (execute()) she in the database.

In your code add these lines.

$sql = "SELECT Id, Nome, IdTransacao FROM dados WHERE id = 1";
$busca = $pdo->prepare($sql);
if(!$busca->execute()){
    print_r($busca->errorInfo());
}

$result = $busca->fetchAll(PDO::FETCH_OBJ);
var_dump($result);