Convert New Line Characters To \n

[JustinK101]

How do I convert acutal line breaks into \n. I have a function which displays a javascript alert if a mysql query fails. The alert displays the full mysql query, that problem is that some of my queries are structured with line breaks such as:

 

SELECT first_name
           last_name
  FROM customers
WHERE  company_name = 'ABC'

 

These line breaks, cause the javascript alert code to fail, since javascript cannot deal with acutal new lines. Thanks for the help.

[marcus]

Are you talking about:

 

\n to <br>

 

or <br> to \n ?

[trq]

<?php

 $s = str_replace("\n","\\n", $s);

?>

[JustinK101]

Thorpe,

 

There inst any \n displayed, they are acutal new line characters, the hidden guys. For example I pass in a string like:

 

$sql = "SELECT first_name, last_name

            FROM customers

          WHERE first_name = 'bob'";

 

See what I mean, there are newlines in that string, and I echo that string into a javascript alert() if there is an error.

[trq]

Did you try my code? This...

 

#!/usr/bin/php
<?php

$s = "this
is
foo";

    $s = str_replace("\n","\\n",$s);
    echo $s;

?>

 

Produces...

 

this\nis\nfoo

 

Is this what you want?

[JustinK101]

Thorpe,

 

Ok so it almost worked, I changed the code to:

 

str_replace("\n", '', $sql)

 

Below (attached) is a screen shot of the alert window. You'll notice there is still some weird stuff going on, I think the whitespace might be tabs perhaps?

 

[attachment deleted by admin]

[JustinK101]

Whoo, Whoo. This seemed to work:

 

str_replace("\t", '', (str_replace("\n", '', $sql_query)))