✏ 编辑: get_public_numerology.php

<?php
date_default_timezone_set("Asia/Kolkata");

error_reporting(0);
ini_set('display_errors', 0);

// AGGRESSIVE CACHE PREVENTION
header('Content-Type: application/json');
header('Access-Control-Allow-Origin: *');
header("Cache-Control: no-store, no-cache, must-revalidate, max-age=0");
header("Cache-Control: post-check=0, pre-check=0", false);
header("Pragma: no-cache");
header("Expires: Mon, 26 Jul 1997 05:00:00 GMT");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");

// Accept both 'number_id' and 'number' parameters
$number = intval($_GET['number_id'] ?? $_GET['number'] ?? 0);
$type   = trim($_GET['type'] ?? 'daily');

// Validation
if ($number < 1 || $number > 9) {
    echo json_encode([
        'success' => false, 
        'message' => 'Invalid number (must be 1-9)'
    ]);
    exit;
}

$allowed = ['daily','weekly','monthly','yearly'];
if (!in_array($type, $allowed)) {
    echo json_encode([
        'success'=>false,
        'message'=>'Invalid type'
    ]);
    exit;
}

/* ---------------- DB CONFIG ---------------- */
$paths = [
    'admin/config/db_config.php',
    'config/db_config.php',
    '../config/db_config.php'
];

foreach ($paths as $p) {
    if (file_exists($p)) {
        require_once $p;
        break;
    }
}

if (!defined('DB_HOST')) {
    define('DB_HOST', 'localhost');
    define('DB_USER', 'askmanisha_newuser');
    define('DB_PASS', 'Webgennie@developers');
    define('DB_NAME', 'askmanisha_astrology_site');
}

$conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);
if ($conn->connect_error) {
    echo json_encode([
        "success" => false,
        "message" => "Database connection failed"
    ]);
    exit;
}
$conn->set_charset("utf8mb4");

/* ------------- CURRENT TIME VALUES ------------- */
$today = date("Y-m-d");
$week_start = date('Y-m-d', strtotime('monday this week'));
$week_end   = date('Y-m-d', strtotime('sunday this week'));
$month = (int)date("n");
$year  = (int)date("Y");

/* ----------- TABLE NAMES ----------- */
$table = [
    'daily' => 'numerology_daily',
    'weekly' => 'numerology_weekly',
    'monthly' => 'numerology_monthly',
    'yearly' => 'numerology_yearly'
][$type];

/* ---------------- BUILD QUERY WITH PROPER WHERE CLAUSE ---------------- */
$sql = "";
$stmt = null;

switch ($type) {
    case 'daily':
        $sql = "SELECT content, lucky_number, lucky_color, date, id
                FROM $table
                WHERE number = ? AND date = ?
                ORDER BY id DESC
                LIMIT 1";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("is", $number, $today);
        break;

case 'weekly':
        $sql = "SELECT content, lucky_number, lucky_color, week_start, week_end, id
                FROM $table
                WHERE number = ? 
                AND ? BETWEEN week_start AND week_end
                ORDER BY id DESC
                LIMIT 1";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("is", $number, $today);
        break;

case 'monthly':
        $sql = "SELECT content, lucky_number, lucky_color, month, year, id
                FROM $table
                WHERE number = ? AND month = ? AND year = ?
                ORDER BY id DESC
                LIMIT 1";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("iii", $number, $month, $year);
        break;

case 'yearly':
        $sql = "SELECT content, lucky_number, lucky_color, lucky_months, year, id
                FROM $table
                WHERE number = ? AND year = ?
                ORDER BY id DESC
                LIMIT 1";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("ii", $number, $year);
        break;
}

if (!$stmt) {
    echo json_encode([
        "success" => false,
        "message" => "Failed to prepare query"
    ]);
    $conn->close();
    exit;
}

$stmt->execute();
$result = $stmt->get_result();
$found = $result->fetch_assoc();

/* ---------------- RESPONSE WITH LINE BREAK PROCESSING ---------------- */
if ($found) {
    // Process content to handle line breaks properly
    $content = $found['content'] ?? '';
    
    // Convert various line break formats to <br> tags
    $content = str_replace(["\r\n", "\r", "\n"], "<br>", $content);
    
    // Remove wrapping h3 tags if the entire content is wrapped
    if (preg_match('/^<h3>(.*)<\/h3>$/is', $content, $matches)) {
        $content = $matches[1];
    }
    
    // Convert headings within content to bold paragraphs instead
    $content = preg_replace('/<h([1-6])>(.*?)<\/h\1>/is', '<p style="font-weight: 600; font-size: 1.1em; margin: 1em 0 0.5em 0;">$2</p>', $content);
    
    $response = [
        "success" => true,
        "reading" => $content,
        "horoscope" => $content,
        "lucky_number" => $found['lucky_number'] ?? '',
        "lucky_color" => $found['lucky_color'] ?? '',
        "timestamp" => time(),
        "cache_buster" => $_GET['v'] ?? time()
    ];
    
    // Add lucky_months for yearly type
    if ($type === 'yearly' && isset($found['lucky_months'])) {
        $response['lucky_months'] = $found['lucky_months'];
    }
    
    echo json_encode($response, JSON_UNESCAPED_UNICODE);
} else {
    echo json_encode([
        "success" => false,
        "message" => "No $type reading available for Number $number at this time.",
        "reading" => "",
        "debug_info" => [
            "number" => $number,
            "type" => $type,
            "today" => $today,
            "week_start" => $week_start,
            "week_end" => $week_end,
            "month" => $month,
            "year" => $year,
            "table" => $table,
            "hint" => "Check if data exists in database for these parameters"
        ]
    ]);
}

$stmt->close();
$conn->close();
?>

[X] 取消