PHP from automatically turning any value in the URL into a variable | x=0&y=0

To turn register globals off, you will need to change the settings in the php.ini file to:

register_globals = Off

Note the upper case letter O in Off.

This will prevent PHP from automatically turning any value in the URL into a variable. That's a good thing because it means that hackers cannot try to insert anything they want into your code simply by inserting it into your URL. Well written code should be validating the variables anyway, but this provides extra security in case the script does not validate variables properly or if the validation is buggy.

$GLOBALS - References all variables available in global scope | PHP

An associative array containing references to all variables which are currently defined in the global scope of the script. The variable names are the keys of the array.




<?php

print '<pre>'.print_r($GLOBALS, 1).'</pre>';

MySQL - Regular Expressions & REPLACE | preg_replace

Method 1:
MySQL Regular Expression UDFs


Method 2: Replace. I like it! Haha!
From 
a~b}c{d`e_f^g\\h[i?j=k;l.m-n,o*p(q&r$s"t u|v]x@y>z<0:1+2)3\'4%5#6!7\r8\f9\v0\naz\t09\b
To 
abcdeghijklmnopqrstuxyz01234567890az09


select replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace( replace(
'a~b}c{d`e_f^g\\h[i?j=k;l.m-n,o*p(q&r$s"t u|v]x@y>z<0:1+2)3\'4%5#6!7\r8\f9\v0\naz\t09\b',
'~', ''),
'}', ''),
'{', ''),
'`', ''),
'_', ''),
'^', ''),
'\\', ''),
'[', ''),
'?', ''),
'=', ''),
';', ''),
'.', ''),
'-', ''),
',', ''),
'*', ''),
'(', ''),
'&', ''),
'$', ''),
'"', ''),
' ', ''),
'|', ''),
']', ''),
'@', ''),
'>', ''),
'<', ''),
':', ''),
'+', ''),
')', ''),
'\'', ''),
'%', ''),
'#', ''),
'!', ''),
'\r', ''),
'\f', ''),
'\v', ''),
'\n', ''),
'\t', ''),
'\b', '')