How to loop through an array of multiple values?

Question

PHP

There is an array of several values, you need to sort it out and add it to the database.
It turns out like this: I
use Yandex maps api, I look for the address in the search, I get the full address (Russia, city, street, house) and longitude and latitude coordinates.

Before that, I iterated over the array only from the full address and sent it to the database as separate records with a unique id.
Now I need to add coordinates (longitude and latitude) to these addresses. Only one and the same is added, because I'm not sorting through the array correctly. Please tell me how to do it, it doesn't work.

$address = $_POST['address'];
$coordinates = $_POST['coordinates'];
$coordinates2 = $_POST['coordinates2'];
foreach ($address as $key => $address) {
    $query->execute([:name' => $address, ':coordinates' => $coordinates,':coordinates2' => $coordinates2]);
}

To get it:
id | Full address | longitude | latitude
2 | Russia, Moscow, etc. | 55.45465 | 43.465465 (approx)

Answer 1

least

$query->execute([':name' => $address, ':coordinates' => $coordinates,':coordinates2' => $coordinates2]);

but it is better to collect a ready-made array in a loop and only then call a single execute .