CakePHP 保存数据时遇到问题 (HABTM)

发布于 2024-10-15 11:46:25 字数 1402 浏览 2 评论 0原文

我正在尝试创建愿望清单。

有用户模型和产品模型。用户有一个愿望清单。愿望清单有很多产品。

我之所以让用户有愿望清单，而愿望清单有产品，是因为我可以有一个像wish_lists/add/:product_id这样的网址，

我用id创建了一个名为wish_lists的表， user_id 和 name。

我还使用 wish_list_id 和 product_id 创建了一个名为 products_wish_lists 的表。

我在这里制作的是愿望清单控制器：

class WishListsController extends AppController 
{
    var $hasOne = 'User';
    var $hasMany = 'Product';

    function beforeFilter() 
    {        
        parent::beforeFilter();       
        $this->Auth->deny('add');    
    }

    function add($id)
    {
        $user =  $this->Session->read("Auth.User");

        $this->WishList->set(array(
            'User.id' => $user['id'],
            'Product.id'=>$id,
            'WishList.name'=>'default'
        ));

        if($this->WishList->save())
        {
            $this->Session->setFlash('This product has been added to your wishlist.', 'flash_good');
        }
        else
        {
            $this->Session->setFlash('Error: This product was not added to your wishlist.', 'flash_bad');   
        }

        $this->redirect(array("controller"=>"products","action"=>"view",$id));
    }
}

当我转到 localhost/wish_lists/add/1 时，它每次保存时都会告诉我。但没有数据被添加到数据库中。

不确定我做错了什么？

原文

I am trying to create wish lists.

There are user and product models. A user has a wish list. A wish list has many products.

The reason I am making it user has wishlist and wishlist has products is so I can have a url like wish_lists/add/:product_id

I created a table called wish_lists with id, user_id, and name.

I also created a table called products_wish_lists with wish_list_id and product_id.

I made here is the wishlists controller:

class WishListsController extends AppController 
{
    var $hasOne = 'User';
    var $hasMany = 'Product';

    function beforeFilter() 
    {        
        parent::beforeFilter();       
        $this->Auth->deny('add');    
    }

    function add($id)
    {
        $user =  $this->Session->read("Auth.User");

        $this->WishList->set(array(
            'User.id' => $user['id'],
            'Product.id'=>$id,
            'WishList.name'=>'default'
        ));

        if($this->WishList->save())
        {
            $this->Session->setFlash('This product has been added to your wishlist.', 'flash_good');
        }
        else
        {
            $this->Session->setFlash('Error: This product was not added to your wishlist.', 'flash_bad');   
        }

        $this->redirect(array("controller"=>"products","action"=>"view",$id));
    }
}

When I go to localhost/wish_lists/add/1 It tells me everytime that it saved. but no data is being added to the database.

Not sure what I am doing wrong?

分享到QQ

分享到微博

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

发布评论

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

嘿看小鸭子会跑 2024-10-22 11:46:25

我从来不这样做，我总是构建一个 $data 数组作为参数一传递给保存函数。

因此，我不确定该语法是否允许您像您所做的那样指定模型，即 'Model.field'。无论如何，$this->WishList->save()只会保存Wishlist部分。

在我看来，更好的是：（

$saveData = array(
    'User'=>array('id'=>$user['id']),
    'Product'=>array('id'=>$id),
    'WishList'=>array('name'=>'default'));
$this->WishList->saveAll($saveData);

或者类似的东西，过去三个月我一直在编程 ColdFusion，我的 PHP 可能有点混乱）

I never do it that way, I always build a $data array to pass as parameter one to the save function.

I'm not sure, therefore, whether that syntax will allow you to specify the model as you have done, i.e. 'Model.field'. In any case, $this->WishList->save() will only save the Wishlist part.

Better, in my opinion, would be:

$saveData = array(
    'User'=>array('id'=>$user['id']),
    'Product'=>array('id'=>$id),
    'WishList'=>array('name'=>'default'));
$this->WishList->saveAll($saveData);

(or something like that, I've been programming ColdFusion for the last three months and my PHP can be a bit addled)

回复收藏 0 原文