显示查询结果 [英] display result from a query

问题描述

我正在学习kohana 3.3.我正在模型部分.基本查询.但是我不知道如何显示我从查询中获得的结果.

I'm learning kohana 3.3. I'm working on the model part. Basic query. But i don't know how to display the results i got from a query.

这是模特.

APPPATH/classes/model/people.php

class Model_People extends Model {

    public function show_data() {
        $query = DB::query(Database::SELECT, 'SELECT * FROM people');
        return $query;
    }

}

APPPATH/classes/controller/people.php

class Controller_People extends Controller {

    public function action_index() {
        $model = Model::factory('people');
        $view = View::factory('base_template');
        $model->user = $model->show_data();
        $this->response->body($view);
    }

}

APPPATH/views/base_template.php

<?php 
    foreach($user as $row) {
        echo "<h2>".$row['Name']."</h2>";
    } 
?>

我不想使用ORM，我正在使用QUERY BUILDER.当我运行代码时，它说未定义变量用户.如何正确显示结果?谢谢.

I don't want to use ORM I'm using QUERY BUILDER. When I run the code it says variable user not defined. How do I display the results correctly? thanks.

推荐答案

尝试一下

class Controller_People extends Controller {

    public function action_index() {
        $model = Model::factory('people');

        $view = View::factory('base_template');
        $view->user = $model->show_data();

        $this->response->body($view);
    }
}

然后在视图中循环

<?php 
    foreach($user as $row) :
        echo "<h2>".$row['Name']."</h2>";
    endforeach; 
?>

这篇关于显示查询结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！