显示 SQL 结果时 nl2br() 不起作用

nl2br() not working when displaying SQL results(显示 SQL 结果时 nl2br() 不起作用)

问题描述

在我的 Joomla 模块上，我们使用以下代码从数据库中获取喊声

On my Joomla module, we are using the following code to get shouts from the database

function getShouts($number, $timezone, $message) {
    $shouts = array();
    $db = JFactory::getDBO();
    $query = $db->getQuery(true);
    $query->select('*')
    ->from('#__shoutbox')
    ->order('id DESC');
    $db->setQuery($query , 0 , $number);
    $rows = $db->loadObjectList();
    $i=0;
    foreach ( $rows as $row ) {
        $shouts[$i]->id = $row->id;
        $shouts[$i]->name = $row->name;
        $shouts[$i]->msg = $row->msg;
        $i++;
    }
    return $shouts;
}

和下面的代码显示在default.php

print stripslashes($shouts[$i]->msg);

然而，当有人想要输入如下内容时，这会导致问题:

However this is causing problems when someone wants to input something like the following:

test line 1
test line 2

如果他们换行，则帖子在提交后显示如下:

If they go onto a new line, the post displays like so after being submitted:

test line 1rntest line 2

所以我做了一些研究并意识到我必须使用 nl2br() ，我做了如下所示:

So I did some research and realised I had to use nl2br() which I did as shown below:

print stripslashes(nl2br($shouts[$i]->msg));

然而，它似乎并没有解决问题.我还尝试在 helper 中创建另一个函数以使用 preg_replace 替换它，但这也无济于事.

however, it didn't seem to resolve the issue. I also tried creating another function in the helper to replace it using preg_replace but this didn't help either.

谁能解释为什么在添加 nl2br() 后换行不起作用以及如何修复它?

Can anyone explain why line breaking isn't working after adding nl2br() and how to fix it?

推荐答案

试试这个:

print nl2br(stripcslashes($shouts[$i]->msg));

注意 stripcslashes() 函数，而不是 stripslashes()

Pay attention to the stripcslashes() function, but not stripslashes()

或者只是:

print nl2br($shouts[$i]->msg);

UPD: nl2br() 函数将 替换为
.问题是您的文本中没有 ，但有 n 或 \n.我认为从 base 获取数据时没有必要使用 stripslashes() ，除非你在 base 中删除了数据.

UPD: nl2br() function replaces with <br />. The problem is that you don't have in your text, but have n or \n. I think there is no need to use stripslashes() when you get data from base, except the situation when you have ecranized data in your base.

这篇关于显示 SQL 结果时 nl2br() 不起作用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！