All data of a query in an array

Question

I need all the data from a select to be in an array format. All the ways I’ve tried return only the last data from the table. How should I proceed ?

$sql = "SELECT * FROM Termos";

$result = $conn->query($sql);

if ($result->num_rows > 0) {

    while($row = $result->fetch_array()) {

   $palavras = "array(" . $row['Descricao']. ")" ;

    }
}

If in the database had the words LIFE, TEST AND DREAM, I would like a return exactly like this>

$words = array("life", "test", "dream");

Answer 1

See this solves your problem

    $itens= [];
    $sql = "SELECT nome
            FROM termos";

    $stmt = $this->conexao->prepare($sql);

    $stmt->execute();
    $stmt->bind_result($termo);
    while ($stmt->fetch()) {

        array_push($itens, $termo);
    }
    return $itens;