从视图中调用模型中的方法来运行SQL查询? [英] Call a method in model from view to run SQL query?

查看:86
本文介绍了从视图中调用模型中的方法来运行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屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