"SET CHARACTER SET 'utf8'"); $dbh = new PDO(DB_DSN, DB_USER, DB_PASSWORD, $options); $dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); error_reporting(E_ALL & ~E_NOTICE); setTimezone($dbh); $sql = <<0 AND act.start_date <= NOW() AND NOW() < act.end_date INNER JOIN session_master as sm2 ON sm2.id=IFNULL(act.session,0) INNER JOIN capacity_master as cm2 ON cm2.id=IFNULL(act.capacity,0) LEFT OUTER JOIN plan_master as p ON p.id=act.plan_id WHERE u.member_id=:mids EOF; $stmt = $dbh->prepare($sql); $params = array(':mids' => $_SESSION['member_id']); $stmt->execute($params); $result = $stmt->fetch(PDO::FETCH_ASSOC); $sql = <<prepare($sql); $stmt->execute(array(':mids' => $_SESSION['member_id'])); $mqtt_server = $stmt->fetch(PDO::FETCH_ASSOC); $sql = <<:g UNION SELECT 1 FROM personal_info WHERE del_flg='0' and id>:p and user_id=:uid END; $stmt = $dbh->prepare($sql); $stmt->execute(array( ':uid' => $result['id'], ':g' => $result['info_read'], ':p' => $result['personal_info_read'] )); $read = $stmt->fetch(PDO::FETCH_ASSOC); $array = [ 'contract_start' => $result['use_start'], 'contract_end' => $result['contract_end'], 'last_login' => $result['last_login'], 'mail_enable' => $result['mail_enable'], 'session' => (int)$result['session'], 'capacity' => (int)$result['capacity'], 'info_stat' => empty($read) ? 'none' : 'more', 'mqtt_server' => $mqtt_server['host'], 'plan_name' => $result['plan_name'], 'capacity_gb' => $result['capacity_gb'], 'session_connections' => $result['session_connections'] ]; echo json_encode($array); } wrap('check');