Nextrek

URLs

Explore

Commits

Diff Revisions 603 vs 604 for /Android/SmartCharging/endPoints/get_list_locali.php

		@@ -4,43 +4,51 @@
4	4
5	5		require_once("constants.php");
6	6
7		-	require_once("repositories/LocalRepository.php");
	7	+	require_once("repositories/LocalRepository.php");
8	8
9		-	/*$servername = "localhost";
10		-	$username = "smartcharging";
11		-	$password = "LXRLBaEAuRr7M7jY";*/
	9	+	/*$servername = "localhost";
	10	+	$username = "smartcharging";
	11	+	$password = "LXRLBaEAuRr7M7jY";*/
12	12
13		-	//$params = json_decode($_REQUEST["params"], true);
	13	+	//$params = json_decode($_REQUEST["params"], true);
14	14
15	15		//$input = file_get_contents('php://input');
16	16		$params = json_decode(file_get_contents('php://input'), true);
17	17
18		-	$conn;
19		-	$risposta = array();
20		-	$local_repo;
	18	+	$conn;
	19	+	$risposta = array();
	20	+	$local_repo;
21	21		$local_list;
22	22
23		-	try {
24		-	$conn = new PDO("mysql:host=".DB_SERVERNAME.";dbname=".DB_NAME, DB_USERNAME, DB_PASSWORD);
25		-	$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
26		-	//echo "Connesso con successo al DB";
	23	+	try {
	24	+	$conn = new PDO("mysql:host=".DB_SERVERNAME.";dbname=".DB_NAME, DB_USERNAME, DB_PASSWORD);
	25	+	$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
	26	+	//echo "Connesso con successo al DB";
27	27
28		-	if (!array_key_exists("lat", $params) \|\| !array_key_exists("lon", $params)) {
	28	+	/*if (!array_key_exists("lat", $params) \|\| !array_key_exists("lon", $params)) {
29	29		$risposta["locals"] = array();
30	30		} else {
31	31		$local_repo = new LocalRepository($conn);
32	32		$local_list = $local_repo->getCloseLocals($params["tipologia"], $params["lat"], $params["lon"], $params["distance"]);
33	33		$risposta["locals"] = $local_list;
34		-	}
	34	+	}*/
	35	+
	36	+	$params["lat"] = (array_key_exists("lat", $params)) ? $params["lat"] : "";
	37	+	$params["lon"] = (array_key_exists("lon", $params)) ? $params["lon"] : "";
	38	+
	39	+	$local_repo = new LocalRepository($conn);
	40	+	$local_list = $local_repo->getCloseLocals($params["tipologia"], $params["lat"], $params["lon"], $params["distance"]);
	41	+	$risposta["locals"] = $local_list;
	42	+
35	43		}
36		-	catch(PDOException $e)
	44	+	catch(PDOException $e)
37	45		{
38		-	echo $e->getMessage();
	46	+	echo $e->getMessage();
39	47		$risposta = createErrorMessage(1, "Errore DB");
40		-	//$risposta["locals"] = null;
	48	+	//$risposta["locals"] = null;
41	49		}
42	50
43	51		echo json_encode($risposta);
44		-	$conn = null; //Close the connection to the DBMS
	52	+	$conn = null; //Close the connection to the DBMS
45	53
46	54		?>

View View this file contents

History View the full history

Feeds

Commits for /Android/SmartCharging/endPoints/get_list_locali.php