doutang6600 2017-08-17 05:00
浏览 53
已采纳

Codeigniter中控制器的回显/打印查询结果

I am trying to display my Model query return result in my controller, but I don't know how to do it. could you please show me? Thanks in advance

Controller:

function updateJobsheetCDC()
    {
        $prnID = $this->input->post('prnID');

        $this->load->model('Ipss_model');
        $data['prnEmail'] = $this->Ipss_model->prnEmailList($prnID);

        echo $data['prnEmail']['name'];
    }

Model:

function prnEmailList($prnID)
    {
        $q = $this->db->query("SELECT pm.* , prm.*,e.* from  principal_master pm ,principal prm,email e where pm.prnID=e.prnID and prm.prID= pm.prID and e.prnID='" .$prnID."'");

        if($q->num_rows()>0) {
          foreach($q ->result() as $row) 
          {
             $data[] = $row;    
          }
          return $data;
        }       
    }

I have tried echo $data['prnEmail']['name']; but it do not work. It shows Severity: Notice

Message: Undefined index: name.

  • 写回答

1条回答 默认 最新

  • douhe6181 2017-08-17 05:05
    关注

    You have multi-dimentinal array returning from model. So you have to loop over them then print data

    function updateJobsheetCDC()
    {
        $prnID = $this->input->post('prnID');
    
        $this->load->model('Ipss_model');
        $data = $this->Ipss_model->prnEmailList($prnID);
        foreach ($data as $key => $value) {
          echo $value->name; 
        }
    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 MATLAB怎么通过柱坐标变换画开口是圆形的旋转抛物面?
  • ¥15 寻一个支付宝扫码远程授权登录的软件助手app
  • ¥15 解riccati方程组
  • ¥15 display:none;样式在嵌套结构中的已设置了display样式的元素上不起作用?
  • ¥15 使用rabbitMQ 消息队列作为url源进行多线程爬取时,总有几个url没有处理的问题。
  • ¥15 Ubuntu在安装序列比对软件STAR时出现报错如何解决
  • ¥50 树莓派安卓APK系统签名
  • ¥65 汇编语言除法溢出问题
  • ¥15 Visual Studio问题
  • ¥20 求一个html代码,有偿