BROTH3RCAST

Lettura dati dal database e invio dati al sito web

May 27th, 2021 (edited)
658
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.55 KB | None | 0 0
  1. <?php
  2. header('Content-Type: application/json');
  3.  
  4.  
  5. $stazione = $_POST["stazione"];
  6. $date = $_POST["date"];
  7. $tipo = $_POST["tipo"];
  8.  
  9. //$stazione = "2c52b90b47a39de6a0474867dffb8a20";
  10.  
  11. //2c52b90b47a39de6a0474867dffb8a20
  12. //3C:61:05:1D:92:4C
  13.  
  14. $conn = mysqli_connect("localhost", "root", "", "sensorhub");
  15. $sqlQuery = "CALL `sp_leggiRilevamentoMaster`('$stazione', '$tipo', '$date')";
  16.  
  17. $result = mysqli_query($conn, $sqlQuery);
  18. $data = array();
  19.  
  20. foreach ($result as $row) {
  21.     $data[] = $row;
  22. }
  23.  
  24. mysqli_close($conn);
  25.  
  26. echo json_encode($data);
Add Comment
Please, Sign In to add comment