Advertisement
Guest User

Untitled

a guest
Dec 14th, 2016
141
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1. $server = "dbxxxxxxxx.db.1and1.com";
  2. $dbname = "dbxxxxx";
  3. $dbusername = "dboxxxxxx";
  4. $dbpassword = "xxxxxxxx";
  5.  
  6. header('Content-Type: application/json');
  7. try {
  8. $pdo = new PDO("mysql:host={$server};dbname=test;charset=utf8", $dbusername, $dbpassword);
  9. } catch (PDOException $e) {
  10. error_log($e->getMessage());
  11. die(json_encode(["query" => 1])); // fails
  12. }
  13. if (isset($_GET['wewn'], $_GET['piec'], $_GET['zew'], $_GET['humid'], $_GET['jasno'])) {
  14. $stmt = $pdo->prepare("INSERT INTO sensor (value,value2,value3,value4,value5) VALUES (:wewn,:piec,:zew,:humid,:jasno);");
  15. $stmt->execute([
  16. ':wewn' => $_GET['wewn'],
  17. ':piec' => $_GET['piec'],
  18. ':zew' => $_GET['zew'],
  19. ':humid' => $_GET['humid'],
  20. ':jasno' => $_GET['jasno']
  21. ]);
  22. echo json_encode(["query" => 0]); // ok
  23. }
  24.  
  25. print_r($_GET);
  26.  
  27. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement