php - 空字段显示在 Codeigniter 中插入批处理错误

Question

我有多个表单字段。我想使用 codeigniter 中的 insert_batch 在数据库中插入超过 25 行。就像

 public function purchase(){

  $data = array(

  array(

         'date'=> $this->input->post('date'),
         'vendor_name'=>$this->input->post('vendor_name'),
         'model'=>$this->input->post('model'),
         'price' =>$this->input->post('price'), 
         'purchase_quantity'=>$this->input->post('quantity'),
         'amount'  =>$this->input->post('price')*$this->input->post('quantity'),
         'invoice_no'=>$this->input->post('invoice')
         ),

          array(
         'date'=> $this->input->post('date'),
         'vendor_name'=>$this->input->post('vendor_name2'),
         'model'=>$this->input->post('model2'),
         'price' =>$this->input->post('price2'), 
         'purchase_quantity'=>$this->input->post('quantity2'),
         'amount'  =>$this->input->post('price2')*$this->input->post('quantity2'),
         'invoice_no'=>$this->input->post('invoice')
         ),

          array(
         'date'=> $this->input->post('date'),
         'vendor_name'=>$this->input->post('vendor_name3'),
         'model'=>$this->input->post('model3'),
         'price' =>$this->input->post('price3'), 
         'purchase_quantity'=>$this->input->post('quantity3'),
         'amount'  =>$this->input->post('price3')*$this->input->post('quantity3'),
         'invoice_no'=>$this->input->post('invoice')
         )

         );

  $insert = $this->db->insert_batch('purchase',$data);

  return $insert; 

  }

但是如果我完成两个字段并提交，则会显示类似

的错误

整数值不正确:第 3 行“purchase_quantity”列的“”

INSERT INTO `purchase` (`amount`, `date`, `invoice_no`, `model`, `price`, 

`purchase_quantity`, `vendor_name`) VALUES 

(4995,'18-09-2014','vvvvv','m6','999','5','mizan'), 

(5000,'18-09-2014','vvvvv','ab12','1000','5','abcde'), (0,'18-09-2014','vvvvv',0,0,'','')

文件名:C:\xampp\htdocs\final\sys\database\DB_driver.php

行号:330

请帮忙。

Answer 1

在整数值之前使用 intval..

intval($this->input->post('quantity2'))

https://ellislab.com/forums/viewthread/238144/