How to insert Data from textbox to MYSQL as HTML in PHP

Question

I am using: <textarea rows="24" name="thetext" cols="66"></textarea>

After submitting, I send it to MYSQL in a cell type (longtext)...

For example: I input:

Hello

world

All I get in the variable is helloworld(one word).. I need the line breaks..

I tried: $results = htmlentities($_POST[thetext]); and it is not working. How can I get it to show the line breaks please?

correct the implementation of text area like this <textarea rows="24" name="thetext" cols="66"></textarea> — krishna
– krishna, Commented Jan 29, 2014 at 10:47
have you tried $results =explode( "\r\n", $_POST['thetext'] ); — Priya jain
– Priya jain, Commented Jan 29, 2014 at 10:48
there is no <text area> in html only we have is <textarea> tag — krishna
– krishna, Commented Jan 29, 2014 at 10:50
why dont you post some more codes of html form and place where you read html form datas ? — krishna
– krishna, Commented Jan 29, 2014 at 10:53

Styphon · Accepted Answer · 2014-01-29 10:47:15Z

1

A textarea will send new lines using \n\r, you need to convert that to HTML before outputting it to a page using nl2br($myVar);

In this case if you do:

echo nl2br($_POST['thetext']);

you will get Hello world with the line breaks in.

answered Jan 29, 2014 at 10:47

Styphon

10.5k9 gold badges54 silver badges87 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

BASSEL Over a year ago

I wanted to vote for you, but they again did not allow me, as this is my second question, I am new here

krishna · Accepted Answer · 2014-01-29 11:02:17Z

0

correct the implementation of text area like this

<textarea rows="24" name="thetext" cols="66"></textarea>

and use

nl2br($_POST[thetext])

instead of

htmlentities($_POST[thetext])

edited Jan 29, 2014 at 11:02

answered Jan 29, 2014 at 10:48

krishna

4,0892 gold badges32 silver badges56 bronze badges

Comments

Farre · Accepted Answer · 2014-01-29 10:57:17Z

0

The easiest way is to change your rows/cells in the database to a ut8 collation charset. It should help you fix your problem.

Also the code I would use to send the form data to my database would be as follow:

$change_text = $_POST['thetext'];
$mysqli->query("YOUR_SQL_CODE");

And then to check if the data was sent correctly I would either access the row via the database directly or fetch the row like this:

if ($data = $mysqli->query("YOUR_SQL_CODE")) ;
$showtext = mysqli_fetch_row($data);
echo($showtext[0]);

answered Jan 29, 2014 at 10:57

Farre

363 bronze badges

Collectives™ on Stack Overflow

How to insert Data from textbox to MYSQL as HTML in PHP

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related