13 lines
626 B
PHP
13 lines
626 B
PHP
<?php
|
|
$cfg = require __DIR__ . '/../config/database.php';
|
|
$pdo = new PDO(
|
|
sprintf('mysql:host=%s;dbname=%s;charset=%s', $cfg['host'], $cfg['dbname'], $cfg['charset']),
|
|
$cfg['user'],
|
|
$cfg['pass'],
|
|
[PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC]
|
|
);
|
|
$stmt = $pdo->query("SELECT designation, shower_code, radiant_alpha_deg, radiant_delta_deg, peak_sol, zhr, zhr_variable FROM meteorshowers WHERE shower_code='PER' OR designation LIKE '%Perseid%'");
|
|
foreach ($stmt as $row) {
|
|
echo json_encode($row, JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES), PHP_EOL;
|
|
}
|