<?php
include dirname(__FILE__) . '/nocache.php';

include dirname(__FILE__) . '/dbconfig.php';
include dirname(__FILE__) . '/error.php';
include dirname(__FILE__) . '/utils.php';

include dirname(__FILE__) . '/session.php';

function check() {
check_session();

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);

echo json_encode(unsubscribe($dbh));
}

function unsubscribe($dbh)
{

$sql = "UPDATE userdata SET exp_flg = 1 , lastupdate=now(), upd_log='set_unsubscribe.php', upd_date=NOW()  WHERE member_id = :mids";
$stmt = $dbh->prepare($sql);

$params = array( ':mids' => $_SESSION['member_id']);

// 更新する値と該当のIDが入った変数をexecuteにセットしてSQLを実行
$stmt->execute($params);

  return [
    'setmessage' => _('解約しました')
  ];
}
wrap('check');