Problem with links, and how they are stored and pulled from a database.

[aircool]

Right this is going to be hard to put.

Outline: Basically i'm attempting to build a basic CMS, using parts of code created by your truly and parts/plugins from other sources (Tiny MCE for example).

Now the problem I have now is when I am in editor, the links to say off site or even in some cases on site links usually have an odd bit of URL added to them.

For example, http://localhost/%22http://www.google.co.uk/%22 .

The bolded text is where its going wrong, from what I've been playing with if I remove the the "\" 's database (MySql) the link works correctly.

In the base the link is saved as:

<p><a title=\"12\" href=\"http://www.google.co.uk\" target=\"_blank\">Google</a></p>

But removing the \'s fixes it:

<p><a title="12" href="http://www.google.co.uk" target=\"_blank\">Google</a></p>

I struggling to see where I'm going wrong, or maybe I've not set something right?

[wilku]

It looks like you've got too many slashes in your query. Try to echo your query and see what's in there when you insert data to your database.
Maybe magic_quotes_gpc is turned on on your server and you use addslashes on the query?

[djjjozsi]

stripslashes will remove the unwanted \ from your string, but you might use mysql_real_escape_string if you insert it into database.

i've made a little tut video about this slashes problem , here

http://phptool.extra.hu/tutorials/forms_and_insert_into_database/forms_and_insert_into_database.html

hello, jjozsi