Code

Discussion on Gravity Forms - WPDB / MySQL Connect

Discussion on Gravity Forms - WPDB / MySQL Connect

Cart 844 sales
naranili

naranili supports this item

Supported

This author's response time can be up to 5 business days.

191 comments found.

ignore … fixed now

Also external Database?

First Line of the Item-Description: Connect your Gravity Forms directly to your WPDB-Database-Tables. So the answer is : no.

How to add the logged user_id that sent the form ? Also, how can we save in the table the files uploaded in a form ?

Thanks for your help !

The user_id is a default gravity forms field that could be added ad the field drop down. You can save the filename of the upload field, but not the file.

Hi, Thanks for you answer. For user_id ok. For the file gravityforms protects the real file folder by giving a hash.

The URL looks like something like that: /index.php?gf-download=filename.ext&form-id=1&field-id=11&hash=73d3418f55a7814063260ffc2034a4a15a3fc3caa0dc0711dea82870d766332d

How can we get the URL in the table instead of the real file path ? Do you have any snipet that could be usable ?

Not with the plugin. The plugin stores the data that GF already stores at the tables. Nothing else

The plugin is not working, there is some conflict with the Gravity Forms “Add-on Registry” that is changing the user’s password. The user cannot log in with the password registered in the form that creates a user. It may not be incompatible with PHP, because I tested it with versions 5.6, 7.0, 7.1 and 7.3 and in all of them the same error occurred. Could the author please verify the conflict?

Please update to the new release 3.6.5 (you will be notified by codecanyon)

I tested it and it’s resolved, thank you very much!

Hi, I am gettign this PHP warnings in wordpress debug log: [18-Feb-2020 21:07:57 UTC] PHP Warning: session_start(): Cannot send session cookie – headers already sent in /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/gravityforms_wpdb-connect/gravityforms_wpdb-connect.php on line 53 [18-Feb-2020 21:07:57 UTC] PHP Warning: session_start(): Cannot send session cache limiter – headers already sent in /opt/bitnami/apps/wordpress/htdocs/wp-content/plugins/gravityforms_wpdb-connect/gravityforms_wpdb-connect.php on line 53. What should I do?

This isn’t a problem of this plugin. Any other plugin, theme or other coding already sends header informtion. Please switch to the default theme and disable all plugins. That add the needed plugin step by step and check with plugin/theme will generate this error.

Hi, please confirm wether support a server that is 7.2 php. If not can provide an update to your plugin please

Works with PHP > 7.0

Can you update the plugin to support 7.2 php?

The plugin supports PHP 5.6 and greater

hi, can i with this plugin a query, I have 2 fields, which I want when filled,query to table, and if they are, other fields are visible

No. Sorry,

can you tell me any plugin for that?

Sorry No. This is an AJAX function and i don’t know any “generic” AJAX plugin.

Hello can link to tables created with the wpdatatable plugin marcello

You mean the tables ‘wpdatatables’ and ‘wpdatatables_columns’ ? Yes. The wpdatatablesPlugin doesn’t create other tables.

I see others have commented about the GF List feature. Is this field supported now?

Sorry. No.

Hello, I wrote an email for support but haven’t heard back in 4 weeks. I love the plugin, but it generates a lot of visible errors when its used with Wider Gravity Forms Stop Entries. I need to suppress the storing of form entries in the GF tables, and only store the data in my custom table. Do you have a recommendation for how to accomplish that?

Here’s the stop entries plugin: https://en-au.wordpress.org/plugins/wider-gravity-forms-stop-entries/

Hi, I found out that enabling the plugin breaks my Woocommerce checkout page. Users (not the Admin in my tests) get “I’m sorry your session has expired”. I nailed it down to this plugin while disabling one by one. Is there a way to fix this? Thanks.

Hi ! It’s a Gravity-Form Plugin that only hook’s into Gravity Form Functions. Not WooCommerce.

I have a form with 5 radio fields and 3 number fields. I have an excel sheet with different permutations and combinations. The 3 number fields should be automatically filled, based on the options selected for those 5 radio fields. Can I achieve that using this plugin?

