Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- $db_host = 'localhost';
- $db_name = 'rgraph_example';
- $db_username = 'jora';
- $db_password = 'dfcmrfrjn2012';
- $connect_to_db = mysql_connect($db_host, $db_username, $db_password);
- if (!$connect_to_db) {
- die("Could not connect: " . mysql_error());
- }
- if (!mysql_select_db($db_name, $connect_to_db)) {
- die("Could not select DB: " . mysql_error());
- }
- $sql = "SELECT `daily_statistics`.`Values`,`Temp`.`Value`,`Humidity`.`Humidity` FROM daily_statistics "
- . "LEFT JOIN `rgraph_example`.`Humidity` ON `daily_statistics`.`Id` = `Humidity`.`Id` "
- . "LEFT JOIN `rgraph_example`.`Temp` ON `daily_statistics`.`Id` = `Temp`.`Id` LIMIT 1 ";
- $result = mysql_query($sql);
- if (!$result) {
- die(mysql_error());
- }
- echo '<table border="1">';
- echo '<thead>';
- echo '<tr>';
- echo '<th>Values</th>';
- echo '<th>Value</th>';
- echo '<th>Humidity</th>';
- echo '</tr>';
- echo '</thead>';
- echo '<tbody>';
- // выводим в HTML-таблицу все данные клиентов из таблицы MySQL
- while($data = mysql_fetch_array($result)){
- echo '<tr>';
- echo '<td>' . $data['Values'] . '</td>';
- echo '<td>' . $data['Value'] . '</td>';
- echo '<td>' . $data['Humidity'] . '</td>';
- echo '</tr>';
- }
- echo '</tbody>';
- echo '</table>';
- // закрываем соединение с сервером базы данных
- mysql_close($connect_to_db);
- ?><code lang="php">
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement