PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, ] ); $stmt = $pdo->query("SELECT * FROM planety ORDER BY id"); $result = $stmt->fetchAll(); $table_body = ""; foreach($result as $row) { $table_body .= ""; $table_body .= "" . $row['nazev'] . ""; $table_body .= "" . $row['vzdalenost'] . ""; $table_body .= "" . $row['polomer'] . ""; $table_body .= ""; } return $table_body; } catch(PDOException $e) { return "Error: " . $e->getMessage(); } } function vypis_karticek() { $server = "websql.in.spsostrov.cz"; $data = parse_ini_file("../../spso.mysql.ini"); $username = $data["username"]; $password = $data["password"]; $database = $data["database"]; try { $pdo = new PDO("mysql:host=$server;dbname=$database;charset=utf8mb4", $username, $password, [ PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, ] ); $stmt = $pdo->query("SELECT * FROM planety ORDER BY id"); $result = $stmt->fetchAll(); $cards = "
"; foreach($result as $row) { $cards .= "
"; $cards .= "
"; $cards .= ""; $cards .= "planeta"; $cards .= ""; $cards .= "
"; $cards .= "
" . $row['nazev'] . "
"; $cards .= "

" . $row['kratky_popis'] . "

"; $cards .= "Wikipedie"; $cards .= "
"; $cards .= "
"; $cards .= "
"; } $cards .= "
"; return $cards; } catch(PDOException $e) { return "Error: " . $e->getMessage(); } } ?> Planety
Přihlášen: Odhlásit Přihlášení

Tabulka

Název Vzdálenost od slunce (km) Poloměr (km)

Kartičky