将查询结果传递给视图(Codeigniter 2)


passing query results to view (Codeigniter 2)

我正在学习Codeigniter 2的教程。不幸的是,我不能让样品工作。我收到错误:

遇到PHP错误

严重性:注意

消息:未定义变量:text1

文件名:视图/content_home.php

行号:14

控制器:

public function home()
    {
        $this->load->model('model_get');
        $data['results'] = $this->model_get->getData('home');
        $this->load->view('site_header');
        $this->load->view('site_nav');
        $this->load->view('content_home', $data);
        $this->load->view('site_footer');
    }

Content Page/View:

<div id="content">
        <?php
        foreach($results as $row) {
            $title = $row->title;
            $text1 = $row->text1;
            $text2 = $row->text2;
        }
        ?>
        <h1>Home Page von Milstink</h1>
        <p><?php echo $text1; ?></p>
        <p><?php echo $text2; ?></p>

    </div>

模型:

<?php
class Model_get extends CI_Model {
    public function getData($page)
    {
        $query = $this->db->get_where('pageData', array('page' => '$page'));
        return $query->result();
    }
}

有人能帮忙吗?

似乎$text1不存在。将模型中的'$page'改为$page

class Model_get extends CI_Model {
public function getData($page)
 {
    $query = $this->db->get_where('pageData', array('page' => $page));
    return $query->result();
 }
}

在模型代码中将是

<?php

类Model_get扩展CI_Model {

public function getData($page)
{
    $query = $this->db->get_where('pageData', array('page' => $page));
    return $query->result();
}

}

在'$page'的比较数据库中没有符合此条件的数据,因此返回空行。