https://legacy.forums.gravityhelp.com/tags/mysql Gravity Support Forums Tag: MySQL - Recent Topics en-US Sun, 19 Apr 2026 18:21:23 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/gravity-forms-on-install-wordpress-database-error-mysql-has-gone-away#post-362146 Thu, 04 Jul 2013 21:10:11 +0000 rysen2888 362146@https://legacy.forums.gravityhelp.com/ <p>Hi</p> <p>I just tried installing gravity forms, but once i clicked activate i got Wordpress database error: mysql has gone away.</p> <p>I then click on pages, and everything is gone. I have to delete the plugin to see the pages/posts again and it really makes admin slow down and lag</p> <p>Here is a screenshot for the error.<br /> <a href="http://i.imgur.com/6S0wgqk.png" rel="nofollow">http://i.imgur.com/6S0wgqk.png</a></p> <p>Ive tried deleting and reinstalling, tho the error isnt showing anymore but it still removes all posts/pages until i re delete the plugin.</p> <p>Any help much appreciated<br /> Thanks </p> https://legacy.forums.gravityhelp.com/topic/using-mysqli_real_escape_string-with-gform_after_submission-and-a-mysql-database#post-323487 Fri, 14 Jun 2013 14:51:48 +0000 andrew carbn 323487@https://legacy.forums.gravityhelp.com/ <p>Hi,<br /> I think I'm correct in saying it is best practice to use mysqli_real_escape_string when pushing any user-generated text into a mySQL database.<br /> I'm using the below code (which is tested and working) to push the submitted data from a gravity form into mySQL.</p> <p>&lt;?php<br /> add_action("gform_after_submission_9", "push_fields", 10, 2);<br /> function push_fields($entry, $form){</p> <p>$uploaderName = $entry["1"];<br /> $organiserName = $entry["2"];<br /> $organiserEmail = $entry["3"];<br /> $organiserNumber = $entry["4"];<br /> $venueNumber = $entry["5"];</p> <p>$con=mysqli_connect("hostname","username","password","dbname");<br /> mysqli_query($con,"INSERT INTO table (uploaderName, organiserName,<br /> organiserEmail, organiserNumber, venueNumber) VALUES ('$uploaderName',<br /> '$organiserName', '$organiserEmail', '$organiserNumber', '$venueNumber')");<br /> }<br /> ?&gt;</p> <p>So how do I use real_escape_string?</p> <p>I tried these two ideas but neither worked:<br /> $uploaderName = mysqli_real_escape_string($entry["1"]);<br /> and<br /> $uploaderNameX = $entry["1"];<br /> $uploaderName = mysqli_real_escape_string($uploaderNameX);</p> <p>And by "neither worked" I mean the first one crashed my entire site, and the second one just left that column blank in the mySQL table but entered all other info correctly. </p> https://legacy.forums.gravityhelp.com/topic/using-gravity-forms-with-a-separate-mysql-db-in-wordpress#post-334884 Thu, 20 Jun 2013 16:44:39 +0000 fabrams 334884@https://legacy.forums.gravityhelp.com/ <p>I want to save the data from gravity forms (wordpress dev version) into a separate mysql database so I can assign myphp admin user rights to someone just for the gravity forms' data, and to keep it separate from everything else in the wordpress mysql db. </p> <p>How do I set up gravity forms to a different mysql db? </p> https://legacy.forums.gravityhelp.com/topic/gform_after_submission-writing-to-a-mysql-database#post-313520 Sun, 09 Jun 2013 22:49:41 +0000 smartclouddesign 313520@https://legacy.forums.gravityhelp.com/ <p>Hi- I would like to take my form submission and write certain fields to a database. The fields I would need to get into variable form so I can write to the database would be name, email, website. The code below is what I found to get me started, but I don't know how to create the variables which will pull the associated fields I need.</p> <p>I have the code to write to the database, I just need to pull those variables from the form submission. If anyone can help, I'd really appreciate it.</p> <p>Thanks,<br /> Bryan</p> <p>&lt;?php<br /> add_action('gform_after_submission', 'post_to_third_party', 10, 2);<br /> function post_to_third_party($entry, $form) {</p> <p>// Need to create variables with the form values name/email/website</p> <p>}<br /> ?&gt; </p> https://legacy.forums.gravityhelp.com/topic/populating-from-and-writing-to-external-database#post-6402 Wed, 16 Jun 2010 16:35:17 +0000 Coen Jacobs 6402@https://legacy.forums.gravityhelp.com/ <p>I'm working on a project and we're about to decide wether or not use GF for the job. Main concern is populating fields from an external database and write user input to the same external database. I've never done this before and I really don't know what's possible with GF and controlling external databases.</p> <p>There are possibilities to use GF-hooks and custom plugins, but I'm not sure if I'm able to alter what GF will do with the user input. And, even more important, are we able to hook into GF saving the contents/fields of a form so we can adjust the structure of the external database to it? </p> https://legacy.forums.gravityhelp.com/topic/webservices-gravity-forms#post-193971 Tue, 02 Apr 2013 04:14:36 +0000 FFT 193971@https://legacy.forums.gravityhelp.com/ <p>Hello,</p> <p>I'm would like to know how I can call a webservice to pre-fill some fills directly from our database.</p> <p>Best regards, </p> https://legacy.forums.gravityhelp.com/topic/no-databases-available-with-awp_rg_form-global#post-194523 Tue, 02 Apr 2013 13:55:42 +0000 paire 194523@https://legacy.forums.gravityhelp.com/ <p>After updating my site to WordPress 3.5.1 every admin page dies with the message: "No databases available with Awp_rg_form (global)". There aren't any warnings or notices in the PHP logs. </p> <p>The problem is fixed by removing the Gravity Forms plugin. </p> <p>Any idea what could be causing this issue? </p> https://legacy.forums.gravityhelp.com/topic/data-storage-capacity#post-172607 Fri, 15 Mar 2013 18:06:37 +0000 jvmi 172607@https://legacy.forums.gravityhelp.com/ <p>Is there a way to determine the maximum storage capacity of the data collected via the forms? also, is there a way to know when i am nearly that capacity? </p> https://legacy.forums.gravityhelp.com/topic/creating-survey-style-questions#post-170668 Thu, 14 Mar 2013 00:58:54 +0000 rodolfo 170668@https://legacy.forums.gravityhelp.com/ <p>I have a project that was written for me in PHP and saves to a MYSQL database. It is a somewhat complex survey style form. I recently purchased gravity forms, and wanted to determine if it is worth migrating my form to it. My custom form seems to be bug ridden, and I am considering gravity forms as something that could eliminate some headaches.</p> <p>I've attached 3 sample questions here, and I'd like to know if<br /> a) these can be reproduced in gravity forms<br /> b) how exactly I can do so<br /> (I am new to this so any hand holding would be appreciated :-)</p> <p>Question 1<br /> <a href="http://www.dkmedia.net/question1.png" rel="nofollow">http://www.dkmedia.net/question1.png</a><br /> This is relatively simple; There are instructions along the top row, then there are two columns with text field input. Each one needs a label, and the one on the left (name) should only accept text type characters, while the one on the right should only accept numbers. The green + icon allows the user to add additional rows. I would like a maximum of 10 rows (2 columns/entries each).</p> <p>Question 4<br /> <a href="http://www.dkmedia.net/question4.png" rel="nofollow">http://www.dkmedia.net/question4.png</a><br /> This question is simple, just a dropdown beside a textfield that is pre-populated with the value "2013"</p> <p>Question 5<br /> <a href="http://www.dkmedia.net/question5.png" rel="nofollow">http://www.dkmedia.net/question5.png</a><br /> There are 3 rows with 2 columns each. Column 1 is a dropdown, column 2 should only accept numbers. User must fill in 3 rows. </p> <p>I know this is a lengthy request, but if this can be done within gravity forms, this will make a lot of my other questions quite a bit easier.</p> <p>Thanks!<br /> Rodolfo </p> https://legacy.forums.gravityhelp.com/topic/database-question#post-170540 Wed, 13 Mar 2013 22:57:24 +0000 rnmartinez 170540@https://legacy.forums.gravityhelp.com/ <p>I have a project already within Wordpress that currently uses a custom made form that is relatively complex and difficult to manage.</p> <p>Apart from logic style questions and being able to,handle financial/math data (so execute some formulas), I need to be able to set variable names for each response, and retrieve them from the mysql database. Additionally, some questions will require answers from previous questions to form,possible responses. For example, if I indicate that {productOrService} variable = product, then a later answer to a question may be written as "my {productOrService} will compete on price", and the user will see "my product will compete on price.".</p> <p>Can Gravity forms meet these needs?</p> <p>Rodolfo </p>