Advertisement
digigram

php POST to mySQL

Jun 27th, 2014
235
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.37 KB | None | 0 0
  1. <?php
  2. $con=mysqli_connect("localhost","my_user","my_password","my_db"); //remember to put the server address here
  3. // Check connection
  4. if (mysqli_connect_errno()) {
  5.   echo "Failed to connect to MySQL: " . mysqli_connect_error();
  6. }
  7.  
  8. $result = mysqli_query($con,"SELECT * FROM data");
  9. while($row = mysqli_fetch_array($result)) {
  10.   $IDnr = $row['ID']+1;
  11. }
  12. $IDnr = mysql_real_escape_string($IDnr);
  13. $timestamp = mysql_real_escape_string(date("Y-m-d H:i:s"));
  14. $MeterID = mysql_real_escape_string($_GET["MeterID"]);
  15. $V1 = mysql_real_escape_string($_GET["V1"]);
  16. $A1 = mysql_real_escape_string($_GET["A1"]);
  17. $W1 = mysql_real_escape_string($_GET["W1"]);
  18. $V2 = mysql_real_escape_string($_GET["V2"]);
  19. $A2 = mysql_real_escape_string($_GET["A2"]);
  20. $W2 = mysql_real_escape_string($_GET["W2"]);
  21. $V3 = mysql_real_escape_string($_GET["V3"]);
  22. $A3 = mysql_real_escape_string($_GET["A3"]);
  23. $W3 = mysql_real_escape_string($_GET["W3"]);
  24. $AN = mysql_real_escape_string($_GET["AN"]);
  25.  
  26. mysqli_query($con,"INSERT INTO data (ID, UTC, MeterID, V1, A1, W1, V2, A2, W2, V3, A3, W3, AN)
  27. VALUES ('$IDnr', '$timestamp', '$MeterID', '$V1', '$A1', '$W1', '$V2', '$A2', '$W2', '$V3', '$A3', '$W3', '$AN')");
  28.  
  29. $result = mysqli_query($con,"SELECT * FROM data");
  30. while($row = mysqli_fetch_array($result)) {
  31.   $IDnr = $row['ID'];
  32.   echo $IDnr." ".$row['MeterID']." ".$row['UTC']."<br>";
  33. }
  34.  
  35. mysqli_close($con);
  36. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement