duanniu3385 2018-06-05 11:50
浏览 120
已采纳

foreach循环只显示codeigniter中的最后一条记录,并获取5分钟后记录的活动记录

Hi all i am trying to get active session users in codeigniter.So i am storing all my sessions in database and table name called ci_sessions and i got user data from ci_sessions table and i am trying to get user_name from data through foreach but i am getting only last active user.

Here is my code:

<?php
$query = $this->db->query('SELECT * FROM ci_sessions');

foreach ($query->result() as $row) {
    $session_data = $row->data;

    $return_data = array();  // array where you put your "BLOB" resolved data

    $offset = 0;
    while ($offset < strlen($session_data)) 
    {
        if (!strstr(substr($session_data, $offset), "|")) 
        {
            throw new Exception("invalid data, remaining: " . substr($session_data, $offset));
        }
        $pos = strpos($session_data, "|", $offset);
        $num = $pos - $offset;
        $varname = substr($session_data, $offset, $num);
        $offset += $num + 1;
        $data = unserialize(substr($session_data, $offset));
        $return_data[$varname] = $data;  
        $offset += strlen(serialize($data));
    }    
}
echo $return_data['user_name'];

?>

Can anyone help me where i did mistake.

Thanks in advance.

  • 写回答

1条回答 默认 最新

  • dongxiaoyan4388 2018-06-05 11:55
    关注

    A small mistake you have done

    <?php
    $query = $this->db->query('SELECT * FROM ci_sessions');
    $return_data = array();  // array where you put your "BLOB" resolved data
    foreach ($query->result() as $row) {
       $session_data = $row->data;
    
       $offset = 0;
       while ($offset < strlen($session_data)) 
        {
           if (!strstr(substr($session_data, $offset), "|")) 
            {
              throw new Exception("invalid data, remaining: " . substr($session_data, $offset));
            }
              $pos = strpos($session_data, "|", $offset);
              $num = $pos - $offset;
              $varname = substr($session_data, $offset, $num);
              $offset += $num + 1;
              $data = unserialize(substr($session_data, $offset));
              $return_data[$varname][] = $data;  
              $offset += strlen(serialize($data));
          }
    
          }
         var_dump( $return_data['user_name'][0] );
    
         foreach($return_data['user_name'] as $onesession) {
              echo $onesession;
              echo '<br>';
         }
    
    ?>
    

    $return_data = array(); I moved it out of foreach loop

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 求chat4.0解答一道线性规划题,用lingo编程运行,第一问要求写出数学模型和lingo语言编程模型,第二问第三问解答就行,我的ddl要到了谁来求了
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥15 maple软件,用solve求反函数出现rootof,怎么办?
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿
  • ¥100 关于使用MATLAB中copularnd函数的问题
  • ¥20 在虚拟机的pycharm上
  • ¥15 jupyterthemes 设置完毕后没有效果