Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- ```php
- //without defined relations
- return Thread::find()
- ->select('
- boards.name as boardName,
- threads.number as threadNumber,
- threads.sticked as isSticked,
- threads.locked as isLocked,
- threads.is_op_mark_enabled as opMark,
- threads.is_chat as isChat,
- post_data.*')
- ->join('INNER JOIN', 'boards', 'boards.id = board_id')
- ->join('INNER JOIN', 'post_data', 'post_data.id = post_data_id')
- ->all();
- //with defined relations
- return Thread::find()->innerjoinWith([
- 'board' => function ($query) use ($boardName){
- $query->where('boards.name = :name', [':name' => $boardName]);
- }])
- ->innerjoinWith('postData')
- ->andWhere('threads.id = post_data.id')
- ->select('post_data.*')
- ->all();
- //another example
- return Board::find()
- ->where('boards.name = :boardName', [':boardName' => $boardName])
- ->one()
- ->threads;g
- ```
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement