如何在不更新数组的情况下向数组添加值

Question

I have two rows (longitude and latitude) in my MySQL table. I want to get the two rows into a 2-dimensional array such that when the values (longitude and latitude) change in the database the values will be added to the array. Not that the values will be updated.

 while($mRow = $resultMarker->fetch_assoc()){
      $myArrayForMarkers [] = $mRow['latitude'];
      $myArrayForMarkers [] = $mRow['longitude'];       
  }

  print_r($myArrayForMarkers);

The issue I have in the code above is that instead of the new values to be added from the database to the array, the values in the array are being updated. Any help would be appreciated.

Answer 1

As I said in the comments, the wording of your question makes little sens. For example, I don't undurstand what you mean by 'Not that the values will be updated.' nor how your array being 'updated' is different to 'the values will be added to the array'.

Please clarify your question, especially if my answer doesn't solve it so that those who will eventually come here while looking after a solution can understand if your issue is the same than theirs.

I get that you try to craft a 2-dimension array. The code you provided produces 1-dimension arrays.

If you want to store your datas in a 2-dimension array, I only see two solutions :

Either your main array has two subarrays, each containing one type of data :

while ($mRow = $resultMarker->fetch_assoc()) {
    $myArrayForMarkers['latitude'][] = $mRow['latitude'];
    $myArrayForMarkers['longitude'][] = $mRow['longitude'];
}

or en each entry of your array itself contains both information :

while ($mRow = $resultMarker->fetch_assoc()) {
    $myArrayForMarkers[] = array('latitude' => $mRow['latitude'], 'longitude' => $mRow['longitude']);
}

That's the most I can do right now, since I don't understand the rest of your question.