如何在html表格中显示原始的sql查询输出 [英] How to display raw sql query output in html table

问题描述

  + --------- 
在Laravel中通过原始SQL查询生成下面的表： -  + ------- + ------- + 
 |产品|价格|商店| 
 + ---------- + ------- + ------- + 
 |夹克| 300.0 | Shop1 | 
 | T恤| 300.0 | Shop1 | 
 |夹克| 500.0 | Shop2 | 
 |鞋子| 200.0 | Shop2 | 
 + ---------- + ------- + ------- + 
  

不知道如何循环浏览这些数据，所以我在浏览器中得到如下结果：

  + --------- + ------- + ------- + 
 |产品| Shop1 | Shop2 | 
 + --------- + ------- + ------- + 
 |夹克| 300.0 | 500.0 | 
 | T恤| 300.0 | NULL | 
 |鞋子| NULL | 200.0 | 
 + --------- + ------- + ------- + 
  

解决方案

尝试使用

  SELECT a。产品，
（SELECT max（b.price）
 FROM yourtable b 
 WHERE b.product = a.product 
 AND b.shop ='Shop1'）shop1，
（SELECT max（c.price）
 FROM yourtable c 
 WHERE c.product = a.product 
 and b.shop ='Shop2'）shop2 
 FROM yourtable a通过a.product 
  

来分组

I have the following table generate by raw SQL query in Laravel:

+----------+-------+-------+
| Products | Price | Shop  |
+----------+-------+-------+
| Jacket   | 300.0 | Shop1 |
| T-Shirt  | 300.0 | Shop1 |
| Jacket   | 500.0 | Shop2 |
| Shoes    | 200.0 | Shop2 |
+----------+-------+-------+

Have no idea how to loop through this data, so I get result like this in browser:

+---------+-------+-------+
| Product | Shop1 | Shop2 |
+---------+-------+-------+
| Jacket  | 300.0 | 500.0 |
| T-Shirt | 300.0 | NULL  |
| Shoes   | NULL  | 200.0 |
+---------+-------+-------+

解决方案

Try to use

    SELECT a.product, 
       (SELECT max(b.price) 
        FROM   yourtable b 
        WHERE  b.product = a.product 
               AND b.shop = 'Shop1') shop1, 
       (SELECT max(c.price) 
        FROM   yourtable c 
        WHERE  c.product = a.product 
               AND b.shop = 'Shop2') shop2 
FROM   yourtable a group by a.product

这篇关于如何在html表格中显示原始的sql查询输出的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！