RE: [PHP] Data validation at the db level
| From: | Jay Blanchard | Date: | Fri, 08 Sep 2006 00:15:48 +0000 |
| Subject: | RE: [PHP] Data validation at the db level | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-241467@lists.php.net to get a copy of this message | ||
[snip]
Hey everyone,
Is there any work being done in the database world for data validation
at the db level?
It would be cool to just define a field as being an email address (of
length nn) instead of saying a TEXT field (of length nn) and validating
it in the application layer. Same goes for other things as well.
Sure, it's not really possible to account for all different types of
data, but the basics would be nice. (email, numbers only, letters only,
alphanumeric only, [a-z0-9#-] only, etc.)
[/snip]
There are all sorts of ways to validate data at the DB level and this is
a PHP question how? I only ask because validation at the DB level
removes the need to validate at the application level.