Codeigniter从表中克隆数据并更新它 [英] Codeigniter Clone Data from table and update it

问题描述

我要做什么：
尝试从表付款到付款历史中克隆数据（更新）

What i am trying to do:
Try to Clone Data (Update) from Table "Payment" to "Payment History"

付款表

Payment_ID
Payment_Amount
Payment_Method
Payment_Remark

付款历史记录表

Payment_ID
PaymentHistory_ID
Payment_Amount
Payment_Method
Payment_Remark

两者具有相同的列和相同的数据类型

Both have the same column and same data type

我的代码：
控制器

    public function updateHistory($Payment_ID){

  $this->db->select('*'); 
  $this->db->from('Payment');   
  $this->db->where('Payment_ID', $Payment_ID); 
$query = $this->db->get();
    $this->db->update('PaymentHistory',$query);

}

推荐答案

您可以这样做：

$query = $this->db->where('Payment_ID', $Payment_ID)->get('Payment');
foreach ($query->result() as $row) {      
      $this->db->where('Payment_ID', $row->Payment_ID)->update('PaymentHistory', $row); // To update existing record
      //$this->db->insert('PaymentHistory',$row); // To insert new record
}

这篇关于Codeigniter从表中克隆数据并更新它的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！