Can I query a MySql database with a gravity form and output the data on my website ? Let´s assume the query has produced 3 results. Can I then choose one of those results and have it sent to me by email.
With thanks for your kind help, Ken
Can I query a MySql database with a gravity form and output the data on my website ? Let´s assume the query has produced 3 results. Can I then choose one of those results and have it sent to me by email.
With thanks for your kind help, Ken
Yes, you can query the database directly or you can use native Gravity Forms functions to pull out the entry and do whatever you want with the results.
It sounds like I could also write to the MySQL database too?
What I would like to do:
1. Replace the form on this NON-wordpress page ( http://pulmccm.org/ccmtutorials/adduser.php ) of my wordpress-based site (http://pulmccm.org) with a wordpress page containing Gravity Forms.
2. Gravity Forms would send the email address the user enters to Aweber, which would send them a double opt-in email, and to the MySQL dbase.
3. The password field will be replaced with a ZIP code field which would be stored in Aweber or in my MySQL dbase, or both.
4. Then, when the user logs in at this location http://pulmccm.org/ccmtutorials/pulmonary-board-review.php , the MySQL dbase is queried to verify login.
Or could I replace this functionality with a Gravity Forms page as well, which would query either the MySQL dbase or the Aweber database itself to verify login?
If I can do all this database querying through Gravity Forms <--- ---> Aweber, I wouldn't need the MySQL dbase in the first place (it's redundant)
Hope this makes sense. Thank you for your help!
I'm not 100% certain of what you're asking, but you should be able to accomplish all this using the hooks which are built in to Gravity Forms or direct access to the database. The process is completely up to you.