Codeigniter将数据从视图传递到模型 [英] codeigniter pass data from view to model
问题描述
我需要显示类别和子类别,现在我的模型是显示静态$ id,如您所见,我试图编写$ id = 4(仅用于测试),因此它仅显示$ id = 4的子类别每个类别。
i need to show category and sub category, my model right now is show static $id as you can see i attempted to write $id = 4 (for testing only), so it's only show subcategory where $id = 4 in every category.
public function get_subkriterias($id = 4)
{
$this->db->select('kriterias.nama as kriterias_nama, kriterias.id, sub_kriterias.id, sub_kriterias.nama, sub_kriterias.nilai');
$this->db->from('kriterias');
$this->db->join('sub_kriterias', 'kriterias.id = sub_kriterias.kriteria_id', 'LEFT');
$this->db->where('kriteria_id', $id);
$this->db->order_by('kriterias.id');
$query = $this->db->get();
return $query->result_array();
}
这是我的
控制器
this is my controller
public function index()
{
$data['kriterias'] = $this->subkriterias_model->tampil();
$data['sub_kriterias'] = $this->subkriterias_model->get_subkriterias();
$this->load->view('sub_kriterias/tampil', $data);
}
视图:
<?php foreach ($kriterias as $item) { ?>
<tr>
<td><?php echo $item['nama']; ?></td>
<td>
<table class="table">
<tbody>
<?php foreach ($sub_kriterias as $item) { ?>
<tr>
<td><?php echo $item['nama']?></td>
<td><?php echo $item['nilai'] ?></td>
我如何将数据从视图或任何地方传递给$ id,以便该模型可以动态检索$ id并最终只显示每个类别中正确的子类别?
how do i pass data from view or anywhere to $id so this model can retrieve $id dynamically and finally show only right subcategory in every category?
预先感谢
推荐答案
有几种方法可以执行此操作,这是一个使用ajax的非常有限的示例
There are a few ways you can do this, here is a very limited example using ajax
在您的控制器中:
public function index()
{
/**getting intial items only**/
$data['kriterias'] = $this->subkriterias_model->tampil();
$this->load->view('sub_kriterias/tampil', $data);
}
public function get_category()
{
/** id posted via ajax once user clicks category**/
$id = $this->input->post('id');
$sub_kriterias = $this->subkriterias_model->get_subkriterias($id);
echo json_encode($sub_kriterias);
exit();
}
在视图中,我们将列出以下项目:
In the view we'd have a list of items:
<select id= "categorey_select">
<? foreach($kriterias as $item):?>
<option name="selected_cat" value="<?=$item['id'];?>"><?=$item['nama'];?></option>
<?endforeach;?>
</select>
<!-- notice this table is empty for now-->
<table id="category_results">
</table>
这里,一旦单击类别,我们将使用jquery事件侦听器发送ajax请求(您可以将其添加到视图中或加载包含它的js脚本):
Here we would use a jquery event listener to send an ajax request once a category is clicked ( you can add this in the view or load a js script that contains it):
<script>
$("#categoery").change(function(){
var id = $(this).val();
$.ajax({
url: '/path/to_controller/get_category',
method: "POST",
data: {id: id},
success: function(resp){
/** use console/web tools to see the returned object's structure**/
/** here you would populate the empty table with the results **/
/** using empty to reset the table each time category changes**/
$("category_results").empty().append("<tr>...")
}
})
})
</script>
这篇关于Codeigniter将数据从视图传递到模型的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!