Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //Nawiązanie połączenia
- $serverName = "TOSIA\WERMAWIN";
- $connectionInfo = array( "Database"=>"WERMAWIN", "UID"=>"wermawin", "PWD"=>'Tyz19$lx50WsR3Ed7m');
- $conn = sqlsrv_connect( $serverName, $connectionInfo);
- //Zapytanie do bazy danych
- $sql = "Select top 1 channel3 from slaveData order by channel3 desc";
- $stmt = sqlsrv_query($conn, $sql);
- if( $stmt === false ) {
- die( print_r( sqlsrv_errors(), true));
- }
- if( sqlsrv_fetch( $stmt ) === false) {
- die( print_r( sqlsrv_errors(), true));
- }
- print_r( sqlsrv_fetch( $stmt ));
- sqlsrv_fetch($stmt);
- $result=sqlsrv_get_field($stmt, 0);
- //print_r($result);
- if ($result == 3){
- echo "AWARIA!";
- }
- else{
- echo "W TRAKCIE PRACY";
- }
- ?>
- <!DOCTYPE html>
- <html>
- <head>
- <script type="text/javascript" src="jquery.js">
- setInterval("odswiezanie();",1000);
- function odswiezanie(){
- $("#zakres").load("test.php", "#czas");
- }
- </script>
- </head>
- <body>
- <div id="zakres">
- <div id="czas">
- <?php echo date('H:i:s');?>
- </div>
- </div>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement