Kohana ORM 关系

Question

我正在尝试掌握 Kohana ORM，但我有点卡住了。 我创建了类别和帖子模型，其关系基于category_id。

我可以分别获取帖子和类别模型，但是我似乎无法使用关系来获取它们。例如：

// Get first category
$category = ORM::factory('category', 1); 

foreach ($category->posts as $post)
{
    echo $post->title;                
}

上面的内容只是给了我一个空白屏幕（我知道我不应该在控制器中输出任何内容，只是想先让它工作）。

print_r($category); 

给我这个：

Model_Category Object ( [_has_many:protected] => Array ( [posts] => Array ( [model] => post [foreign_key] =>;category_id [through] => [far_key] => ; post_id ) ) [_has_one:protected] => Array () [_belongs_to:protected] => Array () [_load_with:protected] => Array () [_validate:protected] => => 数组 ( ) [_callbacks:protected] => 数组 ( ) [_filters:protected] => 数组 ( ) [_labels:protected] => 数组 ( ) [_object:protected ] id] => 1 [标题] => ) [_changed:protected] => 数组 () [_related:protected] => 数组 () [_loaded:protected] => _saved:protected] => 1 [_sorting:protected] => 数组 ( [id] => ASC ) [_foreign_key_suffix:protected] => _id [_object_name:protected] => 类别 [_object_plural:protected] > 类别 [_table_name:protected] => 类别 [_table_columns:protected] => 数组 ( [id] => 数组 ( [type] => int [min] => 0 [最大] => 65535 [列名] => id [列默认值] => [数据类型] => Smallint 无符号 [is_nullable] => [序数位置] => 1 [显示] => 6 [评论] => [额外] => auto_increment [键] => PRI [特权] =>选择、插入、更新、引用 ) [标题] => Array ( [type] => string [character_maximum_length] => 65535 [column_name] => title [column_default] => [data_type] => text [is_nullable] => [ordinal_position] => 2 [ collat​​ion_name] => latin1_swedish_ci [注释] => [键] => [权限] => 选择、插入、更新、引用） Array ( [type] => string [character_maximum_length] => 65535 [column_name] => 描述 [column_default] => [data_type] => text [is_nullable] => [ordinal_position] => 3 [ collat​​ion_name] => latin1_swedish_ci [额外] => [权限] => 选择、插入、更新、引用 ) ) [_ignored_columns:protected] =>数组 ( ) [_updated_column:protected] => [_created_column:protected] => [_primary_key:protected] => id [_primary_val:protected] =>名称 [_table_names_plural:protected] => 1 [_reload_on_wakeup:protected] => 1 [_db:受保护] => Database_MySQL 对象 ( [_connection_id:protected] => d6ad44aa068ae69071b9614f2a4a760bf55d9307 [_identifier:protected] => [last_query] => 显示类别中的完整列` [_instance:protected] => 默认 [_connection :protected] => 资源 id #36 [_config:protected] => 数组 ( [type] => mysql [连接] => 数组 ( [主机名] => localhost [数据库] => cms_test_kohana [持久] => ) [表前缀] => [字符集] => [缓存] => [分析] => 1) ) [_db_applied:protected]数组 ( ) [_db_pending:protected] =>数组 ( ) [_db_reset:protected] => 1 [_db_builder:受保护] => [_with_applied：受保护] =>数组 ( ) [_preload_data:protected] =>数组 ( ) )

有人可以帮忙吗？

任何建议表示赞赏。

谢谢。

Answer 1

帖子是一种关系，而不是集合。对关系使用 find_all() 或 find() 可返回记录集合。

foreach ($category->posts->find_all() as $post) {
    echo $post->title;                
}

您还可以将各种其他方法应用于关系，以使用 orderby、where 等过滤返回的结果...