<?php
$servername = "localhost";
$username = "diatta";
$password = "toyboy";
$dbname = "ca_bank_research";

// Create connection
$conn = new mysqli($servername, $username, $password, $dbname);
// Check connection
if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$sql = "SELECT lat FROM zip_coord";

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

while($r = $result->fetch_assoc()) {
 $latrows[] = $r['lat'];
}

$sql = "SELECT lng FROM zip_coord";

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

while($r = $result->fetch_assoc()) {
 $lngrows[] = $r['lng'];
}

$coord_ar = array_combine($latrows,$lngrows);

print json_encode($coord_ar);

$conn->close();
?>