gpt4 book ai didi

php - 如何在codeigniter中依次更新两个表数据?

转载 作者:行者123 更新时间:2023-11-29 05:16:44 25 4
gpt4 key购买 nike

I create a model to update plan data but now with that i want to update the vendor_plan_task_mapping data because i use the plan data with vendor so when i update the plan after creating a vendor with some plan the updated plan data can't come to vendor task status mapping data hear i create a model for updating plan i have to update task_status_mapp table to be update...

如何使用 vendor_plan_task_status_mapp 表更新计划。

计划更新的模型是

public function updatePlanData(){

$planId = $this->input->post('plan_id');
$data = array(

'plan_title' => $this->input->post('plan_title'),
'plan_price' => $this->input->post('plan_price'),
'plan_desc' => $this->input->post('plan_desc')

);

$this->db->where('plan_id', $planId);
$this->db->update('tbl_plan', $data);


$this->db->where('plan_id',$planId);
$this->db->delete('plan_task_mapping');



foreach ($this->input->post('task_id') as $key => $value)

{
$data2 = array(

'plan_id' => $planId,
'task_id' => $value

);
// echo "Index {$key}'s value is {$value}.";
$this->db->insert('plan_task_mapping', $data2);
}

//-------- HEAR I NEED A CODE TO UPDATE The V_T_S_M table-----------

}

第一次表更新后我想更新 vendr_task_status_mapping 表中的数据?????

最佳答案

在此答案中,如果您更改计划但使用此代码,您必须简单地编辑和更新它 ANGIN 并且此模型为您的任务创建一个新 ID 并再次插入它。

 public function vendorUpdateModel($data)

{
$vendor_id = $this->input->post('vendor_id');
$data = array(
'category_id' => $this->input->post('category_id'),
'plan_id' => $this->input->post('plan_id'),
'city_id' => $this->input->post('city_id'),
'business_name' => $this->input->post('business_name'),
'owner_name' => $this->input->post('owner_name'),
'contact_no1' => $this->input->post('contact_no1'),
'contact_no2' => $this->input->post('contact_no2'),
'vendor_email' => $this->input->post('vendor_email'),
'subscription_date' => $this->input->post('subscription_date'),
'vendor_description' => $this->input->post('vendor_description'),
'vendor_address' => $this->input->post('vendor_address')

);

$this->db->where('vendor_id', $vendor_id);
$this->db->update('vendor',$data);

$this->db->where('vendor_id',$vendor_id);
$this->db->delete('vendor_task_status_mapping');

$this->db->select('task_mapp_id');
$this->db->where('plan_id',$this->input->post('plan_id'));

$query = $this->db->get('plan_task_mapping');

foreach($query->result() as $row)

{
$data2 = array(

'task_mapp_id' => $row->task_mapp_id,
'vendor_id' => $vendor_id,
'task_status' => '0'

);

$this->db->insert('vendor_task_status_mapping', $data2);
}
return;
}

关于php - 如何在codeigniter中依次更新两个表数据?,我们在Stack Overflow上找到一个类似的问题: https://stackoverflow.com/questions/31717793/

25 4 0
Copyright 2021 - 2024 cfsdn All Rights Reserved 蜀ICP备2022000587号
广告合作:1813099741@qq.com 6ren.com