php 使用laravel fluent查询构建器从多个表中选择
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/14463921/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Select from multiple tables with laravel fluent query builder
提问by Simon Smith
I'm re-writing some PHP/MySQL to work with Laravel. One thing I would like to do is make the DB queries more succinct with the Fluent Query Builderbut I'm a bit lost:
我正在重新编写一些 PHP/MySQL 以使用 Laravel。我想做的一件事是使用 Fluent Query Builder使数据库查询更加简洁，但我有点迷茫：
SELECT p.post_text, p.bbcode_uid, u.username, t.forum_id, t.topic_title, t.topic_time, t.topic_id, t.topic_poster
FROM phpbb_topics t, phpbb_posts p, phpbb_users u
WHERE t.forum_id = 9
AND p.post_id = t.topic_first_post_id
AND u.user_id = t.topic_poster
ORDER BY t.topic_time
DESC LIMIT 10
This queries a phpbb forum and gets posts:
这会查询 phpbb 论坛并获取帖子：
How could I re-write this to make use of the Fluent Query Builder syntax?
我如何重写它以使用 Fluent Query Builder 语法？
回答by itachi
Not tested but here is a start
未经测试，但这是一个开始
return DB::table('phpbb_topics')
->join('phpbb_posts', 'phpbb_topics.topic_first_post_id', '=', 'phpbb_posts.post_id')
->join('phpbb_users', 'phpbb_topics.topic_poster', '=', 'phpbb_users.user_id')
->order_by('topic_time', 'desc')
->take(10)
->get(array(
'post_text',
'bbcode_uid',
'username',
'forum_id',
'topic_title',
'topic_time',
'topic_id',
'topic_poster'
));
回答by user3967434
return DB::table(DB::raw('phpbb_topics t, phpbb_posts p, phpbb_users u'))
->select(DB::raw('p.post_text, p.bbcode_uid, u.username, t.forum_id, t.topic_title, t.topic_time, t.topic_id, t.topic_poster'))
->where('phpbb_topics.topic_first_post_id', '=', 'phpbb_posts.post_id')
->where('phpbb_users', 'phpbb_topics.topic_poster', '=', 'phpbb_users.user_id')
->order_by('topic_time', 'desc')->take(10)->get();
