Removing ' and / from submits

[zMagenta]

Hi!

Is there anyway to remove the characters - ' and / from getting submitted into a DB as most of the time it causes MySQL errors?

Thanks!

 

[Weasel]

You must be registered for see links

 

[Tranquilizer]

I use this function for replacing characters (it currently removes apostrophes):

function clean_up( $text ) {
    $unwanted = array("'"); // add any unwanted char to this array
    return str_ireplace( $unwanted, '', $text );
}

Put whatever character you want to be replaced with nothing in the $unwanted. Then when you're selecting or inserting use clean_up($variable). In your case use:

<?php
if(isset($_POST['submit'])){
$variable = clean_up($_POST['fieldhere']);
}
?>

If you're inserting or updating a variable into the database you might want to mysql_real_escape_string that variable.
Hope this helps

 

[Ecko]

You must be registered for see links

no.

$var = trim($_POST['var'], "'\"");

 

[Markshall]

I'm sure stripslashes(); would work just fine.