如何覆盖具有“&"字样的文本在HTML中
问题描述：
我的问题很有趣
我有一些数据存储在数据库中
如文字
我和你
他们和他
美国印度
作为单个文本
当我获取数据时
并在
中显示相同的内容
页面
在&"
之后被修整
正在得到我，他们，美国
等等.
这必须归因于与& nbsp;匹配的语法.
我该如何解决这个问题.
[edit]添加了HTML编码-OriginalGriff [/edit]
My problem is very interesting
I have some data stored in database
as text like
I & YOU
THEY & HE
AMERICA & INDIA
as Single Text
when I am fetching the data
and showing the same in
page
its getting trimmed after the "&"
Am getting I ,THEY,AMERICA
and so on .
This Must be due to the syntax matching with .
How can I solve this issue.
[edit]HTML encode added - OriginalGriff[/edit]
答
Vivek，
您确定显示的数据已存储在数据库中吗?实际上，如果您的数据库列是varchar，则必须另存为&以便正确存储和检索.
只需在SSMS的表中编写select * from table(如果使用SQL)并检查.
-Milind
Vivek,
Are you sure the data is stored in the database as you are showing. Actually if your database column is varchar, then you have to save as & for it to store correctly and retrieve.
Just write select * from table in SSMS (if using SQL) and check.
-Milind
Ampersand是HTML中的特殊字符-它引入了一个序列，因此& lt;"例如，显示为<"和&>"作为> -否则您的文本将被浏览器作为标签处理.
根据存储字符串所用的语言，您可以(并且应该)对字符串进行HTML编码，然后再存储它们-否则您的站点很容易受到HTML注入攻击的攻击，并会错误地显示数据.
您没有说您使用什么，所以我们什么也没建议！
Ampersand is a special character in HTML - it introduces a sequence so that "<" for example, is shown as a "<", and ">" as a > - otherwise your text would be processed as a tag by the browser.
Depending on what language you used to store the strings, you could (and should) HTML encode them before you store them - otherwise your site could well be vulnerable to an HTML Injection attack, as well as displaying the data incorrectly.
You don''t say what you use, so we can''t suggest anything!