这个“消息:未定义的属性:stdClass”是什么意思


What does this "Message: Undefined property: stdClass" mean?

我是codeigniter和php的新手,我现在遇到了这个错误,我不知道我哪里出错了。我应该在我的书上添加一些东西吗?上次我遇到的是一个未定义的属性,由于我的模型中拼写错误的单词而解决了,现在是 stdClass?这次没有单词拼写错误。有人可以启发我解决这个问题吗?

错误:

遇到 PHP 错误

严重性:通知

消息:未定义的属性:标准类::$blockcode

文件名:视图/v_schedule.php

行号:10

景观: v_schedule.php

<?php foreach ($query as $row){ ?>

                       <?php echo $row->blockcode;?> <br>
                       <?php echo $row->subjectcode;?> <br>
                       <?php echo $row->daystart;?> <br>
                       <?php echo $row->dayend;?>   <br>
                       <?php echo $row->stime;?>    <br>
                       <?php echo $row->sday;?> <br>
                       <?php echo $row->instructorname;?>   <br>
                       <?php echo $row->instuctorlastname;?>    <br>
                       <?php echo $row->roomcode;?> <br>
                       <?php echo $row->building;?> <br>
        <?php } ?>  

控制器:c_test.php

 function getSchedule() {
       $data['query'] = $this->m_test->result_getSchedule();
       $this->load->view('v_schedule',$data);
 }

型号: m_test.php

function result_getSchedule()
    {
        $this->db->select('grades.studentid', 'grades.blockcode', 'subjectblocking.subjectcode','subjectblocking.daystart','subjectblocking.dayend', 'subjectblocking.stime','subjectblocking.sday','instructorinfo.firstname', 'instructorinfo.lastname', 'subjectblocking.roomcode','room.building');
        $this->db->from('grades');
        $this->db->join('subjectblocking', 'grades.blockcode=subjectblocking.blockcode');
        $this->db->join('instructorinfo', 'subjectblocking.instructorid=instructorinfo.instructorid');
        $this->db->join('room', 'subjectblocking.roomcode= room.roomcode');
        $this->db->distinct();
        $this->db->where('studentid', '2013-F0218');
        $query=$this->db->get();
        return $query->result();
    }

你犯了一个错误

$this->db->select('grades.studentid', 'grades.blockcode', 'subjectblocking.subjectcode','subjectblocking.daystart','subjectblocking.dayend', 'subjectblocking.stime','subjectblocking.sday','instructorinfo.firstname', 'instructorinfo.lastname', 'subjectblocking.roomcode','room.building');
//this is is not right way codeigniter select.
//it only selects studentid
//blockcode is not seleted that's why you got that error

这是正确的方式

 $this->db->select('grades.studentid , grades.blockcode , subjectblocking.subjectcode , subjectblocking.daystart , subjectblocking.dayend , subjectblocking.stime , subjectblocking.sday , instructorinfo.firstname , instructorinfo.lastname ,  subjectblocking.roomcode , room.building');

希望这将解决您的问题

成绩和主题阻塞表中有两个块码列。

你应该像这样m_test.php更改你的sql:

 $this->db->select('grades.studentid', 'grades.blockcode as block_code', 'subjectblocking.subjectcode','subjectblocking.daystart','subjectblocking.dayend', 'subjectblocking.stime','subjectblocking.sday','instructorinfo.firstname', 'instructorinfo.lastname', 'subjectblocking.roomcode','room.building');

您应该在 v_schedule.php 中将$row->块代码变量更改为 $row->block_code

希望对您有所帮助。

首先,我也使用了上面的代码,我得到了同样的错误。

$this->db->select('grades.studentid', 'grades.blockcode as block_code', 'subjectblocking.subjectcode','subjectblocking.daystart','subjectblocking.dayend', 'subjectblocking.stime','subjectblocking.sday','instructorinfo.firstname', 'instructorinfo.lastname', 'subjectblocking.roomcode','room.building');

但通过改变

$this->db->select('grades.studentid, grades.blockcode as block_code, subjectblocking.subjectcode,subjectblocking.daystart,subjectblocking.dayend, subjectblocking.stime,subjectblocking.sday,instructorinfo.firstname, instructorinfo.lastname, subjectblocking.roomcode,room.building');

我解决了错误。

如果我们能为grades.studentid提供一个单一的名称作为studentID那么我们可以直接调用:

echo $query->studentID;