<?= e($title) ?> - <?= e($frontHeaderTitle) ?>

prepare("SELECT * FROM fishing_spots WHERE id=? LIMIT 1"); $stmt->execute([$id]); $spot = $stmt->fetch(PDO::FETCH_ASSOC); if (!$spot) { header('HTTP/1.1 404 Not Found'); echo 'Not Found'; exit; } $title = trim((string)$spot['title']); if ($title === '') $title = '钓点 #' . $id; $province = trim((string)$spot['province']); $city = trim((string)$spot['city']); $region = trim($province . ($city ? (' ' . $city) : '')); $lat = (string)$spot['lat']; $lon = (string)$spot['lon']; $up = (int)($spot['up_count'] ?? 0); $down = (int)($spot['down_count'] ?? 0); $updated = (string)($spot['updated_at'] ?? ''); // base url $scheme = (!empty($_SERVER['HTTPS']) && $_SERVER['HTTPS'] !== 'off') ? 'https' : 'http'; $host = (string)($_SERVER['HTTP_HOST'] ?? ''); $base = $scheme . '://' . $host; $canonical = $base . '/spot.php?id=' . $id; $desc = $region ? ($region . '钓点分享，') : ''; $desc .= '坐标：' . $lat . ',' . $lon . '。查看附近钓点、狂口龟点、地图导航与参考信息。'; // nearby (10km) - fast rough filter first by bounding box then Haversine function haversine_km(float $lat1, float $lon1, float $lat2, float $lon2): float { $R = 6371.0; $dLat = deg2rad($lat2-$lat1); $dLon = deg2rad($lon2-$lon1); $a = sin($dLat/2)*sin($dLat/2) + cos(deg2rad($lat1))*cos(deg2rad($lat2))*sin($dLon/2)*sin($dLon/2); $c = 2*atan2(sqrt($a), sqrt(1-$a)); return $R*$c; } $near = []; try { $latf = (float)$spot['lat']; $lonf = (float)$spot['lon']; $radius = 10.0; $latDelta = $radius / 111.0; $lonDelta = $radius / (111.0 * max(0.2, cos(deg2rad($latf)))); $minLat = $latf - $latDelta; $maxLat = $latf + $latDelta; $minLon = $lonf - $lonDelta; $maxLon = $lonf + $lonDelta; $stmt = $db->prepare("SELECT id,title,lat,lon,up_count,down_count,updated_at FROM fishing_spots WHERE id<>? AND lat BETWEEN ? AND ? AND lon BETWEEN ? AND ? ORDER BY updated_at DESC LIMIT 50"); $stmt->execute([$id, $minLat, $maxLat, $minLon, $maxLon]); while ($r = $stmt->fetch(PDO::FETCH_ASSOC)) { $d = haversine_km($latf, $lonf, (float)$r['lat'], (float)$r['lon']); if ($d <= $radius) { $r['dist_km'] = $d; $near[] = $r; } } usort($near, fn($a,$b)=>($a['dist_km'] <=> $b['dist_km'])); $near = array_slice($near, 0, 15); } catch (Throwable $e) { // ignore } $frontHeaderTitle = setting_get('front_header_title', '钓鱼天气/潮汐'); ?> <?= e($title) ?> - <?= e($frontHeaderTitle) ?>

· 坐标：, · 更新：

备注

👍 👎 打开百度地图

提示：本页是搜索引擎可收录的钓点详情页；实时天气/潮汐请回到首页地图工具查看。

附近 10 公里内钓点（最多 15 条）

暂无更多附近钓点。

距离约 km · 👍 / 👎

查看钓点列表