note 102145 added to security.magicquotes

for those who want an automatic sanitization of GET, POST, COOKIE, etc variables: the code escapes ALL vars! That is, it effectively prevents SQL injection and XSS attaks. It lifts the need for 'magic_quotes_gpc = On' directive. However it treats all variables as text and does not do type-cheking. So it is suitable only for making SQL queries or displaying html content. the following code can be included in all pages which need html and sql sanitization. <? // escaping and slashing all POST and GET variables. you may add $_COOKIE and $_REQUEST if you want them sanitized. array_walk_recursive($_POST, 'sanitizeVariables'); array_walk_recursive($_GET, 'sanitizeVariables'); // sanitization function sanitizeVariables(&$item, $key) { if (!is_array($item)) { // undoing 'magic_quotes_gpc = On' directive if (get_magic_quotes_gpc()) $item = stripcslashes($item); $item = sanitizeText($item); } } // does the actual 'html' and 'sql' sanitization. customize if you want. function sanitizeText($text) { $text = str_replace("<", "&lt;", $text); $text = str_replace(">", "&gt;", $text); $text = str_replace("\"", "&quot;", $text); $text = str_replace("'", "&#039;", $text); // it is recommended to replace 'addslashes' with 'mysql_real_escape_string' or whatever db specific fucntion used for escaping. However 'mysql_real_escape_string' is slower because it has to connect to mysql. $text = addslashes($text); return $text; } // export POST variables as GLOBALS. remove if you want foreach (array_keys($_POST) as $ehsanKey) $GLOBALS[$ehsanKey] = $_POST[$ehsanKey]; // export GET variables as GLOBALS. remove if you want foreach (array_keys($_GET) as $ehsanKey) { $GLOBALS[$ehsanKey] = $_GET[$ehsanKey]; } // preventing the key used above for iteration from getting into globals (in case 'register_globals = On') unset($ehsanKey); // the reverse function of 'sanitizeText'. you may use it in pages which need the original data (e.g. for an HTML editor) function unsanitizeText($text) { $text = stripcslashes($text); $text = str_replace("&#039;", "'", $text); $text = str_replace("&gt;", ">", $text); $text = str_replace("&quot;", "\"", $text); $text = str_replace("&lt;", "<", $text); return $text; } ?> ---- Server IP: 69.147.83.197 Probable Submitter: 194.225.147.12 ---- Manual Page -- http://www.php.net/manual/en/security.magicquotes.php Edit -- https://master.php.net/note/edit/102145 Del: integrated -- https://master.php.net/note/delete/102145/integrated Del: useless -- https://master.php.net/note/delete/102145/useless Del: bad code -- https://master.php.net/note/delete/102145/bad+code Del: spam -- https://master.php.net/note/delete/102145/spam Del: non-english -- https://master.php.net/note/delete/102145/non-english Del: in docs -- https://master.php.net/note/delete/102145/in+docs Del: other reasons-- https://master.php.net/note/delete/102145 Reject -- https://master.php.net/note/reject/102145 Search -- https://master.php.net/manage/user-notes.php