Php submits textarea data to mysql with many spaces

This article describes how php submits textarea data to mysql to solve the problem of many spaces. it analyzes the causes of spaces and the simple implementation skills for deleting spaces, which is of great practical value, for more information about how php submits textarea data to mysql, see the example below. Share it with you for your reference. The specific analysis is as follows:

Some may find that there are a lot of spaces when we read data from mysql again after html is submitted to php for processing and saving data to mysql, so if we can see that there is no space in mysql, what is the problem.

Textarea always has a lot of space issues to solve

Problem description:

There is always a lot of space at the end of the header when php reads mysql data to textarea. there is no space in the data table.

Cause:

The content should be written in the format of textarea. do not have time and line feed after textarea.

Solution:

The code is as follows:

The code is as follows:

<? Php
Echo str_replace ('','', 'AB AB ');
// Output "abab'
?>

Or use

The code is as follows:

<? Php
Echo strtr ('AB AB', array (''=> ''));
// Output "abab"
?>

Supplement:

The line break in php textarea is "\ r \ n"

Not '\ n'

No"
"

Not '\ r \ n'

Not '\ r' +' \ n'

I hope this article will help you with PHP programming.