PHP Validation: check if value exists in mysql db

[Hannes]

Hi,

is there a way to check if a value exists in a mysql database an post a validation error if not?

br,
Hannes

[Ben]

Hi Hannes,

Sure - you'll need to use the following API function:
http://docs.formtools.org/api/?page=ft_a..._is_unique

That lets you query a form's database table to find out if a value already exists. It's pretty versatile, so it should work in your case.

All the best -

Ben

[Hannes]

Hi Ben,

thank you for your help. Unfortunatly I still did not get it running.

What I want to have is a user and a password field in the form.
Now the validation should check if user and password are matching in a mysql table cotaining the rows user and password.
Otherwise the error "user/password not matching" should appear.

Could you please give me a hint how this works with you API function?

Thanks a lot.
Hannes.

[Ben]

Hi Hannes,

Sure - no worries. I'm going to put together a tutorial for you. Give me a day or two at most - I'll post back then!

- Ben

[Hannes]

Hi Ben,

thank you a lot for your effort.
I'm looking forward very much for this tutorial.
Please let me know as soon you have a solution for me.

Best regards,
Hannes

[Ben]

Hi Hannes,

Ack - sorry, I forgot about this.

I just wrote "Tutorial: check for uniqueness" on my whiteboard in capital letters. I'll get to it this week.

- Ben

[Hannes]

Hi Ben,

Can't wait! I hope you will find the time to get it finished this week.

Hannes.

[Ben]

Hi Hannes,

I *am* sorry for the wait! I just finished it off:
http://docs.formtools.org/tutorials/chec...niqueness/

Hopefully it makes sense, but let me know if I'm not clear on anything.

- Ben

[Hannes]

Yehaw! Thanks a lot...

Did I understand correct:
If I have a form 1 with...

PHP Code:

$fields = ft_api_init_form_page(1);
...
"A"  => $_POST["B"]
);
if (!ft_api_check_submission_is_unique(2, $criteria, $fields["form_tools_submission_id"]))
... 


the function will check if the posted form field "B" in form 1 already exists in column "A" of form 2?

[Ben]

the function will check if the posted form field "B" in form 1 already exists in column "A" of form 2?

Precisely. And note that "A" is the database column name - not the form field name. That one always trips me up.

(Just one thing: in this scenario, make sure the first parameter of ft_api_check_submission_is_unique is 1, not 2 - that should be your form ID).

- Ben