leave_process.php

<?php
include './common/db.php';

$reserve_id = $_GET['reserve_id'];

try {
  date_default_timezone_set("Asia/Seoul");
  $currentTime = date("y-m-d H:i:s");

  $mysqli = connect();
  $query = "UPDATE P_RESERVE SET End_time='$currentTime' WHERE Reserve_id=$reserve_id;";
  $res = mysqli_query($mysqli, $query);

  session_destroy();
  echo "
  <script>
    alert('퇴실이 완료되었습니다.');
    location.replace('./index.php');
  </script>
  ";
} catch (Exception $e){
  echo $query;
  echo $e;
}
?>