php - CODEIGNITER 当 user_ID 登录时如何将 user_ID 插入到 mySQL

Question

这是错误页面

无法添加或更新子行:外键约束失败 (latihan_ci.adventure, CONSTRAINT adventure_ibfk_1 FOREIGN KEY ( user_id)引用user(user_id)更新级联)

插入冒险(名称、类别、地点、状态)值('semeru'、'gunung'、'asa'、'asd')

这是我的 Controller

public function addTrip(){
    $this->load->model('userModel');
    $newTrip = ['name' => $this->input->post('name'),
                'category' => $this->input->post('category'),
                'place' => $this->input->post('place'),
                'state' => $this->input->post('state'),

                ];
            $data['users'] = $this->userModel->getUserId()->result(); 

    $this->db->insert('adventure',$newTrip);
    $this->db->insert('adventure',$data);

    redirect('userController/profile');
}

这是我的模型

public function getUserId()
    {
        return $this->db->get('users',['user_id']);
    }

那么当值是已经登录的user_ID时，如何将user_ID添加到mySQL中。非常感谢

Answer 1

当时登录时user_id使用后存储在 session 中

Controller

$newTrip = ['name' => $this->input->post('name'),
            'category' => $this->input->post('category'),
            'place' => $this->input->post('place'),
            'state' => $this->input->post('state'),
            'user_id'=>$this->session->userdata('userdata'),
];