November 1, 200916 yr Hi, I just started playing around with FMStudio and I wonder what's the best way to validate new users records creation. That is, let's say that I have a php "new user" web form with email and password fields, later used for login. To make it simple, first I need to verify the email field (for instance, at least one "@" character). If passed, then I need to verify that the email address does not already exist in the "users table" As a FileMaker developer, I would create a FM script that does this validation and returns a variable redirecting to one or another php file depending on the result of the validation. But I guess that it would be more efficient to use first regular expressions, and then another php file with a recordset that would return a foundset count of zero if the email doesn't exist yet in the users table. So I guess my question can be reduced to this: shall I use FM scripts or PHP scripts, for validation of creation of new users records? Thanks in advance!
Create an account or sign in to comment