<?php

header('Content-Type: application/json; charset=utf-8');

$conn = new mysqli("localhost","team0","passwd","team0");

if ($conn->connect_error) {
    die(json_encode([
        "ok" => false,
        "error" => "Error connecting"
    ]));
}

$conn->set_charset("utf8mb4");

// ============================
// QUERY (GET)
// ============================
if ($_SERVER["REQUEST_METHOD"] == "GET") {

    $result = $conn->query("SELECT id, name, age FROM people");

    $data = [];

    while($row = $result->fetch_assoc()){
        $data[] = $row;
    }

    echo json_encode([
        "ok" => true,
        "data" => $data
    ]);

    exit;
}

// ============================
// INSERT (POST)
// ============================
if ($_SERVER["REQUEST_METHOD"] == "POST") {

    $name = $_POST["name"] ?? "";
    $age  = $_POST["age"] ?? "";

    if ($name == "" || $age == "") {
        echo json_encode([
            "ok" => false,
            "error" => "Data needed"
        ]);
        exit;
    }

    $stmt = $conn->prepare("INSERT INTO people(name, age) VALUES (?,?)");
    $stmt->bind_param("si", $name, $age);

    if ($stmt->execute()) {

        echo json_encode([
            "ok" => true,
            "id" => $conn->insert_id
        ]);

    } else {

        echo json_encode([
            "ok" => false,
            "error" => $stmt->error
        ]);

    }

    $stmt->close();
}

$conn->close();

?>