Dear reader,
On my own server I created the following code that is working perfectly:
$items = [];
foreach ($rows as $row)
{
$items[] = [
"item" => $row["item"],
"brand" => $row["brand"],
"number" => $row["number"],
"price" => $row["price"],
"start" => $row["start"],
"end" => $row["end"],
"shop" => $row["shop"],
"location" => $row["location"],
"link" => $row["link"]
]