如何从存储过程动态选择所有列 [英] How to select all columns dynamically from stored procedure
问题描述
亲爱的朋友们,
如何从codeigniter中的存储过程中动态选择所有列。我打电话是这样的:它不工作
我尝试过:
模态:
$ query = $ this-> db-> query(CALL chef_allProducts());
返回$ query;
查看:
foreach($ field-> result()为$ row):
echo $ row;
endforeach;
控制器:
$ data ['field'] = $ this-> Excelex-> get_field();
$ this-> load-> view('excel',$ data);
Dear Friends,
How to select all columns dynamically from stored procedure in codeigniter. I called like this: its not working
What I have tried:
Modal:
$query = $this->db->query(CALL chef_allProducts());
return $query;
View:
foreach($field->result() as $row ):
echo $row;
endforeach;
Controller:
$data['field'] = $this->Excelex->get_field();
$this->load->view('excel', $data);
推荐答案
query =
this-> db->查询(CALL chef_allProducts());
return
this->db->query(CALL chef_allProducts());
return
query;
查看:
foreach(
query;
View:
foreach(
这篇关于如何从存储过程动态选择所有列的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!