如何在代码点火器中提取一行? [英] How to extract one single row in code igniter?

问题描述

有人可以告诉我如何通过模型(返回一行)从数据库中提取数据时如何将其传递给视图:

Can someone show me how to pass data to the a view when it's extracted from the database via the model (which returns a single row) :

我的示例代码

function read_article($article_name)
{
    $data['row'] = $this->user_model->extract_article($article_name);
    $this->load->view('user/view_article',$data);
}
  // controller code ^^^^^^^^^
function extract_article($article_name)
{
    $data = array();
    $this->db->select('col1,col2,col3,col4');
    $query = $this->db->get_where('table_name',array('col4'=>$article_name))->result();
    foreach($query as $s)
    {
        $data[] = $s;
    }
    $data;
}

//型号代码^^^^^^^^^^^

// model code ^^^^^^^^^^

foreach($row as $r)
{
echo "<h1>".$r->col2."</h1>";
echo "<p>".$r->col3."</p>";
}

//查看代码^^^^^^^^^^

// view code ^^^^^^^^^

遇到PHP错误

严重性:警告

消息:为foreach()提供了无效的参数

Message: Invalid argument supplied for foreach()

文件名:user/view_article.php

Filename: user/view_article.php

行号:52

推荐答案

RTM

$query = $this->db->query("YOUR QUERY");

if ($query->num_rows() > 0)
{
   $row = $query->row(); 

   echo $row->title;
   echo $row->name;
   echo $row->body;
} 

这篇关于如何在代码点火器中提取一行?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！