You are here: Re: problems with saving and retrieving data with new line (\n and \r\n) and slashes from mysql database « All PHP « IT news, forums, messages
Re: problems with saving and retrieving data with new line (\n and \r\n) and slashes from mysql database

Posted by Koncept on 01/14/07 05:49

In article <Haadnd6dl8LDhjTYRVnyigA@scarlet.biz>, JM <reply@group.svp>
wrote:

> Before storing information from a form in database I perform follwing
> operations on it :
> $path =
> mysql_real_escape_string(strip_tags(trim(urldecode($_POST['path']))));
> $summary =
> mysql_real_escape_string(strip_tags(trim(urldecode($_POST['summary']))))
>
> When I look in database I see '\r\n' in the text for the summary
> wherever I pressed return-key.
> When i retrieve the information from database and display it on webpage
> '\r\n' is displayed even when I use
> nl2br or
> str_replace("\r\n", "<br/>", $content) or
> str_replace(array("\r\n", "\n", "\r"), "<br>", $text) or
> preg_replace("/\r\n|\n|\r/", "<br>", $text)
> the '\r\n' is replaced with a <br>.
> How is the possible ? The functions work when I let them handle a string
> like "A little bit of\r\ntext".
>
> A folder is stored as 'H:\\\\My Pictures\\\\Anemone.jpg' in the
> database. When I want to display the folder I use the function
> stripslashes first but then I still get 'H:\\My Pictures\\Anemone.jpg'.
> Why should I apply stripslashes twice ?
>
> Hope you can help me,
>
> JM!

<snip>
magic_quotes_runtime boolean

If magic_quotes_runtime is enabled, most functions that return data
from any sort of external source including databases and text files
will have quotes escaped with a backslash.
</snip>

See get_magic_quotes_gpc() in the docs.

You can easily add code to account for this possibility:
get_magic_quotes_gpc() && $str = strip_tags( $str );

I'm also willing to bet that your line breaks are currently double
escaped e.g. "\\r\\n".

--
Koncept <<
"The snake that cannot shed its skin perishes. So do the spirits who are
prevented from changing their opinions; they cease to be a spirit." -Nietzsche

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация