PHP: Security Issues : Cleaning up User Data in MySQL

One of the things you’re going to encounter when using MySQL with PHP sooner, rather than later, is the issues that arise when you start accepting user input in the form of comments or blog posts. When dealing with the general public, we can’t assume anything about the data they submit into our database. In fact, we have to assume the worst! Making sure your data is "cleaned" and "sanitized" is very important to ensure smooth running of your site and your database.