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, Dec 11 '14 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, Dec 11 '14 at 22:51
Perfectly valid question, and one that seems to come up quite a bit based on the activity on this post: http://stackoverflow.com/questions/3446216/what-is-the-difference-between-single-quoted-and-double-quoted-strings-in-php — CragMonkey, Dec 12 '14 at 04:50

AbraCadaver · Accepted Answer · 2014-12-12T04:32:33.273

4

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

edited Dec 12 '14 at 04:32

answered Dec 11 '14 at 22:45

AbraCadaver

77,023
7
60
83

Wow. Would never think abou that. Thanks. – user3142695 Dec 11 '14 at 22:50

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

1 Answers1