quotes

[slimjim]

I have a text area, and that info is going into the database ( mysql)
text area is called footer.
How would i replace double quotes and add single quotes but also add a backword slash before the single quote before it goes into the database.

Also not to allow javascript as well.
Now I tried :

$footer = trim($footer);

That didnt work at all. Double quotes remained.

But I also want the html to show up on page correctly without issues after being selected from database.

[Shrike]

$footer = str_replace('"', "'", $footer);
$footer = addslashes($footer);

[Frederick]

You can specify what tags to allow and this will strip all other tags

$value = strip_tags($variable,"<a><font><u><b><i><img>");

The html tags I specified are the exception to stripping tags, those listed will be permitted to be used and all others will strip from display / rendering.

Next, the following checks if magic_quotes_gpc is on. This setting in the php.ini file adds backslashes before all double / single quotes in your database input.

if (!get_magic_quotes_gpc()) {
	$str = addslashes($content);
} else {
	$str = $content;
}