<?php
include dirname(__FILE__) . '/dbconfig.php';
include dirname(__FILE__) . '/error.php';
include dirname(__FILE__) . '/utils.php';

include dirname(__FILE__) . '/session.php';

setTextDomain('myapps');

$options = array(PDO::MYSQL_ATTR_INIT_COMMAND=>"SET CHARACTER SET 'utf8'");
$dbh = new PDO(DB_DSN, DB_USER, DB_PASSWORD, $options);

$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

setTimezone($dbh);

error_reporting(E_ALL & ~E_NOTICE);


// UPDATE文を変数に格納
$sql = "UPDATE userdata SET sw_period = :param_contract, sw_space = :param_space, sw_failure = :param_failure, sw_regular = :param_regular, sw_overwrite = :param_overwrite, upd_log='set_notification.php', upd_log=NOW() WHERE member_id = :mids";
$stmt = $dbh->prepare($sql);
$params = array(':param_contract' => $_POST["contract"] ,':param_space' => $_POST["space"] ,':param_failure' => $_POST["failure"] ,':param_regular' => $_POST["regular"] ,':param_overwrite' => $_POST["overwrite"] , ':mids' => $_SESSION['member_id']);

// 更新する値と該当のIDが入った変数をexecuteにセットしてSQLを実行
$stmt->execute($params);