"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); $dbh->query('BEGIN'); if (isset($POST['info_read']) && $POST['info_read']) { $sql = "UPDATE userdata SET info_read = ?, upd_log='read_info.php', upd_date=NOW() WHERE member_id=?"; $stmt = $dbh->prepare($sql); $stmt->execute(array($POST['info_read'], $_SESSION['member_id'])); } if (isset($POST['personal_info_read']) && $POST['personal_info_read']) { $sql = "UPDATE userdata SET personal_info_read = ?, upd_log='read_info.php', upd_date=NOW() WHERE member_id=?"; $stmt = $dbh->prepare($sql); $stmt->execute(array($POST['personal_info_read'], $_SESSION['member_id'])); } $sql = << u.info_read AND del_flg='0' UNION SELECT 1 FROM personal_info WHERE id > u.personal_info_read AND user_id=u.id AND del_flg='0' ) EOF; $stmt = $dbh->prepare($sql); $stmt->execute(array($_SESSION['member_id'])); $result = $stmt->fetch(PDO::FETCH_ASSOC); $dbh->query('COMMIT'); if ($result) { return array('info_stat' => 'more'); } else { return array('info_stat' => 'none'); } } wrap(function() { echo json_encode(check()); });