Advertisement
Guest User

Untitled

a guest
Oct 31st, 2014
150
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
HTML 1.05 KB | None | 0 0
  1. <?php
  2. //Nawiązanie połączenia
  3. $serverName = "TOSIA\WERMAWIN";
  4. $connectionInfo = array( "Database"=>"WERMAWIN", "UID"=>"wermawin", "PWD"=>'Tyz19$lx50WsR3Ed7m');
  5. $conn = sqlsrv_connect( $serverName, $connectionInfo);
  6.  
  7. //Zapytanie do bazy danych
  8. $sql = "Select top 1 channel3 from slaveData order by channel3 desc";
  9. $stmt = sqlsrv_query($conn, $sql);
  10.  
  11.  
  12. if( $stmt === false ) {
  13.      die( print_r( sqlsrv_errors(), true));
  14. }
  15.  
  16. if( sqlsrv_fetch( $stmt ) === false) {
  17.      die( print_r( sqlsrv_errors(), true));
  18.     }
  19. print_r( sqlsrv_fetch( $stmt ));
  20.  
  21. sqlsrv_fetch($stmt);
  22. $result=sqlsrv_get_field($stmt, 0);
  23. //print_r($result);
  24.  
  25. if ($result == 3){
  26. echo "AWARIA!";
  27. }
  28. else{
  29. echo "W TRAKCIE PRACY";
  30. }
  31. ?>
  32.  
  33. <!DOCTYPE html>
  34. <html>
  35. <head>
  36.   <script type="text/javascript" src="jquery.js">
  37.     setInterval("odswiezanie();",1000);
  38.     function odswiezanie(){
  39.       $("#zakres").load("test.php", "#czas");
  40.     }
  41.   </script>
  42. </head>
  43. <body>
  44. <div id="zakres">
  45.   <div id="czas">
  46.     <?php echo date('H:i:s');?>
  47.   </div>
  48. </div>
  49. </body>
  50. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement