php - cakephp中当值为null时如何保存记录？

Question

我想保存记录但是在for循环中下一个id为null，我该如何保存这种情况下的记录，当找到null并保存之前的记录时循环将停止。

 foreach($record['ProductPlan'] as $value=>$key)

{
 $ProductsUser = array('product_plan_id'=>$key,'user_node_id'=>$userNodeId, 'is_active'=>1);
                            $this->$model->UserNode->ProductPlansUserNode->create();
                            $this->$model->UserNode->ProductPlansUserNode->save($ProductsUser);

                        }   

错误是 Integrity constraint violation: 1048 Column 'product_plan_id' cannot be null
并在数组中

   '2'
array(
'product_plan_id' => '2',
'user_node_id' => '26',
'is_active' => (int) 1
)
'3'
array(
'product_plan_id' => '3',
'user_node_id' => '26',
'is_active' => (int) 1
)
'' // This is null how can i save previous records before null?

Answer 1

我认为你对 $value 和 $key 感到困惑，反之亦然

在插入到表中之前，您需要添加对空数组或空数组的检查试试这个

 foreach($record['ProductPlan'] as $value=>$key){
   If($key){
   $ProductsUser = array('product_plan_id'=>$key,'user_node_id'=>$userNodeId, 'is_active'=>1);
   $this->$model->UserNode->ProductPlansUserNode->create();
   $this->$model->UserNode->ProductPlansUserNode->save($ProductsUser);  
  }

}