In PHP code, how can I remove newlines

Question

In my PHP code

$sql = "SELECT a.SEQ, a.DPCODE, a.SUBJECT, CONCAT_WS('~',a.SDATE, a.EDATE) AS SDATE, b.content, concat(replace(c.filepath,'E:/WWW','http://myhome.com/'),c.filelocalnm) as filename";
$sql .= " FROM PJ_EXHIBIT a LEFT JOIN collection.exhibit b ON a.SEQ=b.seqno LEFT JOIN sy_file c ON a.attach_file = c.SEQ";

with json_encode, it returns:

result in explorer

I want to remove '\'.

Possible duplicate of [Remove new lines from string](http://stackoverflow.com/questions/3760816/remove-new-lines-from-string) — Death By Penguin, Nov 28 '16 at 11:07

Karol Gasienica · Accepted Answer · 2016-11-28T11:39:45.930

0

You can use str_replace

<?php
$variable = 'http:\/\/comin.com:8990\/\/upload\/pj\/PJ_EXHIBIT\/1480308974751289.jpg';
$new = str_replace('\\', '', $variable);
echo $new;
?>

Or you can use preg_replace

<?php
$variable = 'http:\/\/comin.com:8990\/\/upload\/pj\/PJ_EXHIBIT\/1480308974751289.jpg';
$new = preg_replace("/\\\/", '', $variable);
echo $new;    
?>

Manuals

More informations can be found below:

edited Nov 28 '16 at 11:39

answered Nov 28 '16 at 11:05

Karol Gasienica

2,665
21
33

It hepls me a lot. Thank you very much. – chimsik Nov 28 '16 at 12:00

In PHP code, how can I remove newlines

1 Answers1