Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db_driver = 'mysql'; //server type
- $db_host = 'localhost'; //database server
- $db_user = 'sensortest'; //username
- $db_pass = 'sensortest'; //password
- $db_name = 'sensortest'; //db name
- $tablename = 'sensortest';
- $sensor = $param1;
- $time = $param2;
- $value = $param3;
- try {
- $dbh = new PDO($db_driver.':host='.$db_host.';dbname='.$db_name, $db_user, $db_pass);
- $dbh->beginTransaction();
- $sql = "INSERT INTO ".$tablename." (sensor, time, value) VALUES (:sensor, :time, :value)";
- $stmt = $dbh->prepare($sql);
- $stmt->bindParam(':sensor', $sensor, PDO::PARAM_STR);
- $stmt->bindParam(':time', $time, PDO::PARAM_STR);
- $stmt->bindParam(':value', $value, PDO::PARAM_STR);
- $result = $stmt->execute();
- $dbh->commit();
- } catch (PDOException $e) {
- echo 'Database error'." \n";
- echo '<p>Message: '.$e->getMessage(). '</p>'." \n";
- if ($dbh)
- echo '<p>Info: '.print_r($dbh->errorInfo(), true).'</p>'."\n";
- }
- echo 'trolololololol'
- ?>
Add Comment
Please, Sign In to add comment