check if user already exists

[badolm]

Hello Sir
before the post go to database, I want to Check Whether user is Already exists in the database, if It is Already Exists then I want To Show
MsgBox, else that will Store in Database.
tks !
OLM

[Ben]

Hey badolm,

Sure, no problem! If you're using a simple POST form, you *will* have to move your form use the API, though.

Once you're using the API, you can use this function on your form:
http://docs.formtools.org/api/?page=ft_a..._is_unique

That lets you query the database to check to see if the user has already signed up / submitted the form or not. You can pass any criteria to that function to determine the submission's uniqueness.

Let me know if you need a few more pointers.

All the best -

Ben

[badolm]

thanks indeed my friend, no doubt that its the soluction!

Hey badolm,

Sure, no problem! If you're using a simple POST form, you *will* have to move your form use the API, though.

Once you're using the API, you can use this function on your form:
http://docs.formtools.org/api/?page=ft_a..._is_unique

That lets you query the database to check to see if the user has already signed up / submitted the form or not. You can pass any criteria to that function to determine the submission's uniqueness.

Let me know if you need a few more pointers.

All the best -

Ben