{@ $total_count = $total_page = 0; $list_count = 20; $page_count = 10; $page = Context::get('page') ? intval($page) : 1; $friend_list = []; $oDB = DB::getInstance(); $query = 'SELECT COUNT(*) AS count FROM member_friend, member WHERE member_friend.target_srl = ? AND member.member_srl = member_friend.member_srl'; $stmt = $oDB->prepare($query); $stmt->execute([$logged_info->member_srl]); $result = $stmt->fetchAll(); $total_count = $result[0]->count; $total_page = max(1, ceil($total_count / $list_count)); $page_navigation = new PageHandler($total_count, $total_page, $page, $page_count); if ( $total_count > 0 ): $limit = ($page > 1) ? $list_count * ($page-1) . ', ' . $list_count : $list_count; $query = 'SELECT friend_srl, friend_group_srl, member.member_srl, member.nick_name, member_friend.regdate FROM member_friend, member WHERE member_friend.target_srl = ? AND member.member_srl = member_friend.member_srl ORDER BY member_friend.list_order ASC LIMIT ' . $limit; $stmt = $oDB->prepare($query); $stmt->execute([$logged_info->member_srl, $list_count]); $result = $stmt->fetchAll(); $friend_list = $result; endif; }