2 forms 2 databases

[trol1374]

This is a great piece of script. I have put together one form and got it working.

Now I want to do another form but in a different domain name. I understand I don't have to install formtools under the new domain? I am using the direct post method.
I'm trying to figure out with this second form, how to setup a different database. Do I need to add the info in the config file? Do some manual code?
I can't get past step 4 due to errors, which I'm sure because it is trying to write to the 1st database that was setup on other form. I don't want it touching the first.

Summary: How to setup 2nd database on a new form?

[Ben]

Hi trol,

Thanks for the post!

No, you don't need to install Form Tools on the second domain - not if you're using the direct POST method.

Regarding your question, however, I'm a bit confused. Do you mean you're having trouble adding the second form to Form Tools? I wasn't quite sure what you mean by a separate "database".

To add the second form, just follow exactly the same process as before: click on the "Add form" link in the Form Tools admin section, choose "External form" and go through the process.

- Ben

[trol1374]

Hi trol,

Thanks for the post!

No, you don't need to install Form Tools on the second domain - not if you're using the direct POST method.

Regarding your question, however, I'm a bit confused. Do you mean you're having trouble adding the second form to Form Tools? I wasn't quite sure what you mean by a separate "database".

To add the second form, just follow exactly the same process as before: click on the "Add form" link in the Form Tools admin section, choose "External form" and go through the process.

- Ben

Hi Ben,
When I mean separate database, I mean a new different one. I have access to more then one database, so I just wanted to use a different database then the first form is using.
The new database has it's own logon and connection setting different from the first form.
Yes, I am using the direct POST method.

Thanks,

[Ben]

Actually I'm still a bit confused about your terminology & problem, sorry!

To clarify: Form Tools uses a single database. Each form you configure is given its own table in that database. So one installation of Form Tools can have multiple forms added to it. They're totally separate, and one form won't overwrite another one - it was deliberately designed to handle forms from multiple locations - such as different domains like in your case.

If you're using two different databases, that means you must have two separate installations of Form Tools.

So what's the problem you're having with configuring the second form, exactly?

(Sorry!)

- Ben

[trol1374]

Actually I'm still a bit confused about your terminology & problem, sorry!

To clarify: Form Tools uses a single database. Each form you configure is given its own table in that database. So one installation of Form Tools can have multiple forms added to it. They're totally separate, and one form won't overwrite another one - it was deliberately designed to handle forms from multiple locations - such as different domains like in your case.

If you're using two different databases, that means you must have two separate installations of Form Tools.

So what's the problem you're having with configuring the second form, exactly?

(Sorry!)

- Ben

Ok, you answered that question. second (different) database requires new install of tools to that area. I had wanted to use a different (new database) due to not wanting to use all the space up on first database. I will install a new formtools and be up and going.
No problems adding the second form. I just had an error because of my code, but did get it working.

Thanks,

[Ben]

Ah, I see! Yeah - if you're working with DB size restrictions, a second installation is a very reasonable way to go.

Glad the problem got sorted out. All the best -

Ben