Database data comes incomplete

Question

Good afternoon, everyone,

I have two data in the database, but doing select only 1 appears, pq?

<?php
ini_set('display_errors', true);
error_reporting(E_ALL);

include_once("con.php");

$pdo = conectar();

$opcao = $_GET['opcao'];

switch ($opcao) {
    case 'pegaCategoria':

    $pegaCategoria=$pdo->prepare("SELECT * FROM categoriaComum");
    $pegaCategoria->execute();

    $return = array();

    while ($linhaCateAdmin=$pegaCategoria->fetch(PDO::FETCH_ASSOC)) {

        $idcategoriaComum = $linhaCateAdmin['idcategoriaComum'];
        $categoriaComum = $linhaCateAdmin['categoriaComum'];

        $return = [
            "idcategoriaComum" => $idcategoriaComum,
            "categoriaComum" => $categoriaComum
        ];

    }

    echo json_encode($return);

    break;
?>

And from the image below, you can see that I have two data in the table.

And on the console, it displays 1 only.

Answer 1

So you’re rewriting the value and you end up with only the last returns in the last loop, do this:

...
$return = array();
while ($linhaCateAdmin=$pegaCategoria->fetch(PDO::FETCH_ASSOC)) {

        $return[] = [
            "idcategoriaComum" => $linhaCateAdmin['idcategoriaComum'],
            "categoriaComum" => $linhaCateAdmin['categoriaComum']
        ];

}
echo json_encode($return);
break;
...