如何从方法上的另一个表中获取字段的值?当然,我有它表的主键。
我想在添加/编辑操作中这样做:
if (is_empty(value_field_from_another_table)) {
$crud->edit_fields('first','second');
$crud->add_fields('first','second');
} else {
$crud->edit_fields('first');
$crud->add_fields('first');
}
$query = $this->db->get_where('mytable', array('id' => $id), $limit, $offset);
or
$query = $this->db->get('mytable');
foreach ($query->result() as $row)
{
echo $row->title;
}