Forum PHP.pl

[PHP] pobierz, plaintext 
$start = strtotime("tomorrow 08:00");
$koniec = strtotime("tomorrow 19:00");
 
$result = $mysqli->query("
SELECT MAX(hwindGust) AS wiatrsr, t.hwindBearing,zt.kierunek, hid_miasto, htime, t.hwindGust,zw.sila_wiatru
FROM prognoza_godzinowa AS t, kierunek_wiatru AS zt, sila_wiatru AS zw
WHERE t.hwindBearing>=zt.od AND t.hwindBearing<zt.do AND t.hwindGust>=zw.od AND t.hwindGust<zw.do AND htime BETWEEN '".$start."' AND '".$koniec."' AND hid_miasto =9
");
while ( $row = mysqli_fetch_array($result) ) {
$wiatr = ''.round($row['wiatrsr'],1).'';
}
echo '<p>'.$wiatr.'</p>';
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$result = $mysqli->query("SELECT MAX(hwindGust) AS wiatrsr FROM prognoza_godzinowa WHERE htime BETWEEN '".$start."' AND '".$koniec."' AND hid_miasto=9");
while ( $row = mysqli_fetch_array($result) ) {
		echo '<p>'.round($row['wiatrsr'],1).'</p>';
}
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$result = $mysqli->query("
SELECT t.SUM(hcloudCover),zt.nazwa_ikony, hid_miasto, htime
FROM prognoza_godzinowa AS t, ikona_dzien AS zt
WHERE htime BETWEEN '".$start."' AND '".$koniec."' AND t.SUM(hcloudCover)>=zt.od AND t.SUM(hcloudCover)<zt.do AND hid_miasto =1 
ORDER BY htemperature DESC LIMIT 1
");
while ( $row = mysqli_fetch_array($result) ) {
$tempmax = ''.$row['htemperature'].'';
$imagee = imagecreatefrompng('http://brzanek.webd.pl/2019/strona/prognoza/images/ikony'.$row['nazwa_ikony'].'.png');
}
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT SUM(tx.hcloudcover) AS summed, zty.name_icon, zty.hid_city, zty.htime FROM t AS tx, zt AS zty
WHERE tx.htime BETWEEN '09:00:00' AND '15:00:00' AND zty.hid_city = 1 HAVING summed >= 1 AND summed < 200 ORDER BY 1 DESC LIMIT 1;
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
while($row = $result->fetch_array(MYSQLI_NUM)) {
   print_r($row);
}	
[PHP] pobierz, plaintext 

[PHP] pobierz, plaintext 
$result = $mysqli->query("
SELECT hwindBearing,zt.kierunek, hwindGust,zw.sila_wiatru, hid_miasto, htime, SUM(hcloudCover) AS hcloudCover,di.nazwa_ikony FROM prognoza_godzinowa, kierunek_wiatru AS zt, sila_wiatru AS zw, ikona_dzien AS di WHERE htime BETWEEN '1542830400' AND '1542916800' AND hwindBearing>=zt.od AND hwindBearing<zt.do AND hwindGust>=zw.od AND hwindGust<zw.do AND hcloudCover>=di.zachmurzenie_od AND hcloudCover<di.zachmurzenie_do AND hid_miasto =1 ORDER BY hwindGust DESC LIMIT 1
");
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT hwindBearing,zt.kierunek, hwindGust,zw.sila_wiatru, hid_miasto, htime, SUM(hcloudCover) AS hcloudCover,di.nazwa_ikony FROM prognoza_godzinowa, kierunek_wiatru AS zt, sila_wiatru AS zw, ikona_dzien AS di WHERE htime BETWEEN '1542830400' AND '1542916800' AND hwindBearing>=zt.od AND hwindBearing<zt.do AND hwindGust>=zw.od AND hwindGust<zw.do AND hcloudCover>=di.zachmurzenie_od AND hcloudCover<di.zachmurzenie_do AND hid_miasto =1 ORDER BY hwindGust DESC LIMIT 1
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
$result = $mysqli->query("
SELECT SUM(hcloudCover) AS zachmurzeniesuma, htime FROM prognoza_godzinowa WHERE htime BETWEEN '1542830400' AND '1542916800' AND hid_miasto =1 ORDER BY hcloudCover DESC LIMIT 1
");
while ( $row = mysqli_fetch_array($result) ) {
$zachmurzenie = ''.$row['zachmurzeniesuma'].'';
}
echo ''.$zachmurzenie.'';
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SHOW CREATE TABLE brzanek\G
*************************** 1. row ***************************
       TABLE: brzanek
CREATE TABLE: CREATE TABLE `brzanek` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `htime` time DEFAULT NULL,
  `hwindBearing` int(11) DEFAULT NULL,
  `from` int(11) DEFAULT NULL,
  `to` int(11) DEFAULT NULL,
  `hwindgust` int(11) DEFAULT NULL,
  `from1` int(11) DEFAULT NULL,
  `to1` int(11) DEFAULT NULL,
  `hcloudcover` int(11) DEFAULT NULL,
  `clouds_from` int(11) DEFAULT NULL,
  `clouds_to` int(11) DEFAULT NULL,
  `hid_city` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT * FROM brzanek;
[SQL] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT *, sum(hcloudcover) AS hcloudcover FROM (SELECT hwindBearing, hwindgust, hid_city, htime, id, clouds_from, clouds_to FROM brzanek WHERE htime BETWEEN '10:00:00' AND '23:00:00' AND hwindbearing>=`from` AND hwindbearing<`to` AND hwindgust>=from1 AND hwindgust<to1 AND hid_city = 59) AS vv, brzanek AS brzan WHERE hcloudcover>=vv.clouds_from AND hcloudcover<vv.clouds_to\G
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
$start = strtotime("tomorrow 08:00");
$koniec = strtotime("tomorrow 22:00");
 
$result = $mysqli->query("
SELECT SUM(hcloudCover) AS zachmurzeniesuma, htime FROM prognoza_godzinowa WHERE htime BETWEEN '".$start."' AND '".$koniec."' AND hid_miasto =1 ORDER BY hcloudCover DESC LIMIT 1
");
while ( $row = mysqli_fetch_array($result) ) {
$zachmurzenie = ''.$row['zachmurzeniesuma'].'';
}
 
$result = $mysqli->query("
SELECT nazwa_ikony, zachmurzenie_od, zachmurzenie_do, opady_od, opady_do
FROM ikona_dzien
WHERE '".$zachmurzenie."'>=zachmurzenie_od AND '".$zachmurzenie."'<zachmurzenie_do ORDER BY nazwa_ikony
");
while ( $row = mysqli_fetch_array($result) ) {
$nazwaikony = ''.$row['nazwa_ikony'].'';
}
echo '<p>'.$zachmurzenie.'</p>';
echo '<p>'.$nazwaikony.'</p>';
[PHP] pobierz, plaintext 

[SQL] pobierz, plaintext 
SELECT *, SUM(hcloudcover) AS hcloudcover FROM (<<tutaj wstaw, TO co BYło w mojej ostatniej odpowiedzi>>) AS vv, brzanek WHERE brzanek.hcloudcover>=vv.clouds_from AND brzanek.hcloudcover<vv.clouds_to\G
[SQL] pobierz, plaintext 

[PHP] pobierz, plaintext 
$start = strtotime("tomorrow 08:00");
$koniec = strtotime("tomorrow 22:00");
 
$result = $mysqli->query("
SELECT SUM(hcloudCover) AS zachmurzeniesuma, htime FROM prognoza_godzinowa WHERE htime BETWEEN '".$start."' AND '".$koniec."' AND hid_miasto =1 ORDER BY hcloudCover DESC LIMIT 1
");
while ( $row = mysqli_fetch_array($result) ) {
$zachmurzenie = ''.$row['zachmurzeniesuma'].'';
}
 
$result = $mysqli->query("
SELECT SUM(hprecipIntensity) AS sumaopadow, htime FROM prognoza_godzinowa WHERE htime BETWEEN '".$start."' AND '".$koniec."' AND hid_miasto =1 ORDER BY hprecipIntensity DESC LIMIT 1
");
while ( $row = mysqli_fetch_array($result) ) {
$opady = ''.$row['sumaopadow'].'';
}
 
$result = $mysqli->query("
SELECT *
FROM ikona_dzien
WHERE ".$zachmurzenie." BETWEEN zachmurzenie_od AND zachmurzenie_do AND ".$opady." BETWEEN opady_od AND opady_do
");
while ( $row = mysqli_fetch_array($result) ) {
$nazwaikony = ''.$row['nazwa_ikony'].'';
}
echo '<p>'.$zachmurzenie.'</p>';
echo '<p>'.$opady.'</p>';
echo '<p>'.$nazwaikony.'</p>';
[PHP] pobierz, plaintext