Advertisement
Guest User

Untitled

a guest
Feb 19th, 2018
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.82 KB | None | 0 0
  1. <?php
  2.  
  3. mysql_connect('localhost', 'root', 'mdp'); //connection a la base de donnee
  4.  
  5.  
  6. $temp  = $_REQUEST['temp']; //la variable $temp stock ce que recevra le paramettre 'temp' depuis l'url
  7. $hum = $_REQUEST['hum']; //la variable $hum stock ce que recevra le parametre 'hum' depuis l'url
  8.  
  9. //si les 2 parametres 'temp' et 'hum' contienne une valeur, on ajoute cette valeur a la bdd correspondante
  10. if(isset($_REQUEST['temp']) && !empty($_REQUEST['temp']) AND isset($_REQUEST['hum']) && !empty($_REQUEST['hum'])){
  11.     mysql_query("INSERT INTO `final_data`.`sensor_temp` (`temp`) VALUES ('$temp') "); //on stock dans sensor_temp ce que contient $temp
  12.     mysql_query("INSERT INTO `final_data`.`sensor_hum` (`hum`) VALUES ('$hum') "); //on stock dans sensor_hum ce que contient $hum
  13. }
  14.  
  15. mysql_close(); //on ferme la connection a la db
  16. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement