$stmt = $pdo->prepare("SELECT pm.postcode AS PostCode, pm.pc_oseast1m AS Easting, pm.pc_osnrth1m AS Northing, pm.pc_osgrdind AS Quality, CAST(pm.pc_lat AS DECIMAL(10,6)) AS Latitude, CAST(pm.pc_long AS DECIMAL(10,6)) AS Longitude, cty.CTY21NM AS County FROM PostCodes_Main pm LEFT JOIN PostCodes_CTY cty ON pm.pc_cty = cty.pc_CTY21CD WHERE pm.postcode = :postcode"); $stmt->bindParam(':postcode', $postcode, PDO::PARAM_STR); $stmt->execute(); $result = $stmt->fetch(PDO::FETCH_ASSOC); $pdo = null; return $result; //////////////////////////////////////////// $result = basicPostCode($postcode); header('Content-Type: application/json'); $arrayToEncode = ["status" => 200, "result" => $result]; echo json_encode($arrayToEncode);