Advertisement
Guest User

Untitled

a guest
Mar 8th, 2017
102
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.29 KB | None | 0 0
  1. var t= "";
  2. setInterval(checkDb, 1000);
  3. function checkDb(){
  4. <?php
  5. session_start();
  6. $servername = "localhost";
  7. $username = "user";
  8. $password = "password";
  9. $dbname = "RFID";
  10. // Create connection
  11. $conn = new mysqli($servername, $username, $password, $dbname);
  12. // Check connection
  13. if ($conn->connect_error) {
  14. die("Connection failed: " . $conn->connect_error);
  15. }
  16. $sql = 'SELECT `id`, `rfid`, `dateandtime` FROM`scans`';
  17. $result = $conn->query($sql);
  18.  
  19. if ($result->num_rows > 0) {
  20.  
  21. // output data of each row
  22. while($row = $result->fetch_assoc()) {
  23. $answer= "id: " . $row["id"]. " - RFID: " . $row["rfid"]. " - Date:" . $row["dateandtime"]. "<br>";
  24. ?>
  25.  
  26. t= <?php echo json_encode($answer);?> + t ;
  27. document.getElementById("myP").innerHTML = t;
  28. <?php
  29. }
  30. } else {
  31. echo "<br>" ."n0 resultsn";
  32. }
  33. $conn->close();
  34. session_destroy();?>
  35. t="";
  36. };
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement