Mam kod
<?php
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<meta name="Gopal Joshi" content="Highchart with Mysql" />
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Highchart with Mysql Database</title>
<link href="../css/bootstrap.css" rel="stylesheet">
<script type="text/javascript" src="js/jquery.min.js"></script>
<script type="text/javascript" src="js/setup4.js"></script>
<script type="text/javascript" src="js/test.js"></script>
<style>
.niebieski {
background-color: #2980B9;
color: #fff;
padding: 2px 20px 2px 20px;
}
</style>
</head>
<body>
<script src="js/highcharts.js"></script>
<script src="http://code.highcharts.com/modules/exporting.js"></script>
<script type="text/javascript" src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script>
<?php
include('db.php');
?>
<div class="row">
<?php
echo '<div class="niebieski">'; echo '<h3 class="color-white">Rekordy temperatury maksymalnej i mienimalnej w 2017 roku.</h3>'; echo '<p>Rekordy temperatury maksymalnej i minimalnej mierzonej na wysokości 2m w ciągu całego roku. Temperatury mierzone są w kilkunastu miastach na terenie woj. Zachodniopomorskiego. Na stronie prezentowane są tylko 5 najwyższych i najniższych wartości.</p>';
echo '<div class="col-xs-6">'; $result = $mysqli->query("SELECT CONCAT('Białogard'), MAX(tempmax) AS max FROM bialogard WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Dębno'), MAX(tempmax) AS max FROM chojna WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Darłówek'), MAX(tempmax) AS max FROM darlowek WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Gryfice'), MAX(tempmax) AS max FROM gryfice WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Gryfino'), MAX(tempmax) AS max FROM gryfino WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Kamień Pomorski'), MAX(tempmax) AS max FROM kamien WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Kołobrzeg'), MAX(tempmax) AS max FROM kolobrzeg WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Koszalin'), MAX(tempmax) AS max FROM koszalin WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Lipiany'), MAX(tempmax) AS max FROM lipiany WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Łobez'), MAX(tempmax) AS max FROM lobez WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Mirosławiec'), MAX(tempmax) AS max FROM miroslawiec WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Nowogard'), MAX(tempmax) AS max FROM nowogard WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Resko'), MAX(tempmax) AS max FROM resko WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Sławno'), MAX(tempmax) AS max FROM slawno WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Stargard'), MAX(tempmax) AS max FROM stargard WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Świdwin'), MAX(tempmax) AS max FROM swidwin WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Świnoujście'), MAX(tempmax) AS max FROM swinoujscie WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Szczecin'), MAX(tempmax) AS max FROM szczecin WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Szczecinek'), MAX(tempmax) AS max FROM szczecinek WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Wałcz'), MAX(tempmax) AS max FROM walcz WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Choszczno'), MAX(tempmax) AS max FROM choszczno WHERE data LIKE '%2017-%'
UNION
SELECT CONCAT('Drawsko'), MAX(tempmax) AS max FROM drawsko WHERE data LIKE '%2017-%'
ORDER BY max DESC LIMIT 22");
//$result = mysql_query($query) or die(mysql_error());
$miejsce = 1;
echo '<h4>Najwyższe temperatury</h4>'; echo '<p>Temperatura mierzona jest na wysokości 2m w cieniu. Wynik to najwyższa temperatura w ciągu roku.</p>'; echo '<table class="table table-hover"> <thead>
<tr>
<th>#</th>
<th>Temperatura</th>
<th>Miejscowość</th>
<th>Data</th>
</tr>
</thead>
<tbody>';
while ( $row = mysqli_fetch_array($result) ) {
echo "<th scope='row'>".$miejsce++."</th>"; echo "<td><span class='label label-danger'>".$row['max']."°C</span></td>"; echo "<td>".$row['0']."</td>"; echo "<td>".$row['data']."</td>"; }
</table>';
?>
</div>
</body>
</html>
<?php
?>
Wszystko ładnie się wyświetla ale jest problem w linii gdzie pobierana jest data z bazy danych mysql
echo "<td>".$row['data']."</td>";
Nie pobiera jej i pojawia się błąd
Notice: Undefined index: data in /home/brzanek/public_html/02052018/podsumowania/2017/temperatury/rekordy.php on line 102
Baza danych
Strona z błędem
http://pogoda-zachodniopomorskie.pl/podsum...ury/rekordy.php
[MySQL][PHP] Problem z pobraniem daty
24.05.2018, 07:50:45
