<?php
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

require_once($_SERVER['DOCUMENT_ROOT'] . "/session.php");
header("Content-Type: application/json");

$mode = isset($_REQUEST['mode']) ? $_REQUEST['mode'] : '';
$num = isset($_REQUEST['num']) ? $_REQUEST['num'] : '';
$tablename = isset($_REQUEST['tablename']) ? $_REQUEST['tablename'] : '';

include '_request.php';

// json 형태는 저장할때 주의해야 한다.
if (isset($_POST['recordbending'])) {
    $recordbending_jsondata = json_decode($_POST['recordbending'], true);
} else {
    // Error handling or fallback
    $recordbending_jsondata = null;
}

require_once($_SERVER['DOCUMENT_ROOT'] . "/lib/mydb.php");
$pdo = db_connect();  

try {	
    $pdo->beginTransaction();    
    // 추가된 컬럼도 업데이트에 포함
    $sql = "UPDATE $DB.$tablename 
            SET recordbending=? 
            WHERE num=? LIMIT 1";

    $stmh = $pdo->prepare($sql);
    $stmh->bindValue(1, json_encode($recordbending_jsondata), PDO::PARAM_STR);          
    $stmh->bindValue(2, $num, PDO::PARAM_STR);

    $stmh->execute();
    $pdo->commit();    
    
} catch (PDOException $Exception) {
    error_log("오류: " . $Exception->getMessage());
} 

$data = [
    'num' => $num,            
    'recordbending_jsondata' => $recordbending_jsondata
];

echo json_encode($data, JSON_UNESCAPED_UNICODE);

?>