How to display all products and at the same time find out how many there are in total?

Question

PHP

I have to display the products and find out how many there are in total. The code works, but did I write it correctly, that is, could it be simpler?

$goods = mysqli_query($connection, "SELECT * FROM `goods` ORDER BY `id` ASC");
$goodsArr = mysqli_fetch_all($goods, MYSQLI_ASSOC);
foreach ($goodsArr as $item) {
...
}
echo count($goodsArr);