如何从mysql中逃避PHP中的空格和中断-howtoescapespacesandbreaksinphpfrommysql

When I fetch data from my database to my php. I get and when I check it's source it looks something like this:

当我从我的数据库中获取数据到我的PHP。我得到了,当我检查它的来源时它看起来像这样:

  
 AFGHANISTAN`

in the value field you can see there is space after AF. Now the problem which occurs here is that these space are not in database and i want to skip these spaces and this is not even in my php code. Well they could be in my database but I want to skip them or delete them from database.

在值字段中,您可以看到AF后有空格。现在这里出现的问题是这些空间不在数据库中,我想跳过这些空格,这甚至不在我的PHP代码中。好吧,他们可能在我的数据库中,但我想跳过它们或从数据库中删除它们。

Here is my code

• > 

这是我的代码

• ” > 

3 个解决方案

#1

---

1  

You can use TRIM(BOTH ' \r\n\t' FROM [the column name]) when you select your data to remove bogus endings and beginnings.

当您选择数据以删除虚假结尾和开始时,您可以使用TRIM(BOTH'\ r \ n \ t'FIN [列名称])。

In PHP you can just use trim(), as it already also removes tabs, newlines and such.

在PHP中你可以使用trim(),因为它已经删除了标签,换行符等。

If you clean up those fields in the database you also should look for breaks inside the strings and kill them with REPLACE :)

如果你清理数据库中的那些字段,你也应该在字符串中寻找断点并用REPLACE杀死它们:)

#2

---

0  

Have you tried

你有没有尝试过

trim($value)

Also some code would be helpful

一些代码也会有所帮助

#3

---

0  

You could use regular expressions to find the content between the double quotes then remove the spaces from the contents? I would suggest trim as Jim did, but that is for white space at the beginning and end of a string.

您可以使用正则表达式查找双引号之间的内容,然后从内容中删除空格?我会建议像Jim那样修剪,但那是在字符串的开头和结尾处的空白区域。