codeigniter查询控制器视图 [英] codeigniter query controller view

问题描述

我有两个表格： -
tbl_ticket_categories（id，category_name，site_referer）

code> tbl_tickets（id，title，category_name，site_referer）

我必须从相应category_name的tbl_tickets获得所有标题site_referer = 1。

假设tbl_ticket_categories： -

 
 id |类别| site_referer 
 1 | cat1 | 1 
 2 | cat2 | 1 
 3 | cat1 | 2 
 4 | cat3 | 3 
 5 | cat1 | 1 
 

tbl_tickets

 
 id |标题| category_name | site_referer 
 1 | title1 | cat3 | 3 
 2 | title2 | cat1 | 2 
 3 | title3 | cat1 | 1 
 4 | title4 | cat2 | 1 
 5 | title5 | cat1 | 1 
 

输出： -
cat1： - title3，title5

cat2： - title 4

我没有问题，但我不知道如何安排，我的逻辑在控制器部分是错误的。 p>

我所做的是： -

  function categorizedTickets 
 $ categories = $ this-> helpdesk_model-> getCategories（$ this-> site_referers_id）; 
 foreach（$ categories-> result_array（）as $ value）{
 $ title = $ this-> helpdesk-> model（$ value ['category_name']）; 
} 
} 
  

但此功能在显示输出时无用

解决方案

  SELECT tbl_ticket_categories.category，CONCAT tbl_tickets.title，'，'）AS title 
从tbl_ticket_categories 
 JOIN tbl_tickets ON tbl_ticket_categories.category = tbl_tickets.category_name 
在哪里tbl_ticket_categories.site_referer =？ 
  

...不使用活动记录 - 它不工作。

I have two tables :- tbl_ticket_categories(id,category_name,site_referer)

tbl_tickets(id,title,category_name,site_referer)

I have to get all title from tbl_tickets of their corresponding category_name having site_referer = 1.

suppose tbl_ticket_categories :-

id | category | site_referer
1  | cat1     | 1
2  | cat2     | 1
3  | cat1     | 2
4  | cat3     | 3
5  | cat1     | 1

tbl_tickets

id | title  | category_name | site_referer
1  | title1 | cat3          | 3 
2  | title2 | cat1          | 2
3  | title3 | cat1          | 1
4  | title4 | cat2          | 1
5  | title5 | cat1          | 1

output :- cat1 :- title3, title5

cat2 :- title 4

I don't have problem in querying this but I dont know how to arrange that, my logic in controller part is going wrong.

What I am doing this is :-

function categorizedTickets() {
    $categories = $this->helpdesk_model->getCategories($this->site_referers_id);
    foreach($categories->result_array() as $value) {            
        $title = $this->helpdesk->model($value['category_name']);
    }
}

but this function is not useful in displaying the output in the way what I am supposed to do.

解决方案

SELECT tbl_ticket_categories.category, CONCAT(tbl_tickets.title, ', ') AS title
FROM tbl_ticket_categories
     JOIN tbl_tickets ON tbl_ticket_categories.category = tbl_tickets.category_name
WHERE tbl_ticket_categories.site_referer = ?

... don't use Active Record - it won't work.

这篇关于codeigniter查询控制器视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！