在一个会话中存储数据,一次似乎只能存储一条数据


Storing data in a session, can only seem to store 1 piece of data at a time

我试图允许用户创建一个短名单,但我添加了一件事——短名单,它覆盖了其中的其他内容,我做错了什么?

function validate_add_cart_item($id){
    $this->db->select('candidates.candidate_id, candidates.first_name, candidates.surname, candidates.DOB, candidates.talent, candidates.location, candidates.availability_order, candidates.availability, candidates.availability_comments, candidate_assets.url, candidate_assets.asset_size')
    ->from('candidates')
    ->join('candidate_assets', 'candidate_assets.candidates_candidate_id = candidates.candidate_id', 'left')
    ->where('candidate_assets.asset_size', 'small')
    ->where('candidate_assets.asset_type', 'image')
    ->where('candidates.candidate_id', (int)$id)
    ->limit(1)
    ->order_by('candidates.availability_order', 'DESC');
    $query = $this->db->get();
    //die($this->db->last_query());
    // Check if a row has been found
    if($query->num_rows > 0 ){
        foreach ($query->result() as $row)
        {
            $data = array(
                'id'      => $id,
                'name'    => $row->first_name." ".$row->surname,
                'location' => $row->location,
                'talent' => $row->talent,
                'image'  => $row->url
            );
            $this->session->set_userdata('shortlist', array($data));
            return TRUE;
        }
    // Nothing found! Return FALSE! 
    } else {
        return FALSE;
    }
   foreach(...){
      // ...
     $this->session->set_userdata('shortlist', array($data));
   }

您正在多次覆盖以前的用户数据。相反,您应该创建一个数组,并调用set_userdata一次。

  $udata = array();
  foreach(...){
    // ...
    $udata []= $data;
  }
  $this->session->set_userdata('shortlist', $udata);

编辑:

并且您的查询只返回一行,您可能希望更新您的数组,而不是覆盖它,所以类似于以下内容:

  $udata = $this->session->get_userdata('shortlist');
  foreach(...){
    // ...
    $udata []= $data;
  }
  $this->session->set_userdata('shortlist', $udata);
$this->session->set_userdata('shortlist', array($data));

不将$data追加到shortlist,而是用一个包含一个元素的数组覆盖它:$data中的当前数据
你可能(未经测试(想要:

if($query->num_rows > 0 ) {
    $data = array();
    foreach ($query->result() as $row)
    {
        // append the new "record" to the array $data
        $data[] = array(
            'id'      => $id,
            'name'    => $row->first_name." ".$row->surname,
            'location' => $row->location,
            'talent' => $row->talent,
            'image'  => $row->url
        );
    }
    $this->session->set_userdata('shortlist', $data);
    return TRUE;
}
else {
    ...