"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); $sql = <<0 AND act.start_date <= NOW() AND NOW() < act.end_date INNER JOIN capacity_master as cm ON cm.id=u.capacity INNER JOIN capacity_master as cm2 ON cm2.id=IFNULL(act.capacity,0) 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 = <<: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 = [ 'last_update' => $result['lastupdate'], 'file_number' => (int)$result['file'], 'use_data' => (int)$result['use_data'], 'capacity' => (int)$result['capacity'], 'capacity_gb' => (int)$result['capacity_gb'], 'use_data_disp' => convUseData($result['use_data']), 'cap_per' => calcCapPercent($result), 'info_stat' => empty($read) ? 'none' : 'more', 'is_first' => (int)$result['is_first'] ]; echo json_encode($array); } wrap('check');