How to Stop SQL Injection in MYSQL?
Posted by
om 9 August, 2009
Every PHP-MYSQL programmer need to know Anti-SQL Injection.
Please take a look at very simple function which can save your database!!
View Code PHP
<?Php function ClearInput($dirty){ if (get_magic_quotes_gpc()) { $clean = mysql_real_escape_string(stripslashes($dirty)); }else{ $clean = mysql_real_escape_string($dirty); } return $clean; } ?> |
where do i put this code??? if in mysql how to input using sqlyog
Sqlyog is GUI tools to mange MySQL and you can administrate like phpmyadmin.
Above code you can use when you are creating/writing code using php and mysql.
Can you execute php code using Sqlyog ?
thanks for this code! it worked
Thanks that code worked for you.