php - CodeIgniter 更新语法？

Question

我正在尝试更新我的“HM_Jobs”数据库，据我从手册中可以看出这应该有效，但它不会更新数据库，有什么建议吗？

function amend_job($title,$description,$location,$date,$time,$pay,$jobcat,$job_id) //This function amends a job.//
{ 
    $amendJob=array(
    "JobTitle"=>$title,
    "JobDescription"=>$description,
    "JobLocation"=>$location,
    "JobDate"=>$date,
    "JobStartTime" =>$time, 
    "JobPay"=>$pay, 
    "JobCategory"=>$jobcat, 
    ); 


    $this->db->where('JobID', $job_id);
    $this->db->update('HM_Jobs', $amendJob);
} 

Answer 1

型号:

建议:发送数组 $data 而不是单独发送每个值。

检查您是否已按照我在下面所做的操作进行操作 -

class Job_model extends CI_Model
{

    public $db;
    public function __construct()
    {
        parent::__construct();
        $this->db = $this->load->database('default',true);
    }

    public function amend_job($data, $job_id)
    {   
        $amendJob=array(
                          "JobTitle"=>$data['title'],
                          "JobDescription"=>$data['description'],
                          "JobLocation"=>$data['location'],
                          "JobDate"=>$data['date'],
                          "JobStartTime" =>$data['time'], 
                          "JobPay"=>$data['pay'], 
                          "JobCategory"=>$data['jobcat'] 
                    ); 

                    $this->db->where('JobID', $job_id);
                    $this->db->update('HM_Jobs', $amendJob);
    }
}

尝试调试:

1) 打印传递给函数的两个值。

echo $job_id.'<br><pre>'; print_r($data);

2) 如果值正确，请尝试打印查询。

echo $this->db->last_query();   // after update query