ÿØÿà JFIF ` ` ÿþ
Server : Apache System : Linux ruga7-004.fmcity.com 3.10.0-1160.119.1.el7.x86_64 #1 SMP Tue Jun 4 14:43:51 UTC 2024 x86_64 User : tkt_travelbus ( 1137) PHP Version : 7.0.0p1 Disable Function : mysql_pconnect Directory : /tkt_travelbus/www/admin/setting/ |
Upload File : |
<? include "../include/top_proc.html"; //공통파일 인클루드 include "_common.php"; $table = "TB_HOLIDAY"; if($SqlType=="holiday_ins"){ if (!$holiday_date or !$holiday_name) exit; $dateEx = explode("-",$holiday_date); $holiday_year = $dateEx[0]; $holiday_month = $dateEx[1]; $holiday_day = $dateEx[2]; $timeStamp = mktime(0,0,0,(int)$holiday_month,(int)$holiday_day,(int)$holiday_year); $sql= "INSERT INTO {$table} SET "; $sql .= " holiday_date='{$holiday_date}',"; $sql .= " holiday_year='{$holiday_year}',"; $sql .= " holiday_month='{$holiday_month}',"; $sql .= " holiday_day='{$holiday_day}',"; $sql .= " holiday_name='{$holiday_name}', "; $sql .= " ins_id='{$TK_MEMBER[mb_id]}', "; $sql .= " timestamp = {$timeStamp}, "; $sql .= " nation = '{$nation}', "; $sql .= " ins_dt=now() "; db_query($sql); error_msg("document.location.href='holiday.html'","script"); }else if($SqlType=="holiday_edit"){ if (!$holidayid or !$holiday_date or !$holiday_name) exit; $dateEx = explode("-",$holiday_date); $holiday_year = $dateEx[0]; $holiday_month = $dateEx[1]; $holiday_day = $dateEx[2]; $timeStamp = mktime(0,0,0,(int)$holiday_month,(int)$holiday_day,(int)$holiday_year); $sql= "UPDATE {$table} SET "; $sql .= " holiday_date='{$holiday_date}',"; $sql .= " holiday_year='{$holiday_year}',"; $sql .= " holiday_month='{$holiday_month}',"; $sql .= " holiday_day='{$holiday_day}',"; $sql .= " holiday_name='{$holiday_name}', "; $sql .= " ins_id='{$TK_MEMBER[mb_id]}', "; $sql .= " timestamp = {$timeStamp} "; $sql .= " WHERE holidayid='{$holidayid}' "; db_query($sql); error_msg("document.location.href='holiday.html'","script"); }else if($SqlType=="holiday_del"){ if (!$holidayid) exit; $sql = "DELETE FROM {$table} WHERE holidayid='{$holidayid}'"; db_query($sql); error_msg("document.location.href='holiday.html'","script"); } ?>