PHP and MySQL Validation on the Server and ClientPHP and MySQL - Validation on the Server and Client
Validation on the Server and Client
Validation and Error Reporting for Web Database Applications
Models That Don't Work
Models That Do Work
Server-Side Validation
Case Study: Customer Validation in the Winestore
Validating dates
Validating numeric fields
Validating email addresses
Processing <form> Data on the Server Side
Processing <form> controls with the MULTIPLE attribute
Client-Side Validation with JavaScript
Validating <form> Data with JavaScript
Case study: A generic JavaScript validation function
JavaScript Tips and Tricks
Rollover presentation with mouseOver events
Prefilling <form> data with JavaScript calculations
Interacting with the web browser
Which browser is the user using?
Validation is essential to web database applications. Ensuring that data meets user and system requirements is important, but ensuring that the database constraints are met by the data is critical. There are three possible data environments in which validation can occur in a three-tiered web database application: in the DBMS, in server-side scripts, and on the client. We discuss the merits and possibilities of these approaches to validation in this tutorial.