BIM-Monitor/script/php/delete_data.php

<?php
session_start();
date_default_timezone_set('Asia/Taipei');
$now = date("Y/m/d H:m:s");
include("./connect_sql.php");
if (isset($_POST["delete-date"])) {
	$date = $_POST["delete-date"];
	$tables = ["BS_Data", "EP_Data", "ETI_Data", "EXM_Data", "OW_Data", "RB_Data", "SB_Data", "SID_Data", "SIS_Data", "SM_Data", "SP_Data", "SS_Data", "VG_Data", "TI_Data"];
	foreach ($tables as $table) {
		$sql = "DELETE FROM [BIMMonitor].[dbo].[{$table}] WHERE [Date] = '{$date}'";
		$stmt = sqlsrv_query($conn, $sql);
	}
	$sql = "INSERT INTO [dbo].[delete_table_log]
				([UserID]
				,[TableDate]
				,[DeleteDate])
			VALUES
				('{$_SESSION['UserID']}'
				,'{$date}'
				,'{$now}')";
	$stmt = sqlsrv_query($conn, $sql);
	echo $_SESSION['UserID'] . " 已將 " . $date . " 全數刪除!";
	header("Location: ../../delete.php?status=".$_SESSION['UserID'] . " 已將 " . $date . " 全數刪除!");
} else {
	echo "請輸入日期";
	header("Location: ../../delete.php?status=請輸入日期");
}