代码点火器: this->datatables->select(sample)->from(sample)->where()
请帮帮我。我不能正确地使用我的dataTable。我想做的是
select from table and use the，其中function.但我做得不好。
这是我的控制器代码
public function reporttable ()
{
$zz = array('empnumber' => $this->input->post('empnumber'));
//$this->db->order_by("surname", "asc");
$this->datatables->select('date_auto,particulars,earned_VL,aul_VL,balance_VL,aulx_VL,earned_SL,aul_SL,balance_SL,aulx_SL,date_leave,action_taken')
->from('tblreport')->where($zz);
echo $this->datatables->generate();
}这是我应该问的问题：
从tblreport中选择* empnumber =(我的文本框中的空号)。
在那里，我从文本框中得到一个值到我的视图。但没起作用。我知道这是不对的。你能帮我解决我的问题吗？谢谢。
<p align="center"> <?php echo $this->table->generate();?></p></div>
<?php foreach ($tblemployee as $row){?>
<input type="text" name="empnumber" readonly="readonly" value="<?php echo $row->empnumber;?>"/>
<input type="hidden" name="empnumber" value="<?php echo $row->empnumber;?>"/>这是我对导游的看法。谢谢。
回答 3
Stack Overflow用户
发布于 2015-06-08 07:35:45
只要你能用的简单
在控制器中
$data['tblemployee'] = $this->model_name->reporttable($id)//assign your data base value to variable
$this->load->view('your view name',$data )在模型中
public function reporttable($id)
{
$query = $this->db->query("select * from tblreport where empnumber = '$id'");
$result = $query->result_array();
return $result; // this will return your data as array
}在视图中
<?php
foreach ($tblemployee as $row)
{
echo $row['id];
}?>Stack Overflow用户
发布于 2015-06-09 02:40:52
试试这个：
让它变得更简单。
在模型中：
public function reporttable ($id){
$this->db->select('*');
$this->db->from('tblreport');
$this->db->where('empnumber', $id);
$query = $this->db->get();
return $query->return_array(); // use this if so want to return many query if not you can also use first_row('array')
}在主计长：
public function function_name (){
$data['variable_name'] = $this->model_name->reporttable($id); // change the model_name by your own model where your function reporttable is located and use the variable_name for your view,
$this->load->view('view_name' , $data); // load the view page you want to display.
}Stack Overflow用户
发布于 2016-12-15 07:16:02
在控制器中
$data['tblemployee'] = $this->model_name->reporttable($id)//assign your data base value to variable $this->load->view('your view name',$data )
在模型中
public function reporttable($id) { $query = $this->db->query("select * from tblreport where empnumber = '$id'"); $result = $query->result_array(); return $result; // this will return your data as array }
在视图中
<?php foreach ($tblemployee as $row) { echo $row['id]; }?>
https://stackoverflow.com/questions/30703047
复制相似问题
腾讯云开发者
