Learn how web applications with access to your database (e.g. MySQL) may be used to poison, dump, or delete information in your database.
Learn all about MySQL foreign keys in this white paper.
Learn how to avoid MySQL foreign key errors, including the notorious Errno:150 in this white paper.
Learn the importance of data validation in web applications when information is accepted from third parties, or even from internal users.
Data Validation in (MySQL/SQL) Web ApplicationsHave questions that weren't answered here? Feel we've left something out? Have any feedback? Let us know: Contact Us
IntroductionData validation is an extremely broad topic. It's usefulness ranges from improving user experience to ensuring that data is in a form that can be used to security. In this white paper, we're going to explore the different types of data validation, and what they can be used for.
Where Does Data Validation Happen?
How Do You Do Server Side Validation?
ConclusionsData validation takes a fair amount of thought, and often a fair amount of coding infrastructure to do correctly. It's important when creating forms or user input environments to evaluate first what kind of data is going to be submitted, and second, where it is going. If it is going into an SQL query, you need to make sure that it is escaped correctly (or that it is going into a safe environment like a prepared query statement). This will prevent application errors that arise from bad data being used (either on input or on reuse later), or possibly security breaches.
Eliacom's MySQL GUI Tool provides you with simple, straight-forward data validation. We hope you found this white paper useful. Please let us know if you have any questions you felt were not addressed in the white paper or if you have any feedback: Contact Us
|Copyright © 2010-2015 Eliacom, Inc. All rights reserved.|