douchongbc72264 2017-11-02 10:22
浏览 46
已采纳

where子句中的列'id'对于3个表Codeigniter是不明确的

I am currently doing a system. In the system, there's a module called manage resident; where the manage resident will get the information of the resident if it is single, married and have a child(first,middle and last name for example).

I've done the adding or create new resident part, I am now in edit resident part. When I click the edit resident, I encountered error

Column 'id' in where clause is ambiguous

I have 3 tables: resident, married and children. Resident ID is the foreign key of married, while Married ID is the foreign key of children table.

My data example for each table(column Primary key, foreign key, first_name, middle_name, last_name

Resident -> id, Testing, Testing, Testing
Married  -> Married_id, resident_id, Testing, Testing, Testing
Children -> id, married_id, Testing, Testing, Testing

Question: How can I get the children of the selected Resident? Then display it separately in my fields in my view.

Controller

 $id = $this->uri->segment(4);
 $get_children = $this->Crud_model->get_children($id);

Model

public function get_children($id){
        $this->db->select('*');    
        $this->db->from('resident');
        $this->db->where('id',$id);
        $this->db->join('married', 'resident.id = married.resident_id');
        $this->db->join('children', 'resident.id = children.married_id');
        $query = $this->db->get();
        return $query->row();
    }

View

 <?php $explode = explode(",",$children->first_name); ?>

<div class="form-group">
  <label>First Name</label>
  <input type="text" class="form-control" name="child_fname" id="child_fname"><?= $explode?>
</div>
  • 写回答

2条回答 默认 最新

  • dongxi3859 2017-11-02 10:48
    关注

    Whenever you join tables with where condition you should write each column with its reference table name.

    so change

    $this->db->where('id',$id);
    

    to

    $this->db->where('resident.id',$id);
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 请教一个关于镜头标定,棋盘格格子大小的问题(畸变测试)
  • ¥15 el-table输入多维数组怎么实现
  • ¥15 安装GroudingDINO RuntimeError: Error compiling objects for extension
  • ¥15 关于推送项目到github的问题
  • ¥15 急!C++指针编写相关的问题
  • ¥15 kerberos身份认证配置问题
  • ¥30 用python写一个多签情况下波场的代理资源和回收资源
  • ¥15 怎么在matlab中输出显示泵的流量-扬程和管路损失与流量均在一个表格里
  • ¥15 matlab学期例题代码答疑
  • ¥15 在线手电筒追加按钮JS