我是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;