PHP获取数据库中成员,php – 如何从数据库中获取数据

我的数据库结构：

人

id | name |

1 | John |

2 | Doe |

3 | Marc |

任务

task_id | task_name| person_id

1 | Get milk | 1

2 | Play cs | 1

3 | Walk dog | 2

4 | Eat fruit | 3

评论

id | comment | task

1 | Wich one | 1

2 | When? | 2

我试过这个：

function get_shapes2() {

$this->db->select('person.name,person.id,')

->select('GROUP_CONCAT(DISTINCT comments.id separator " -/r/- ") as "commentid" ')

->select('GROUP_CONCAT(DISTINCT comments.comment separator " -/r/- ") as "comment" ')

->select('GROUP_CONCAT(DISTINCT tasks.task_name separator " -/r/- ") as "tname"')

->select('GROUP_CONCAT(DISTINCT tasks.task_id separator " -/r/- " ) as "id2"');

$this->db->from('person');

$this->db->join('tasks', 'tasks.person_id = person.id', 'left');

$this->db->join('comments', 'comments.task = tasks.task_id', 'left ');

$this->db->group_by('id');

$query = $this->db->get();

$res = array();

foreach ($query->result() as $row) {

$posts[] = $row->name;

$posts[] = (int) $row->id;

$posts[] = array_map(function($tname, $tid){

return array('tname'=>$name,'tid'=>$tid);

},

explode(" -/r/- ",$row->tname),

explode(" -/r/- ",$row->id2));

array_push($res, $posts);

unset($posts);

}

return $res;

}

我得到的是：

{name: John, id: 1, task =[ {tname: "Get milk", tid: "1"},{tname: "Play cs", tid: "2"}]}

我想要做的是每个人获得所有任务,只有1个最新评论,如果评论存在则为comment_id,并将其存储在与任务相同的数组中

{name: John, id: 1, task =[ {tname: "Get milk", tid: "1" comment: " Wich one", commentid: 1 },{tname: "Play cs", tid: "2" comment: " When?", commentid: 2 }]}

我面临的问题是我对如何做到这一点没有任何线索..

我已经尝试将它添加到array_map但它随机存储注释它没有缝合工作

解决方法:

请使用jquery来捕获json数据 – 这是很容易捕获的方法

$( document ).ready(function() {

$.getJSON("YOUR_PHP_LINK",function(data)

{

var tb = $("#tab");

$.each(data,function(i,value)

{

tb.append("

Name: " + value.name + "ID: " + value.id+ " ");

});

});

});

标签：php,mysql,codeigniter

来源： https://codeday.me/bug/20190710/1426113.html