PLEASE NOTE: These forums are no longer utilized and are provided as an archive for informational purposes only. All support issues will be handled via email using our support ticket system. For more detailed information on this change, please see this blog post.

Query a MySql database

  1. antibody
    Member

    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

    Posted 11 years ago on Thursday November 8, 2012 | Permalink
  2. 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.

    Posted 11 years ago on Friday November 9, 2012 | Permalink
  3. 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!

    Posted 11 years ago on Monday November 19, 2012 | Permalink
  4. 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.

    Posted 11 years ago on Tuesday November 20, 2012 | Permalink