<?php include("includes/db_config.php");

if (isset($_POST['item_name'])) {
    $item_name = mysqli_real_escape_string($conn, $_POST['item_name']);

    // Check if item already exists
    $checkQuery = "SELECT * FROM ah_item_details WHERE item_name = '$item_name'";
    $checkResult = mysqli_query($conn, $checkQuery);

    if (mysqli_num_rows($checkResult) == 0) {
        // Insert New Item
        $insertQuery = "INSERT INTO ah_item_details (item_name) VALUES ('$item_name')";
        mysqli_query($conn, $insertQuery);
        $new_id = mysqli_insert_id($conn);  // Get last inserted ID
    } else {
        $row = mysqli_fetch_assoc($checkResult);
        $new_id = $row['id'];  // Get existing item ID
    }

    echo json_encode(["id" => $new_id, "text" => $item_name]);
}
?>