Prubeh testu
- Pripojeni k databazi OK
- Tabulka "cities" pripravena
- Tabulka "weather_logs" pripravena
- Tabulka "visitors" pripravena
- Mesta jiz existuji (5 zaznamu)
- Zapsano 5 novych mereni pocasi
- Zaznamenan navstevnik
- Celkem mereni: 25, celkem navstev: 5
Tabulka: cities
| ID | Mesto | Region | Populace | Vytvoreno |
|---|---|---|---|---|
| 2 | Brno | Jihomoravsky | 382 000 | 2026-03-11 22:04:59 |
| 5 | Olomouc | Olomoucky | 101 000 | 2026-03-11 22:04:59 |
| 3 | Ostrava | Moravskoslezsky | 285 000 | 2026-03-11 22:04:59 |
| 4 | Plzen | Plzensky | 175 000 | 2026-03-11 22:04:59 |
| 1 | Praha | Stredocesky | 1 309 000 | 2026-03-11 22:04:59 |
Tabulka: weather_logs (poslednich 10)
| ID | Mesto | Teplota | Popis | Cas |
|---|---|---|---|---|
| 22 | Brno | 19.0 °C | Dest | 2026-03-12 00:14:14 |
| 23 | Ostrava | 32.7 °C | Bourka | 2026-03-12 00:14:14 |
| 24 | Plzen | 6.9 °C | Snezeni | 2026-03-12 00:14:14 |
| 25 | Olomouc | -3.0 °C | Oblacno | 2026-03-12 00:14:14 |
| 21 | Praha | 29.6 °C | Snezeni | 2026-03-12 00:14:13 |
| 16 | Praha | 30.0 °C | Jasno | 2026-03-11 22:41:53 |
| 17 | Brno | 23.7 °C | Dest | 2026-03-11 22:41:53 |
| 18 | Ostrava | 2.1 °C | Polojasno | 2026-03-11 22:41:53 |
| 19 | Plzen | 4.6 °C | Mlha | 2026-03-11 22:41:53 |
| 20 | Olomouc | 19.2 °C | Jasno | 2026-03-11 22:41:53 |
Tabulka: visitors (poslednich 10)
| ID | IP | Stranka | Cas |
|---|---|---|---|
| 5 | 172.21.0.2 | db-test.php | 2026-03-12 00:14:14 |
| 4 | 172.21.0.2 | db-test.php | 2026-03-11 22:41:53 |
| 3 | 172.21.0.2 | db-test.php | 2026-03-11 22:08:16 |
| 2 | 172.21.0.2 | db-test.php | 2026-03-11 22:08:08 |
| 1 | 172.21.0.2 | db-test.php | 2026-03-11 22:04:59 |