

Nextrek
@ 517
Nextrek / Android / SmartCharging / endPoints / nightly / get_commenti.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 41 42 43 44 45 46 |
<?php header("Access-Control-Allow-Origin: *"); header('Content-Type: application/json; charset=UTF-8'); require_once("constants.php"); require_once("repositories/CommentRepository.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(); $comment_repo; $comments; 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"; $comment_repo = new CommentRepository($conn); $comments = $comment_repo->getComments($params["id"], $params["startIndex"], $params["length"]); $risposta["id"] = $params["id"]; $risposta["comments"] = $comments; } catch(PDOException $e) { echo $e->getMessage(); $risposta["id"] = -1; $risposta["comments"] = null; } echo json_encode($risposta); $conn = null; //Close the connection to the DBMS ?> |