File Manager

✏️ Edit File: C:\Inetpub\vhosts\doitcajmer.in\akhileshmittal.in/api/post.php

<?php
header("Content-Type: application/json; charset=UTF-8");
header("Access-Control-Allow-Origin: *");

include("../config/db.php");

if (!isset($_GET['id']) || !is_numeric($_GET['id'])) {
    echo json_encode([
        "status" => false,
        "message" => "Invalid Post ID"
    ]);
    exit;
}

$id = (int) $_GET['id'];

// Fetch Post
$postQuery = mysqli_query($conn, "SELECT * FROM posts WHERE id = $id");

if (mysqli_num_rows($postQuery) == 0) {
    echo json_encode([
        "status" => false,
        "message" => "Post not found"
    ]);
    exit;
}

$post = mysqli_fetch_assoc($postQuery);

// Image URL
if (!empty($post['image'])) {
    $post['image'] = "https://www.akhileshmittal.in/uploads/" . rawurlencode($post['image']);
}

// Fetch Quiz
$quizQuery = mysqli_query($conn, "
SELECT
    id,
    question,
    option_a,
    option_b,
    option_c,
    option_d,
    correct_option
FROM quizzes
WHERE post_id = $id
");

$quiz = [];

while ($row = mysqli_fetch_assoc($quizQuery)) {
    $quiz[] = $row;
}

echo json_encode([
    "status" => true,
    "post" => $post,
    "quiz" => $quiz
], JSON_UNESCAPED_UNICODE | JSON_UNESCAPED_SLASHES);

Batal

⬅ Naik ke akhileshmittal.in 2 item

Nama	Tipe	Ukuran	Diubah	Aksi
🐘post.php	php	1.2 KB	2026-07-08 17:29	✏️ Edit 👁️ View
🐘posts.php	php	1.9 KB	2026-07-14 14:39	✏️ Edit 👁️ View