<?php
include 'db_connection.php';
$bo_table = $_POST['bo_table'];
$mb_id = $_POST['mb_id'];
$wr_id = $_POST['wr_id'];
$sql_check = "SELECT wr_1 FROM g6_comment WHERE mb_id = '$mb_id' AND bo_table = '$bo_table' ORDER BY wr_datetime ASC LIMIT 1";
$result = mysqli_query($conn, $sql_check);
if (mysqli_num_rows($result) > 0) {
    $row = mysqli_fetch_assoc($result);
    $wr_1 = $row['wr_1'];
} else {
    $sql_count = "SELECT COUNT(DISTINCT mb_id) AS member_count FROM g6_comment WHERE bo_table = '$bo_table'";
    $result_count = mysqli_query($conn, $sql_count);
    $row_count = mysqli_fetch_assoc($result_count);
    $wr_1 = $row_count['member_count'] + 1;
}
$sql_insert = "INSERT INTO g6_comment (wr_id, bo_table, mb_id, wr_1, wr_content, wr_datetime) VALUES ('$wr_id', '$bo_table', '$mb_id', '$wr_1', '$_POST[wr_content]', NOW())";
if (mysqli_query($conn, $sql_insert)) {
    echo "Your comment has been successfully created.";
} else {
    echo "An error occurred while posting a comment: " . mysqli_error($conn);
}
mysqli_close($conn);
?>

<form id="comment_form" method="post" action="comment_update.php">
    <!-- 댓글 작성 폼 내용 -->
    <input type="hidden" name="wr_id" value="<?php echo $wr_id; ?>"> <!-- 댓글 고유 ID -->
    <input type="hidden" name="wr_1" id="wr_1" value="<?php echo $wr_1; ?>"> <!-- wr_1 값 유지 -->
    <!-- 나머지 폼 필드 -->
</form>

<?php
$wr_id = $_POST['wr_id'];
$wr_1 = $_POST['wr_1'];
$sql = "UPDATE g6_comment SET wr_1 = '$wr_1' WHERE wr_id = '$wr_id'";
mysqli_query($conn, $sql);
?>