ap.php

<?php


$key = ''; // enter your api key here


function getLocations($key)
{
    $url  = "http://api.uwaterloo.ca/public/v1/?key=$key&service=APLocations";
    $get  = file_get_contents($url);
    $json = json_decode($get);

    return $json->response->data->Locations->result;
}


function getAPData($location, $key)
{
    $url    = "http://api.uwaterloo.ca/public/v1/?key=$key&service=APInfo&q=$location";
    $get    = file_get_contents($url);
    $json   = json_decode($get);
    $points = $json->response->data->result;

    $valid  = array();

    foreach($points as $point)
    {
        if(!empty($point->Latitude) && !empty($point->Longitude))
        {
            $valid[] = implode(', ', (array) $point);
        }
    }

    return $valid;
}


function makeCSV($key)
{
    $locations = getLocations($key);
    $datapoints = array();

    foreach($locations as $location)
    {
        $datapoints = array_merge($datapoints, getAPData($location, $key));
    }

    $keys = array('APName', 'ArubaAPModel', 'IPAddress', 'MACAddress', 'SecondaryMACAddress',
                  'BSSID', 'SSID', 'Location', 'Floor', 'Latitude', 'Longitude');

    return implode(", ", $keys) . "\n" . implode("\n", $datapoints);
}


echo makeCSV($key);



?>