<?php
require_once 'db.php';

if (isset($_POST['image']) && isset($_POST['caption'])) {

    // Extract data from the POST request
    $image = $_POST['image'];
    $caption = $_POST['caption'];

    $sql = "INSERT INTO image_library (
        image_library_id, image, caption)
        VALUES ('',
                '$image',
                '$caption')";

    if (mysqli_query($link, $sql)) {
        $pg__id = mysqli_insert_id($link);
        $response = [
            'error_flag' => 0,
            'message' => 'Image Added Successfully in Image Library!',
            'pg_id' => $pg__id
        ];
        echo json_encode($response);
    } else {
        $response = [
            'error_flag' => 1,
            'message' => 'Failed to add image in image library.'
        ];
        echo json_encode($response);
    }
} else {
    $response = [
        'error_flag' => 1,
        'message' => 'Invalid request. Missing required parameters.'
    ];
    echo json_encode($response);
}