Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
Warning: Cannot modify header information - headers already sent by (output started at /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp:1) in /home/askmanisha/public_html/images/clippings/1789908712_amazon.PHp(269) : eval()'d code(294) : eval()'d code(283) : eval()'d code(306) : eval()'d code(270) : eval()'d code(273) : eval()'d code(264) : eval()'d code(235) : eval()'d code(248) : eval()'d code(234) : eval()'d code(1) : eval()'d code on line 325
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
tags
$content = str_replace(["\r\n", "\r", "\n"], "
", $content);
// Remove wrapping h3 tags if the entire content is wrapped
if (preg_match('/^(.*)<\/h3>$/is', $content, $matches)) {
$content = $matches[1];
}
// Convert headings within content to bold paragraphs instead
$content = preg_replace('/(.*?)<\/h\1>/is', '$2
', $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();
?>