-
Notifications
You must be signed in to change notification settings - Fork 0
/
getFlyToCoords.php
41 lines (28 loc) · 1.13 KB
/
getFlyToCoords.php
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
<?php
require_once "login.php";
ini_set("session.cookie_httponly", True); // The following line sets the HttpOnly flag for session cookies - make sure to call it before you call session_start()
session_start();
header("Content-Type: application/json");
//$body = http_get_request_body('php://input'); //another method to get header body contents
$body = file_get_contents('php://input');
$body = htmlentities($body);
error_log($body);
$dbConn = logIntoPostgreSQL();
$LongLatArray = getLongLatPoint($dbConn, $body);
echo json_encode($LongLatArray);
function getLongLatPoint($dbConn, $body){
$LongLatArray = array();
// $result = pg_query($dbConn, "select * from query_site_sitename_id_center_point('$body');");
$result = pg_query_params($dbConn, "select * from query_site_sitename_id_center_point($1)",
array($body));
error_log('Query result:');
error_log(print_r($result, true));
while ($row = pg_fetch_row($result)) {
array_push($LongLatArray, $row[0]);
array_push($LongLatArray, $row[1]);
array_push($LongLatArray, $row[2]);
}
pg_close($dbConn);
return $LongLatArray;
}
?>