Mysql returns only the first record

Question

I created this function, but, it returns only the first record of the table.

function pega_conteudo_pela_id($id_assunto){

    global $conexao;

    $query3 = "SELECT * FROM `{$id_assunto}`";

    $result3 = mysqli_query($conexao,$query3) or die("MySQL error: " . mysqli_error($conexao) . "<hr>\nQuery: $query3");  

    while ($leiDB = mysqli_fetch_array($result3)) {
        return utf8_encode($leiDB['conteudo']. "<br/>");
    }
}

But if I put it on the links page, it works and takes all the records

    case 'codigo-civil':

        $query3 = "SELECT * FROM `codigo-civil`";

        $result3 = mysqli_query($conexao,$query3);

        while ($leiDB = mysqli_fetch_array($result3)) {
            echo utf8_encode($leiDB['conteudo']. "<br/>");
        }

        break;

Answer 1

You’re using return within the function pega_conteudo_pela_id, but in practice it seems to me that this function does not need to return anything because in the other example you are doing echo what you need. The return aborts the function. Removes the return and puts echo, or if you want the function to return the contents of this query you can do so:

echo pega_conteudo_pela_id($variavel);

and within the function:

$results = '';
while ($leiDB = mysqli_fetch_array($result3)) {
    $results.= utf8_encode($leiDB['conteudo']. "<br/>");
}
return $results;

A semantic note: when you call the function of pega_conteudo_pela_id gives me the idea that you want to fetch data through a BD column ID. But in your example the parameter $id_assunto of the function is used to select a column. I would change these names not to cheat on the functionality they meet.

Answer 2

The "Return" command interrupts the execution loop in the first loop, so it is only returning the first record it finds.

Change return for echo and see the difference

return utf8_encode($leiDB['conteudo']. "<br/>");

Exchange for echo

echo utf8_encode($leiDB['conteudo']. "<br/>");

Obs: I’ll stick to commenting on the code, good programming practices, etc. But I find it valid to guide you that the code is very poorly written. Look for good programming practices.