如何将数据库查询结果存储在视图中的变量中

Question

I want to store my database query result in my view section in a variable.I am trying but not work.

My View code

$cd=''.base_url().'/video/series/';
$count = count($cd);
for ($i = 0; $i < $count; $i++) 
{
  print'"'.$cd[$i][1].'",';  

}

My Controller code

public function series() {

    $result= $this->video_model->series_list();

    return $result;


}

My Model Code

function series_list()
{

    $string = trim($this->input->get_post('term'));
    $query = $this->db->query("SELECT name FROM `series` WHERE name LIKE '%".$string."%'");


    return $query->row_array();

}

$cd=''.base_url().'/video/series/'; not get any array data ,only get blank data

Answer 1

You can get post variable value in controller only. But you trying to get it in model. That's wrong.

Controller:

public function series() {
$string = trim($this->input->get_post('term'));    
$data['result']= $this->video_model->series_list($string);
$this->load->view('folder/filename', $data);  
// in your case i think folder= video and filename = series
// in this way you can pass value from controller to view

}

Model:

function series_list($string = null)
{
    if($string != ''){
       $query = $this->db->query("SELECT name FROM `series` WHERE name LIKE '%".$string."%'");
       return $query->row_array();
    }
    else
       return false;
}

View:

<?php
 var_dump($data);
?>

you can get your resultset in view and can play with it as you want.