✏ 编辑: get_basic_info.php

<?php
header('Content-Type: application/json');

// Database configuration - adjust path if config is in admin folder
if (file_exists('config/db_config.php')) {
    require_once 'config/db_config.php';
} elseif (file_exists('admin/config/db_config.php')) {
    require_once 'admin/config/db_config.php';
} elseif (file_exists('../config/db_config.php')) {
    require_once '../config/db_config.php';
} else {
    // Direct connection if config file not found
   define('DB_HOST', 'localhost');
define('DB_USER', 'askmanisha_newuser');
define('DB_PASS', 'Webgennie@developers');
define('DB_NAME', 'askmanisha_astrology_site');

}

// Get parameters
$zodiac_id = isset($_GET['zodiac_id']) ? intval($_GET['zodiac_id']) : 0;

// Validate input
if ($zodiac_id < 1 || $zodiac_id > 12) {
    echo json_encode([
        'success' => false,
        'message' => 'Invalid zodiac sign'
    ]);
    exit;
}

try {
    // Create database connection
    $conn = new mysqli(DB_HOST, DB_USER, DB_PASS, DB_NAME);

// Check connection
    if ($conn->connect_error) {
        throw new Exception("Connection failed: " . $conn->connect_error);
    }

// Get basic info for the zodiac sign
    $sql = "SELECT description 
            FROM zodiac_basic_info 
            WHERE zodiac_id = ? 
            AND is_active = 1
            LIMIT 1";
    
    $stmt = $conn->prepare($sql);
    $stmt->bind_param("i", $zodiac_id);
    $stmt->execute();
    $result = $stmt->get_result();

if ($result->num_rows > 0) {
        $row = $result->fetch_assoc();
        echo json_encode([
            'success' => true,
            'horoscope' => $row['description'],
            'zodiac_id' => $zodiac_id
        ]);
    } else {
        echo json_encode([
            'success' => false,
            'message' => 'Basic information not available yet.',
            'horoscope' => 'Basic information for this zodiac sign will be updated soon. Please check back later.',
            'zodiac_id' => $zodiac_id
        ]);
    }

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

} catch (Exception $e) {
    echo json_encode([
        'success' => false,
        'message' => 'Unable to load basic information',
        'error' => $e->getMessage()
    ]);
}
?>

[X] 取消