显示 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.
相关文章