Advertisement
Guest User

Untitled

a guest
Oct 5th, 2017
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.02 KB | None | 0 0
  1. <?php
  2. $dbusername = "name";
  3. $dbpassword = "password";
  4. $server = "ipserver";
  5. $dbconnect = mysql_connect($server, $dbusername, $dbpassword);
  6. $dbselect = mysql_select_db("test",$dbconnect);
  7. $sql = "INSERT INTO sensor1(value1,value2,value3,value4,value5,value6,value7) VALUES ('".$_GET["value1"]."','".$_GET["value2"]."','".$_GET["value3"]."','".$_GET["value4"]."','".$_GET["value5"]."','".$_GET["value6"]."','".$_GET["value7"]."')";
  8. mysql_query($sql);
  9. ?>
  10.  
  11. ALTER TABLE `sensor` ADD COLUMN `date` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
  12.  
  13. ALTER TABLE `sensor` ADD INDEX (`date`);
  14.  
  15. SELECT `value2`,`value4` FROM `sensor` WHERE DATE_FORMAT(`date`,'%Y-%m-%d) = ?;
  16.  
  17. $today = date('j');
  18. $sql = "INSERT INTO sensor$today(value1,value2,value3,value4,value5,value6,value7)
  19. VALUES ('".$_GET["value1"]."','".$_GET["value2"]."','".$_GET["value3"]."','".$_GET["value4"]."','".$_GET["value5"]."','".$_GET["value6"]."','".$_GET["value7"]."')";
  20.  
  21. $dbconnect = new PDO("mysql:host=$server;dbname=test;charset=cp1251", $dbusername, $dbpassword);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement