Php submits textarea data to mysql with many spaces. textareamysql_PHP tutorial

Php submits textarea data to mysql. the solution is textareamysql. Php submits textarea data to mysql with many spaces. This document describes how php submits textarea data to mysql with many spaces. To solve the problem of submitting textarea data to mysql with many spaces, textareamysql

This example describes how php submits textarea data to mysql with many spaces. 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.

Examples in this article describes how php submits textarea data to mysql with many spaces. Share...