filterSql of Yii Frw

    public static function filterSql($val) {
     // remove all non-printable characters. CR(0a) and LF(0b) and TAB(9) are allowed
     // this prevents some character re-spacing such as <java\0script>
     // note that you have to handle splits with \n, \r, and \t later since they *are* allowed in some inputs
     $val = preg_replace('/([\x00-\x08][\x0b-\x0c][\x0e-\x20])/', '', $val);

     //REMOVE SQL INJECTION
     $val = preg_replace(@sql_regcase("/(\n|\r|%0a|%0d|Content-Type:|bcc:|to:|cc:|Autoreply:|from|select|insert|delete|where|drop table|show tables|#|\*|--|\\\\)/"), "", $val);

     //$val = stripslashes($val);
     //$val = strip_tags($val); # Remove tags HTML e PHP.
     //$val = addslashes($val); # Adiciona barras invertidas à uma string.


     //$val = preg_replace('/([\x00-\x08,\x0b-\x0c,\x0e-\x19])/', '', $val);

     // straight replacements, the user should never need these since they're normal characters
     // this prevents like <IMG SRC=&#X40&#X61&#X76&#X61&#X73&#X63&#X72&#X69&#X70&#X74&#X3A&#X61&#X6C&#X65&#X72&#X74&#X28&#X27&#X58&#X53&#X53&#X27&#X29>
     $search = 'abcdefghijklmnopqrstuvwxyz';
     $search.= 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
     $search.= '1234567890!@#$%^&*()';
     $search.= '~`";:?+/={}[]-_|\'\\';

     for ($i = 0; $i < strlen($search); $i++) {
             // ;? matches the ;, which is optional
             // 0{0,7} matches any padded zeros, which are optional and go up to 8 chars

             // &#x0040 @ search for the hex values
             $val = preg_replace('/(&#[x|X]0{0,8}'.dechex(ord($search[$i])).';?)/i', $search[$i], $val); // with a ;
             // &#00064 @ 0{0,7} matches '0' zero to seven times
             $val = preg_replace('/(&#0{0,8}'.ord($search[$i]).';?)/', $search[$i], $val); // with a ;
     }

     return "'$val'";
}