Home > 모듈/모듈스킨 > 통합게시판
아포리아2023.01.01 23:35

친구 랜덤 추천

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
$limit = 8;
$oDB = DB::getInstance();
$query = 'SELECT max(member_srl) as max_member_srl FROM member';
$stmt = $oDB->prepare($query);
$stmt->execute();
$result = $stmt->fetchAll();
$max_member_srl = $result[0]->max_member_srl;
 
$random_member_srl = rand(4, $max_member_srl);
debugPrint($random_member_srl);
$query = 'SELECT *
FROM (
(SELECT member_srl, nick_name FROM member WHERE member_srl >= ? AND denied = ? LIMIT ?)
UNION ALL
(SELECT member_srl, nick_name FROM member WHERE member_srl < ? AND denied = ? LIMIT ?)
) AS random_members
WHERE random_members.member_srl NOT IN (SELECT target_srl FROM member_friend WHERE member_friend.member_srl = ?)
AND random_members.member_srl <> ?
ORDER BY rand()
LIMIT ?';
$stmt = $oDB->prepare($query);
$stmt->execute([$random_member_srl, 'N', $limit, $random_member_srl, 'N', $limit, $logged_info->member_srl, $logged_info->member_srl, $limit]);
$result = $stmt->fetchAll();
debugPrint($result);

 

▼
사진 및 파일 첨부

여기에 파일을 끌어 놓거나 왼쪽의 버튼을 클릭하세요.

파일 용량 제한 : 20.00MB