Created
May 28, 2013 10:21
-
-
Save botaor/5661825 to your computer and use it in GitHub Desktop.
Sanitize database inputs in PHP
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
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; | |
} | |
?> | |
// Examples | |
<?php | |
$bad_string = "Hi! <script src='http://www.evilsite.com/bad_script.js'></script> It's a good day!"; | |
$good_string = sanitize($bad_string); | |
// $good_string returns "Hi! It\'s a good day!" | |
// Also use for getting POST/GET variables | |
$_POST = sanitize($_POST); | |
$_GET = sanitize($_GET); | |
?> |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment