从视图中调用模型中的方法来运行SQL查询? [英] Call a method in model from view to run SQL query?
本文介绍了从视图中调用模型中的方法来运行SQL查询?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
循环遍历值数组时,需要对数据库执行检查。
我尝试过:
查看: kanban_v1.php
While looping through an array of values, there is a check that needs to be performed against the database.
What I have tried:
View: kanban_v1.php
<html>
<head>
<title>Kanban</title>
</head>
<body>
<table border=1>
<?php
$maxrowspan = 0;
$tmp_level1_parent_columns = array();
$level1 = array();
$level2 = array();
$level3 = array();
foreach ($level1_parents as $row)
{
$parent_colspan = 0;
//1. Insert parent columns; for looping
array_push($tmp_level1_parent_columns, $row->child_id);
//2. START FOREACH LOOP { Select child columns from P&C where parent_id = current_index <---- NEEDS TO QUERY DATABASE
//SELECT child_id FROM parent_child_columns WHERE parent_id = $current_parent_id;
$tmp_children = array();
//3. Identify level of each child from tmp_children:
//$level = SELECT COUNT(parent_id) FROM parent_child_columns WHERE parent_id = $current_parent_id (or $row->child_id);
//4. If $level > $maxrowspan, set $maxrowspan = $level.
//5. If ($level == 2) { array_push($level2, $row->child_id => $level); }
//5. If ($level == 3) { array_push($level3, $row->child_id => $level); }
//} END OF FOREACH LOOP
//6. Insert parent column into $level1. array_push($level1, $row->child_id => count($tmp_children))
}
echo count($level1_parent_columns);
?>
</table>
</body>
</html>
控制器: table.php
Controller: table.php
<?php
class table extends CI_Controller {
function index()
{
$this->load->model('kanbandb');
$data['level1_parents'] = $this->kanbandb->getLevel1Parents(1);
$this->load->view('kanban_v1', $data);
}
}
?>
型号:
Model:
<?php
class kanbandb extends CI_Model {
function getLevel1Parents($board_id)
{
$sql = " SELECT *
FROM parent_child_columns
WHERE board_id = {$board_id}
AND parent_id = 0
";
$query= $this->db->query($sql);
$result = $query->result();
$result_count = $query->num_rows();
return $result;
}
}
?>
推荐答案
maxrowspan = 0 跨度>;
maxrowspan = 0;
tmp_level1_parent_columns = array();
tmp_level1_parent_columns = array();
level1 = array();
level1 = array();
这篇关于从视图中调用模型中的方法来运行SQL查询?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文