Codeigniter 和 Grocery 店 CRUD - fatal error : Cannot access empty property

Question

我在此代码中收到“ fatal error :无法在第 1540 行访问/Applications/XAMPP/xamppfiles/htdocs/cityland/application/libraries/Grocery_CRUD.php 中的空属性”错误

public function projectAmenities()
{
        $crud = new grocery_CRUD();

        $crud->set_theme('datatables');
        $crud->set_table('tbl_sys_project_amenity');
        $crud->set_relation('amenity','tbl_sys_amenities','amenity');
        $crud->set_relation('project_id','tbl_sys_projects','project_id');
        $crud->set_subject('Amenities');
        $output = $crud->render();
        $this->projectAmenitiesOutput($output);
}

tbl_sys_project_amenity 是 tbl_sys_amenities 和 tbl_sys_projects 的辅助实体。此错误仅显示在此特定表中。

我的表结构

tbl_sys_amenities

amenity
description

tbl_sys_projects

project_id
title
location

tbl_sys_project_amenity

project_id
amenity
quantity

Answer 1

您需要创建 id列为 primary key和 autoincrement在 table 上tbl_sys_project_amenity它会修复。