Kohana 3.1 ORM：如何制作“where ... in”条款

发布于 2024-10-31 18:25:57 字数 429 浏览 0 评论 0原文

感谢 Kohana 出色的文档，我不得不屈服于 SO。 ;)

希望这真的很简单：我正在尝试收集属于某个 ID 组的所有故事。我的代码如下：

$story_ids = '(12,56,99,213,319)';
$stories = ORM::factory('story')->where('id', 'IN', $story_ids)->find_all();

但是，这显然不起作用。我收到 MySQL 错误，因为查询中的 $story_ids 字符串两边加上了单引号。

编辑：我也尝试过将 $story_ids 作为数组传递，但后来我只是收到“500内部服务器错误”

是否可以执行我所要求的操作？

提前致谢。

原文

Thanks to Kohana's excellent documentation, I'm having to resort to prostrate myself on SO. ;)

Hopefully this is really simple: I'm trying to gather all stories which belong to a certain group of IDs. My code is as follows:

$story_ids = '(12,56,99,213,319)';
$stories = ORM::factory('story')->where('id', 'IN', $story_ids)->find_all();

However, this is obviously not working. I'm getting a MySQL error because single-quotes are being put around the $story_ids string in the query.

EDIT: I've also tried passing $story_ids as an array, but then I just get a "500 Internal Server Error"

Is it possible to do what I'm asking?

Thanks in advance.

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

桜花祭 2024-11-07 18:25:57

将 $story_ids 作为数组传递应该可以。

$story_ids = array(12,56,99,213,319);
$stories = ORM::factory('story')->where('id', 'IN', $story_ids)->find_all();

你用的 Kohana 版本是什么？

Passing $story_ids as an array should work.

$story_ids = array(12,56,99,213,319);
$stories = ORM::factory('story')->where('id', 'IN', $story_ids)->find_all();

What Kohana version do you use?

回复收藏 0 原文

仲春光 2024-11-07 18:25:57

您是否忘记了 ->select() ？

另外，此处概述了两种方法使用“IN”关键字：

ORM::factory('table1')->select('mls_id')->where('mls_id', 'NOT IN', DB::Select('mls_id')->from('table2'))->find_all();
ORM::factory('table1')->select('mls_id')->where('mls_id', 'NOT IN', DB::Expr('(SELECT mls_id FROM table2)'))->find_all();

我通常将 DB::Expr 方法与您正在做的事情一起使用。

Did you perhaps forget the ->select() ?

Also, here are two ways outlined here to use the "IN" keyword:

ORM::factory('table1')->select('mls_id')->where('mls_id', 'NOT IN', DB::Select('mls_id')->from('table2'))->find_all();
ORM::factory('table1')->select('mls_id')->where('mls_id', 'NOT IN', DB::Expr('(SELECT mls_id FROM table2)'))->find_all();

I typically use the DB::Expr method with what you're doing.

回复收藏 0 原文

~没有更多了~