<?php

header("Access-Control-Allow-Origin: *");
header("Content-Type: application/json");
header("Access-Control-Allow-Headers: Content-Type");

$host = "localhost";
$user = "dzafir41";
$pass = "dzakyfirdhan4321";
$db   = "xmmyid_MANSA1";

$conn = new mysqli($host,$user,$pass,$db);

if($conn->connect_error){
    die(json_encode([
        "success"=>false,
        "message"=>"Koneksi database gagal"
    ]));
}

$json = file_get_contents("php://input");
$data = json_decode($json,true);

$sNO   = $conn->real_escape_string($data['No']);
$sTgl  = $conn->real_escape_string($data['TGL']);
$sType = $conn->real_escape_string($data['Type']);
$sAgen = $conn->real_escape_string($data['Agen']);
$sPcs  = $conn->real_escape_string($data['Pcs']);
$sKet  = $conn->real_escape_string($data['Ket']);

$sql = "
INSERT INTO s0
(
sNO,
sTgl,
sType,
sAgen,
sPcs,
sKet
)
VALUES
(
'$sNO',
'$sTgl',
'$sType',
'$sAgen',
'$sPcs',
'$sKet'
)
";

if(!$conn->query($sql)){

    echo json_encode([
        "success"=>false,
        "message"=>$conn->error
    ]);

    exit;
}

$rows = [];

$rs = $conn->query("
SELECT
sNO,
sTgl,
sType,
sAgen,
sPcs,
sKet
FROM s0
ORDER BY id DESC
");

while($r = $rs->fetch_assoc()){
    $rows[] = $r;
}

echo json_encode([
    "success"=>true,
    "message"=>"Data berhasil disimpan",
    "data"=>$rows
]);

$conn->close();

?>