通过更改模型中的条件来解决 hasAndBelongsToMany 问题

发布于 2024-12-01 13:22:02 字数 1182 浏览 0 评论 0原文

我通过动态更改 hasAndBelongsToMany 条件来选择博客条目，它对 cakephp 1.3 不再适用。奇怪的问题，因为它在 1.2 上工作得很好，在模型中，我通过放置一个带有静态 id 的条件来测试它，看看会发生什么，(Tag.name => 'libros')。但它通过了 hasAndBelongsToMany 条件。不管什么结果都给我带来。

var $hasAndBelongsToMany = array('Tag' =>
                       array('className'  => 'Tag',
                             'joinTable'  => 'blogs_tags',
                             'foreignKey' => 'blog_id',
                             'associationForeignKey'=> 'tag_id',
                             'conditions' => '',
                             'order'      => '',
                             'limit'      => '',
                             'unique'       => true,
                             'finderSql'  => '',
                             'deleteQuery'=> ''
                       )

在控制器中

$this->Blog->bindModel(array(
                  'hasAndBelongsToMany' => array(
                        'Tag' => array('conditions'=>array('Tag.name'=>'libros'))
            )));
            $this->Blog->find('all');

现在我不再有 mysql 错误，但我有其他记录和其他结果。诡异的。

原文

I select Blog entries by changing hasAndBelongsToMany conditions on the fly, it doesnt work anymore for me with cakephp 1.3.
Strange problem cause it was working fine with 1.2, in the model i test it by putting a condition with a static id to see what happen, (Tag.name => 'libros'). but it pass though the hasAndBelongsToMany condition. Bring me whatever results.

var $hasAndBelongsToMany = array('Tag' =>
                       array('className'  => 'Tag',
                             'joinTable'  => 'blogs_tags',
                             'foreignKey' => 'blog_id',
                             'associationForeignKey'=> 'tag_id',
                             'conditions' => '',
                             'order'      => '',
                             'limit'      => '',
                             'unique'       => true,
                             'finderSql'  => '',
                             'deleteQuery'=> ''
                       )

in the controller

$this->Blog->bindModel(array(
                  'hasAndBelongsToMany' => array(
                        'Tag' => array('conditions'=>array('Tag.name'=>'libros'))
            )));
            $this->Blog->find('all');

Now i dont have mysql error anymore , but i have others records with others results. Weird.

分享到QQ

分享到微博

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

发布评论

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

想你的星星会说话 2024-12-08 13:22:02

如果您有正确的数据库结构，则必须使用 this=

$this->Blog->bindModel(array(
                        'hasOne' => array(
                              'BlogsTag',
                              'FilterTag' => array(
                                    'className' => 'Tag',
                                    'foreignKey' => false,
                                    'conditions' => array('FilterTag.id = BlogsTag.tag_id')
                  ))));
            $data = $this->Blog->find('all', array(
                        'fields' => array('Blog.*'),
                        'conditions'=>array('FilterTag.name'=>'libros')
            ));

您可以在以下位置阅读有关此内容的更多信息：
http://book.cakephp.org/view/1044/hasAndBelongsToMany-HABTM

If you have a correct database structure, must use this=

$this->Blog->bindModel(array(
                        'hasOne' => array(
                              'BlogsTag',
                              'FilterTag' => array(
                                    'className' => 'Tag',
                                    'foreignKey' => false,
                                    'conditions' => array('FilterTag.id = BlogsTag.tag_id')
                  ))));
            $data = $this->Blog->find('all', array(
                        'fields' => array('Blog.*'),
                        'conditions'=>array('FilterTag.name'=>'libros')
            ));

you can read more about this at :
http://book.cakephp.org/view/1044/hasAndBelongsToMany-HABTM

回复收藏 0 原文

~没有更多了~