我在将数据从 PHP 更新到我想要根据学生 ID 更新的 SQL 数据库时发现了一个问题

Question

这是我的代码：

function mark_update($lesson_id='', $student_id=''){

if ($this->session->userdata('admin_login') != 1)

redirect('login', 'refresh');

$data['status']                  = $this->input->post('status');

$data['uploader_type']          =   $this->session->userdata('

$data['uploader_id']            =   $this->session->userdata('

$data['year']                   =   $this->db->get_where('settings',array('type'=>'running_year'))- 

>row()->

$data['timestamp']              =   strtotime(date("Y-m-d H:i:s"));

$this->db->update('assessment', $data);

redirect(base_url().'index.php?admin/mark_upload/'.$lesson_id.'/'.$student_id , 'refresh');

}

Answer 1

希望这会对您有所帮助，更新您的数据并运行它$data = array('status'      => $this->input->post('status'),'uploader_type' => "yourdata",'year'       => "year");$this->db->where('student_id', $student_id);$this->db->update('assessment', $data);您可能需要根据需要更改此代码function mark_update($lesson_id='', $student_id=''){$data = array('status'      => $this->input->post('status'),'uploader_type' => "yourdata",'year'       => "year");$this->db->where('student_id', $student_id);$this->db->update('assessment', $data);}如果您想通过assessment_id 更新，那么像这样更新您的函数function mark_update($lesson_id='', $assessment_id=''){$data = array('status'      => $this->input->post('status'),'uploader_type' => "yourdata",'year'       => "year");$this->db->where('assessment_id', $assessment_id);$this->db->update('assessment', $data);}