Advertisement
Guest User

Untitled

a guest
Jan 23rd, 2015
231
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.49 KB | None | 0 0
  1. <?php
  2.    
  3.   $db_host = 'localhost';
  4.   $db_name = 'rgraph_example';
  5.   $db_username = 'jora';
  6.   $db_password = 'dfcmrfrjn2012';
  7.    
  8.   $connect_to_db = mysql_connect($db_host, $db_username, $db_password);
  9.  
  10.   if (!$connect_to_db) {
  11.     die("Could not connect: " . mysql_error());
  12.   }
  13.  
  14.   if (!mysql_select_db($db_name, $connect_to_db)) {
  15.     die("Could not select DB: " . mysql_error());
  16.   }
  17.  
  18.   $sql = "SELECT `daily_statistics`.`Values`,`Temp`.`Value`,`Humidity`.`Humidity` FROM daily_statistics "
  19.     . "LEFT JOIN `rgraph_example`.`Humidity` ON `daily_statistics`.`Id` = `Humidity`.`Id` "
  20.     . "LEFT JOIN `rgraph_example`.`Temp` ON `daily_statistics`.`Id` = `Temp`.`Id` LIMIT 1 ";
  21.  
  22.  $result = mysql_query($sql);
  23.   if (!$result) {
  24.     die(mysql_error());
  25.   }
  26.  
  27.   echo '<table border="1">';
  28.   echo '<thead>';
  29.   echo '<tr>';
  30.   echo '<th>Values</th>';
  31.   echo '<th>Value</th>';
  32.   echo '<th>Humidity</th>';
  33.   echo '</tr>';
  34.   echo '</thead>';
  35.   echo '<tbody>';
  36.  
  37.    // выводим в HTML-таблицу все данные клиентов из таблицы MySQL
  38.   while($data = mysql_fetch_array($result)){
  39.     echo '<tr>';
  40.     echo '<td>' . $data['Values'] . '</td>';
  41.     echo '<td>' . $data['Value'] . '</td>';
  42.     echo '<td>' . $data['Humidity'] . '</td>';
  43.     echo '</tr>';
  44.   }
  45.  
  46.     echo '</tbody>';
  47.   echo '</table>';
  48.  
  49.     // закрываем соединение с сервером  базы данных
  50.     mysql_close($connect_to_db);
  51. ?><code lang="php">
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement