Guest User

Untitled

a guest
Jul 31st, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.00 KB | None | 0 0
  1. <?php
  2. $db_driver = 'mysql'; //server type
  3. $db_host = 'localhost'; //database server
  4. $db_user = 'sensortest'; //username
  5. $db_pass = 'sensortest'; //password
  6. $db_name = 'sensortest'; //db name
  7.  
  8. $tablename = 'sensortest';
  9. $sensor = $param1;
  10. $time = $param2;
  11. $value = $param3;
  12.  
  13. try {
  14. $dbh = new PDO($db_driver.':host='.$db_host.';dbname='.$db_name, $db_user, $db_pass);
  15.  
  16. $dbh->beginTransaction();
  17.  
  18.  
  19. $sql = "INSERT INTO ".$tablename." (sensor, time, value) VALUES (:sensor, :time, :value)";
  20.  
  21. $stmt = $dbh->prepare($sql);
  22.  
  23. $stmt->bindParam(':sensor', $sensor, PDO::PARAM_STR);
  24. $stmt->bindParam(':time', $time, PDO::PARAM_STR);
  25. $stmt->bindParam(':value', $value, PDO::PARAM_STR);
  26.  
  27. $result = $stmt->execute();
  28. $dbh->commit();
  29.  
  30. } catch (PDOException $e) {
  31. echo 'Database error'." \n";
  32. echo '<p>Message: '.$e->getMessage(). '</p>'." \n";
  33. if ($dbh)
  34. echo '<p>Info: '.print_r($dbh->errorInfo(), true).'</p>'."\n";
  35. }
  36. echo 'trolololololol'
  37. ?>
Add Comment
Please, Sign In to add comment