Guest User

Untitled

a guest
Jun 15th, 2012
39
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.19 KB | None | 0 0
  1. $i = 1;
  2.  
  3. $wynik = mysql_query("SELECT * FROM signals WHERE id_robot = $robot")
  4.     or die('Błąd zapytania');        
  5.  
  6.     if(mysql_num_rows($wynik) > 0) {
  7.         while($r = mysql_fetch_array($wynik)) {
  8.  
  9.             $id_signal = $r['id_signal'];
  10.  
  11.             $signal = mysql_query("SELECT * FROM signals INNER JOIN data USING(id_signal) WHERE id_signal = $id_signal ORDER BY data.time ASC LIMIT 1 ");
  12.             if(mysql_num_rows($signal) > 0) {
  13.                 while($sig = mysql_fetch_array($signal)) {
  14.                     //echo 'Time: '.$sig['time'].' Value: '.$sig['value'].' ';
  15.  
  16.                     $data[$i]['time'] = $sig['time'];
  17.                     $data[$i]['value'] = $sig['value'];
  18.  
  19.  
  20.  
  21.                     $id_sensor= $sig['id_sensor'];
  22.  
  23.                     $sensor = mysql_query("SELECT * FROM signals INNER JOIN sensors USING(id_sensor) WHERE id_sensor = $id_sensor");
  24.  
  25.                     if(mysql_num_rows($sensor) > 0) {
  26.                         while($sen = mysql_fetch_array($sensor)) {
  27.                             //echo 'Sensor: '.$sen['description'].' ';
  28.  
  29.                             $data[$i]['sensor'] = $sen['description'];
  30.  
  31.                         }
  32.                         //echo 'Signal: '.$r['id_sensor'].' <br/>';
  33.                     $data[$i]['signal'] = $r['id_sensor'];
  34.  
  35.  
  36.                     }
  37.  
  38.                 }      
  39.  
  40.                 $i++;
  41.             }
  42.            
  43.         }
  44.  
  45.     }else {
  46.         echo 'Nie ma danych';
  47.     }  
  48.  
  49.     print_r($data);
  50.  
  51.     echo json_encode($data);
Advertisement
Add Comment
Please, Sign In to add comment