Thinking about escaping and sanitizing input and output? Read this: https://security.stackexchange.com/questions/95325/input-sanitization-vs-output-sanitization
- Always sanitize output
You can fix bugs in the input sanitizer without touching the database by always sanitizing output.
- Sanitize input, if it makes sense:
For example, if there’s a risk that input becomes invalid after sanitization it’s better to store data raw. Also, when there are multiple output formats sanitizing might break something.