The Plugin save the form fields to database table fields. Nothing else.

Hi, I’m putting in a valid query and that is working fine on a option pricing field in Gravity Forms. The problem is that the options are being duplicated with the first options not using the query.

https://supplied.cambray.co/product/skypod-roof-lantern-skylight/

Look at the colour 1 field. The first two options shouldn’t be there.

Colour 1 Dropdown has 4 Values (from your linke above)

It Looks like, that Gravity Forms changed the functions. In the past it was possible to delete all Options.

To Workaround this delete all Options and leave the last Option blank. Than check the field as required.

You can only update entries via the backend of gravity forms? I expected users to be able to edit their details but it seems that this is only possible from the backend by an admin…..Very disappointing and waste of money.

This is Default Gravity Forms. Not a Problem of this Plugin.

Great plugin so far.

I issue I am having. I have using a function to populate an empty form with a specific entry_ID. On save, it only updates the default gravity forms table, not the new table I have created for this plugin. So primary key is “entry_id” I have it first in the feed, but doesn’t update the new table. But if new table doesn’t have that ID, it adds the row with correct data, but cant update it. The backend gravity form updates the data, but the point is for front end clients to update data.

Default Gravity Form doesn’t support updates from the Front-End.

Right, I know. That’s why I created a function to populate form on front-end based on URL parameter of entry ID. But I got what I needed to work. Since when doing it that way, it only thinks its a new entry so only calls “process_feed” function, which then doesn’t update entry, because it thinks there is duplicate primarykey, I just updated the code in “process_feed” to look for update piece, then call function “process_feed_update”, then its golden. If it’s a new entry, it acts correctly, but then also update exciting entry if needed.

What part of this solution is not already in Gravity? I don’t think i understand what is not already straight out of the box with gravity – sorry?

Try to save your entries with GF default in a ‘real’ database table, not only as meta-data. Or try to create choices from a database with Default GF.

Hi, using version 3.5.1 there is a conflict with some GravityView functions related to merge tags. When I disable your plugin, GravityView functionality is restored.

Do you have a way for me to send screenshots?

I uploaded an update to fix this

5 stars, great fix and really appreciate the responsiveness (and overall great plugin). Thanks.

Hello,

I have a simply pre-sale question. After my forms is open on my website, the dropdown list is auto-updated when a new value is available with the query ? Or I need to do somethings in the backend before ?

I have my answer, it’s possible ;)

Sorry, I have one more question. You explain your plugin can be used with all the wordpress table. Also with table created with other plugin ? Any restriction ?

Thanks

The only restriction is, that the the table must be at the wordpress database.

Dear Support Team :-)

We are planning a little promo competition. When people buy a product they receive a tag with a unique code and get lead to a url with a form to enter. On that form there will be a field called Unique Code. They will then enter the Unique code they received on the card.

However what I need is for the form to validate a database of around 20,000 codes. Is there a way that this can be managed via your plugin in combination with Gravity Forms?

Thank you a lot for your feedback.

Best regards, Angie

Hallo Naranili,

Thank you a lot for your quick reply. The formula worked very well!

Your Plugin is amazing :-)

I send you all my best regards!

Hello Naranili :-)

I would have am additional question: We would like to delete each submitted promo code from the mysql table AFTER the gravity form has been submitted, i.e. make any submitted code invalid in order to prevent its abuse.

We could do this manually directly by looking up which codes have been submitted and entering them directly in PHP MyAdmin via the following formula:

DELETE `colorname` FROM `colors` WHERE `colors`.`colorname` = \’SUBMITTEDCODE’

Is there any way to integrate this step in your plugin and thus automise the deletion of submitted values via this (or similar) formula?

DELETE `colorname` FROM `colors` WHERE `colors`.`colorname` = \’{field}’

If yes, what codes &/or formula would I need to add/edit where?

Thank you a lot for your reply.

Sorry. This isn’t possible with the plugin.

by
by
by
by
by
by

Tell us what you think!

We'd like to ask you a few questions to help improve CodeCanyon.

Sure, take me to the survey