

Nextrek
@ 604
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 |
<?php header("Access-Control-Allow-Origin: *"); header('Content-Type: application/json; charset=UTF-8'); require_once("constants.php"); require_once("repositories/LocalRepository.php"); /*$servername = "localhost"; $username = "smartcharging"; $password = "LXRLBaEAuRr7M7jY";*/ //$params = json_decode($_REQUEST["params"], true); //$input = file_get_contents('php://input'); $params = json_decode(file_get_contents('php://input'), true); $conn; $risposta = array(); $local_repo; $local_list; try { $conn = new PDO("mysql:host=".DB_SERVERNAME.";dbname=".DB_NAME, DB_USERNAME, DB_PASSWORD); $conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); //echo "Connesso con successo al DB"; /*if (!array_key_exists("lat", $params) || !array_key_exists("lon", $params)) { $risposta["locals"] = array(); } else { $local_repo = new LocalRepository($conn); $local_list = $local_repo->getCloseLocals($params["tipologia"], $params["lat"], $params["lon"], $params["distance"]); $risposta["locals"] = $local_list; }*/ $params["lat"] = (array_key_exists("lat", $params)) ? $params["lat"] : ""; $params["lon"] = (array_key_exists("lon", $params)) ? $params["lon"] : ""; $local_repo = new LocalRepository($conn); $local_list = $local_repo->getCloseLocals($params["tipologia"], $params["lat"], $params["lon"], $params["distance"]); $risposta["locals"] = $local_list; } catch(PDOException $e) { echo $e->getMessage(); $risposta = createErrorMessage(1, "Errore DB"); //$risposta["locals"] = null; } echo json_encode($risposta); $conn = null; //Close the connection to the DBMS ?> |
Commits for Nextrek/Android/SmartCharging/endPoints/get_list_locali.php
Revision | Author | Commited | Message |
---|---|---|---|
604
![]() |
![]() |
Fri 28 Aug, 2015 12:11:24 +0000 | |
583
![]() |
![]() |
Thu 27 Aug, 2015 09:16:11 +0000 | |
582
![]() |
![]() |
Thu 27 Aug, 2015 09:14:50 +0000 | |
579
![]() |
![]() |
Thu 27 Aug, 2015 08:25:11 +0000 | |
507
![]() |
![]() |
Thu 20 Aug, 2015 07:51:22 +0000 | Merge ramo stable con la nightly. |
265
![]() |
![]() |
Fri 10 Jul, 2015 12:50:57 +0000 | Risolto problema con l’application/json negli altri endpoint. |
258
![]() |
![]() |
Fri 10 Jul, 2015 09:59:44 +0000 | Implementata get_list_locali.php, usando la Harvesine Formula |
226 |
![]() |
Wed 08 Jul, 2015 10:28:38 +0000 | Istruzioni per come effettuare la ricerca usando l’Haversin Formula in MySQL |