How to run MySQL Query which has multiple lines in PHP?

Question

How do you run a query like the following in PHP:

INSERT INTO table VALUES ('example name', 'thisisfirstline
           thisissecondline
           thisisthirdline')

I have type set to text.

I have no problems at all when I run it with Navicat. I tried running it in PHP:

mysql_query("INSERT INTO table VALUES ('example name', 'thisisfirstline
           thisissecondline
           thisisthirdline') 
           OR die('ERROR');

This outputs the following:

thisisfirstlinethisissecondlinethisisthirdline

How do I insert the value without sticking it all together?

Probably this new row in mysql has newline characters, but your client does not show them correct way. Try to use mysql console to be shure - what exactly is in database. — Ilia Kondrashov
– Ilia Kondrashov, Commented Feb 8, 2014 at 12:31

Alireza Fallah · Accepted Answer · 2014-02-08 12:30:16Z

1

Put \n for inserting newline in a MySQL table :

INSERT INTO table VALUES ('example name', 'thisisfirstline\n
    thisissecondline\n
    thisisthirdline')

answered Feb 8, 2014 at 12:30

Alireza Fallah

4,6074 gold badges34 silver badges58 bronze badges

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

Comments

Alireza Fallah · Accepted Answer · 2014-02-08 12:45:35Z

0

make the type to varchar instead of text in table

edited Feb 8, 2014 at 12:45

Alireza Fallah

4,6074 gold badges34 silver badges58 bronze badges

answered Feb 8, 2014 at 12:32

vignesh pbs

4582 gold badges5 silver badges17 bronze badges

Collectives™ on Stack Overflow

How to run MySQL Query which has multiple lines in PHP?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related