Skip to content

Instantly share code, notes, and snippets.

@dev-hpjsolutions
Created June 16, 2013 15:52
Show Gist options
  • Save dev-hpjsolutions/5792446 to your computer and use it in GitHub Desktop.
Save dev-hpjsolutions/5792446 to your computer and use it in GitHub Desktop.
Sanitize database input
function cleanInput($input) {
$search = array(
'@<script[^>]*?>.*?</script>@si', // Strip out javascript
'@<[\/\!]*?[^<>]*?>@si', // Strip out HTML tags
'@<style[^>]*?>.*?</style>@siU', // Strip style tags properly
'@<![\s\S]*?--[ \t\n\r]*>@' // Strip multi-line comments
);
$output = preg_replace($search, '', $input);
return $output;
}
function sanitize($input) {
if (is_array($input)) {
foreach($input as $var=>$val) {
$output[$var] = sanitize($val);
}
} else {
if (get_magic_quotes_gpc()) {
$input = stripslashes($input);
}
$input = cleanInput($input);
$output = mysql_real_escape_string($input);
}
return $output;
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment