I am using Web form builder to build a web-based workflow that you can see beginning to be sketched out at http://abcm.qdt.com.au

Many of the controls will access MySQL databases and sometimes change the display in the form

I'd like to develop the workflow as much as possible within Form Builder and not hack the published forms unless I need to.

Questions:

1. Can I put PHP into a custom HTML element? One example is two drop-down lists. The first gets it items from a query on the database. The second gets its items from another query based on the item selected in the first. It seems to me that these drop-downs would have to be hand coded, unless you can suggest a way using your interface.

2. The sign-up - sign-in - lost password - password verification routine is a well-trodden path. Do you have any resources for this that would save me work?

3. As we jump between the forms we need to remember who is logged in. I guess this means passing PHP variable values between the forms. How can I do that?

4. Is Web form Builder the right horse for this course?

Thanks

1. Yes
2.This is handle already in several ready built login scripts available on the net.
3.You'll need $_SESSIONS
4. It can be. There are login scripts out there that have some of this functionality but your still going to need to alter them to your needs.

Thanks for the explanations and reassurance, Eric. I'm exploring enough to understand and then hiring a developer to complete the job.

If you use an existing login script you'll have all the $_SESSION stuff setup for you and all you'll need to do is customize them to your needs. This way you can use a little JQuery and mysql/php to show the users their specific drop downs or data in the form when their logged in.