[FX.php List] Sample Login Handler Page

[Gjermund Gusland Thorsen]

Well, first off I just assume your login credentials are email and password

email text, indexing unicode( in order to make it case dependent and
to make @ a character and not a separator ) very often you would like
to run a tolower() on this string. as people forget which cases they
used in the username
password text, indexing unicode( in order to make it case dependent )

Now for the query

make sure it’s a logical and

and that the field crieteria is set to 'eq'

Now limit the resultset to 2

Before you do a check on the content on the returned data, check that
$r['foundCount'] == 1

if not you know you will have to fail the login.

ggt

2011/3/16 David Walton <dswcore at gmail.com>:
> Dear FX List,
>
>        Can anyone recommend a best procedure for handling web logins when the account credentials are stored as individual records in a FMP database?
>
>        I have done several of these (html form, javascript validation, FX submit, no-match error reporting, session starting upon success), but I am looking for a best way and wondered if others had creative approaches.
>
>        Would someone be willing to share a well-tested FX-based login_handler.php page?
>
>        Thank you for any push here.
>
> DSW_______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>