populating fields from database

User 1982097 Photo


Registered User
58 posts

Hi Eric,
Not sure what subject line to use for this question, but...
I would like to give a webform that I created with coffeecup to my programmer to ingregrate with my site in such a way that it is behind a login and then prepopulates a few fields using a database query. Can you give me any advice on how to instruct him on the use of what I export. particularly all the files etc.. Maybe I'm overthinking this but just wondering what your advice might be.
I love coffee in cups
User 187934 Photo


Senior Advisor
18,728 posts

They only need the html of the form page. They will need to add the custom php scripts to load the correct variables.
There's two approaches I use. I either change the html page to .php or I setup my host to allow parsing php within html with .htaccess.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

Here's my S-Drive site with
examples of what can be accomplished in VSD.
https://progrower.coffeecup.com/
Here's my CoffeeCup SCCP Shop with examples of what can be done.
https://progrower.coffeecup.com/shop/
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 1982097 Photo


Registered User
58 posts

so, they need no other files?
I think they need the form.cfg file too right? Can we just use it as is with the notifications and confirm email etc.
I love coffee in cups
User 1982097 Photo


Registered User
58 posts

ok, so what i mean is ... if i am using notifications and confirm message, what other files do i need?
I love coffee in cups
User 187934 Photo


Senior Advisor
18,728 posts

Your developer doesn't need any other files to write the scripts but I guess I would send all of them to make sure they have it fully integrated. They should only need to alter the formname.html to do what your asking but it may help for testing to have all of the form files
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

Here's my S-Drive site with
examples of what can be accomplished in VSD.
https://progrower.coffeecup.com/
Here's my CoffeeCup SCCP Shop with examples of what can be done.
https://progrower.coffeecup.com/shop/
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com
User 1982097 Photo


Registered User
58 posts

Hi Eric, update and question

Thanks.. we were successful in parsing data into the key fields in the form.
Question. How do I retain the same confirmation and email notifcation forms. We would be using parsed email address from database. ? Sorry of dumb question
I love coffee in cups
User 187934 Photo


Senior Advisor
18,728 posts

If your wanting to hold an email address across different pages then you'll need to use $_SESSION variables.
I can't hear what I'm looking at.
It's easy to overlook something you're not looking for.

Here's my S-Drive site with
examples of what can be accomplished in VSD.
https://progrower.coffeecup.com/
Here's my CoffeeCup SCCP Shop with examples of what can be done.
https://progrower.coffeecup.com/shop/
This is a site I built for my work.(RSD)
http://esmansgreenhouse.com
This is a site I built for use in my job.(HTML Editor)
https://pestlogbook.com
This is my personal site used for testing and as an easy way to share photos.(RLM imported to RSD)
https://ericrohloff.com

Have something to add? We’d love to hear it!
You must have an account to participate. Please Sign In Here, then join the conversation.