✏ 编辑: get_horoscopes.php

<?php
header("Cache-Control: no-cache, no-store, must-revalidate");
header("Pragma: no-cache");
header("Expires: 0");
header('Access-Control-Allow-Origin: *');
ini_set('display_errors', 1);
error_reporting(E_ALL);

// Load DB config using absolute path
require __DIR__ . '/db_config.php';

// Connect to database
$conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
if ($conn->connect_error) {
    die(json_encode(['error' => "DB Connection Failed → " . $conn->connect_error]));
}
$conn->set_charset("utf8mb4");

// Prepare response array
$response = [
    'daily' => [],
    'weekly' => [],
    'monthly' => [],
    'yearly' => []
];

// Fetch horoscopes by type
$types = ['daily', 'weekly', 'monthly', 'yearly'];

foreach ($types as $type) {
    $sql = "SELECT * FROM horoscopes WHERE type='$type' AND is_active=1 ORDER BY zodiac_id ASC, start_date DESC";
    $result = $conn->query($sql);

if($result && $result->num_rows > 0){
        while($row = $result->fetch_assoc()){
            $zodiacId = $row['zodiac_id'];
            if(!isset($response[$type][$zodiacId])){
                $response[$type][$zodiacId] = [];
            }
            $response[$type][$zodiacId][] = [
                'id' => $row['id'],
                'description' => $row['description'],
                'lucky_color' => $row['lucky_color'],
                'lucky_number' => $row['lucky_number'],
                'start_date' => $row['start_date'],
                'end_date' => $row['end_date'],
                'week_start' => $row['week_start'],
                'month_year' => $row['month_year'],
                'year' => $row['year']
            ];
        }
    }
}

$conn->close();

// Send JSON response
echo json_encode($response, JSON_UNESCAPED_UNICODE | JSON_PRETTY_PRINT);
exit;
?>

[X] 取消