[SOLVED] replace ampersand before gets to DB

[madcrazy1]

hi,

how can i replace the ampersand with & before it gets stored in the database.

i have an existing function the actually strips the script tags, can something be added to this bit of code to get this accomplished?

 

<?php
function escape_string($string) {
    return  get_magic_quotes_gpc()?mysql_real_escape_string(stripslashes($string)):mysql_real_escape_string($string);
}

function html2txt($document){
$search = array('@<script[^>]*?>.*?</script>@si');
               
$text = preg_replace($search, '', $document);
return $text;
}
?> 

 

thank you

[darkfreaks]

<?php
$string=str_replace('&','&',$string)?>

[madcrazy1]

novice here-not sure how thats supposed to fit in with the code above.

thx

[darkfreaks]

<?php
function escape_string($string) {
    return  get_magic_quotes_gpc()
?mysql_real_escape_string(stripslashes($string)):mysql_real_escape_string($string)
:str_replace('&','&',$string);
}

function html2txt($document){
$search = array('@<script[^>]*?>.*?</script>@si');
               
$text = preg_replace($search, '', $document);
return $text;
}
?> 

[hvle]

You want to look at the function htmlentities()

[madcrazy1]

thank you