使用连接（codeigniter）从单个字段中检索并打印逗号分隔符后的值
技术问答
251 人阅读
|
0 人回复
|
2023-09-12
|
|
我在使用codeigniter从mysql检索值遇到问题。0 K8 ? z. t( K l. r% T) W" E
我有一个表名任务，其中一个字段signedUserid。
9 i8 A' G5 _6 t# _+ n7 B" B表格-任务：5 O2 ~ A* x* A/ p1 G3 w
id | title | assigneduserid-------------------------------------1 | Workspace | 23,21表-用户2 G% m/ _2 z6 W
id | title -----------------23 | Ashish21 | Ritesh在assigneduserid字段中有两个值为2321。
( H8 S/ n6 Q9 R: F我想使用该assigneduserid在用户表中打印两个用户名： Ashish，Ritesh 。
* Q; i, M5 ~% n- N# U8 d# E/ v我也想按 assigneduseid* 中升序设置的值 *
* w& u) H9 \" \2 Z0 N% ^我试着用回显在页面上打印记录，如下所示# m" _0 q6 J2 V6 M5 a6 j
以下是我正在打印的代码：3 y2 F0 s* Q3 F+ K+ Z4 \
usertitle;?>上面的代码只打印 Ashish 。) k2 B8 x* Y b; K+ Z- V
但我想印 Ashish，Ritesh
5 X9 T' h6 x% Z! e- E: [1 N以下是我的模型。
! C2 E5 K( m4 R& Mfunction getTask($id,$is_master_admin) { $this->db->select('workspace.title as workspacetitle,user.title as usertitle,task.*)；$this->db->join(WORKSPACE,WORKSPACE . '.id = ' . TASK . '.workspaceid','inner)；$this->db->join(USER,USER . '.id = ' . TASK . '.assigneduserid','inner)；$this->db->from(TASK); if (!$is_master_admin) $this->db->where(USER . '.id',$id); $this->db->where(TASK . '.tasktypeid$query = $this->db->get()；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；if ($query->num_rows() > 0return $query->result()；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；；} else return false; 谢谢高级
% A! i3 A* N( ~) V7 F
5 O% }" I4 a1 \! Z- |. t' x 解决方案: |
|
|
|
|
|
|
|
|
|
