html - 将 MYSQL 选择查询输出转换为 HTML 格式

Question

请参阅下面提到的查询，我在 mysql 中以表格输出格式获得该查询。我想将此查询输出更改为 html 格式，该怎么做？我是 Mysql 新手。

    SELECT StoreName,
        StoreCode AS `Code`,
        LogoUrl,
        BusinessStart AS `Starting Time`,
        BusinessEnd AS `Closing Time`,
        ClosedOn AS `Closed Days`,
        MinOrderPrice AS `Minimum Order Price`,
        DeliveryCharges AS `Delivery Charges`,
        PackingTime AS `Packing Time`,
        Validity AS `Validity`,
        PhoneNumber AS `Contact Number`,
        ZipCode AS `Post Code`,
        Floor AS `Street`,
        Line1 AS `Line`,
        Line2 AS `County`,
        Line3 AS `Land Line`,
        CONCAT(c.Code, ' - ' ,c.Symbol) AS `Currency`
    FROM store s INNER JOIN currency c ON c.CurrencyId = s.CurrencyId
    WHERE StoreId = 4;

Answer 1

Vijay，鉴于您对 mysql 不熟悉的评论，我同意上面 halfer 和 Alex 的观点，即您应该使用辅助语言来解析这些结果并输出 html。现在，无论出于何种原因您需要将结果集转换为 HTML，我的最佳猜测和建议如下下面的例子

SELECT 
      CONCAT("<div>",
           GROUP_CONCAT(
                CONCAT("<span>",username,"</span><br/>"),
                CONCAT("<span>",email,"</span>")
           )
      ,"</div>")  AS html FROM users;

这将返回一个包含以下内容的字符串:

<div><span>username</span><br/><span>email@email.com</span></div>

如果这是您想要实现的目标，那么上面的示例将帮助您走上正确的道路，以任何您喜欢的方式格式化您的结果，并在中间插入 html。