Bash to PHP stripping white spaces

[jamessw]

I have a php script that basically runs a local script on my server, which queries a database. The problem is that the white spaces (spaces and returns) are not maintained, so I get a continuous string of text. I'm not sure at what point I'm losing the white space in this. Any ideas? Thanks!

 

Code-

<?php

$toexec='/Library/WebServer/Documents/jobsearch.sh';

$wordwrap = system($toexec, $output);

$wordwrap = str_replace("\n", "<br />", $wordwrap);
$wordwrap = str_replace("  ", "  ", $wordwrap);

echo $wordwrap;

?>

 

#!/bin/bash
#Job Search

/Library/Application\ Support/Final\ Cut\ Server/Final\ Cut\ Server.bundle/Contents/Resources/sbin/fcsvr_run psql px pxdb -c "select mediatitle,status,statusmsg FROM pxjob WHERE status = 'RUN'" > /tmp/jobs3.txt

head /tmp/jobs3.txt

 

jobs3.txt -

                        mediatitle                         | status |    statusmsg     
-----------------------------------------------------------+--------+------------------
Creating Clip Proxy for asset:  2:13 Shoot_Cam A #2-1.mov | RUN    | Transcoding clip
(1 row)

 

Output of the php script-

mediatitle | status | statusmsg -----------------------------------------------------------+--------+------------------ Creating Clip Proxy for asset: 2:13 Shoot_Cam A #2-1.mov | RUN | Transcoding clip (1 row) 

[crawlerbasher]

When I have white space and newlines on the database I get the problem of it all been all on one line.

 

I used nl2br()

 

And that turns new lines to </br />

[jamessw]

When I have white space and newlines on the database I get the problem of it all been all on one line.

 

I used nl2br()

 

And that turns new lines to </br />

 

I've tried nl2br in several different places, and it hasn't worked- where would it go in my script exactly?

[jamessw]

Also, nl2br won't fix the spacing problem- it strips out multiple spaces as well.

[jamessw]

Found the solution. Needed to add a <pre> HTML tag in my document, now it's formatted perfectly.