Put linebreaks in a php-string and write everything correctly in MySQL-DB

Question

I try to generate a string with linebreaks, which I want to save in a MySQL-DB

//get some data
while($data = $anything->fetch(PDO::FETCH_OBJ))
    $result .= $data->field.'\r\n';
}

$update = $paed_db->prepare('UPDATE table SET anything = :result WHERE id = :id');
$update->bindParam(':id', $id, PDO::PARAM_INT);
$update->bindParam(':result', trim($result), PDO::PARAM_STR);
$update->execute();

But after reading the result in a textarea, there are no linebreaks but a string which looks like "Lorem\r\nipsum\r\ndolor".

I also tried

$update->bindParam(':result', trim(htmlspecialchars($result)), PDO::PARAM_STR);

What am I doing wrong?

maybe the db is doing some auto-escaping of "\" could you have a look ? — Alexis Peters
– Alexis Peters, Commented Dec 11, 2014 at 22:44
I didn't downvote but this is the very most basic of PHP and covered extensively in the manual and on SO. — AbraCadaver
– AbraCadaver, Commented Dec 11, 2014 at 22:51
Perfectly valid question, and one that seems to come up quite a bit based on the activity on this post: stackoverflow.com/questions/3446216/… — CragMonkey
– CragMonkey, Commented Dec 12, 2014 at 4:50

AbraCadaver · Accepted Answer · 2014-12-12 04:32:33Z

4

Use "\r\n" (double quotes) since escape sequences aren't interpreted inside of single quotes:

edited Dec 12, 2014 at 4:32

answered Dec 11, 2014 at 22:45

AbraCadaver

79.2k7 gold badges75 silver badges91 bronze badges

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

1 Comment

user3142695 Over a year ago

Wow. Would never think abou that. Thanks.

Collectives™ on Stack Overflow

Put linebreaks in a php-string and write everything correctly in MySQL-DB

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related