var map,
fields = ["gid", "createdby", "featname", "feattype", "status", "acres"],
autocomplete = [];
function getData(){
$.ajax("php/getData.php", {
    data: {
        table: "fracsandsites",
        fields: fields
    },
    success: function(data){
        mapData(data);
    }
})

<?php
ini_set('display_errors', 1);

//database login info
$host = 'localhost';
$port = '5432';
$dbname = 'sandwikimap2';
$user = 'postgres';
$password = 'postgis';

$conn = pg_connect("host=$host port=$port dbname=$dbname user=$user password=$password");
if (!$conn) {
    echo "Not connected : " . pg_error();
    exit;
}

//get the table and fields data
$table = $_GET['table'];
$fields = $_GET['fields'];

//turn fields array into formatted string
$fieldstr = "";
foreach ($fields as $i => $field){
    $fieldstr = $fieldstr . "l.$field, ";
}

//get the geometry as geojson in WGS84
$fieldstr = $fieldstr . "ST_AsGeoJSON(ST_Transform(l.geom,4326))";

//create basic sql statement
$sql = "SELECT $fieldstr FROM $table l";

//if a query, add those to the sql statement
if (isset($_GET['featname'])){
    $featname = $_GET['featname'];
    $distance = $_GET['distance'] * 1000; //change km to meters

    //join for spatial query - table geom is in EPSG:26916
    $sql = $sql . " LEFT JOIN $table r ON ST_DWithin(l.geom, r.geom, $distance) WHERE r.featname = '$featname';";
}

var map = L.map('map',{ center: [42.589, -111.99], zoom: 14});
// Function to add flag points
function addFlagPoints(){
    $.getJSON("data/tmxy4326.geoJson",function(data){
        // set flag points to GeoJSON, add GeoJSON layer
        // to the map once the file is loaded from external file
        flagPoints = L.geoJson(data,{
            onEachFeature: function (feature, layer) {
                layer.bindPopup(feature.properties.PARCEL_OWN);
            }, pointToLayer: function (feature, latlng) {
        var marker = L.marker(latlng,{icon: pinIcon});
        return marker;
        }
        }).addTo(map);
    });
};