https://legacy.forums.gravityhelp.com/topic/gform_after_submission-writing-to-a-mysql-database Gravity Support Forums Topic: gform_after_submission - writing to a MySQL database en-US Sun, 19 Apr 2026 18:40:47 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/gform_after_submission-writing-to-a-mysql-database#post-318047 Tue, 11 Jun 2013 23:43:17 +0000 David Peralty 318047@https://legacy.forums.gravityhelp.com/ <p>Not assuming anything is how I helped ;) Glad you got it sorted. </p> https://legacy.forums.gravityhelp.com/topic/gform_after_submission-writing-to-a-mysql-database#post-317585 Tue, 11 Jun 2013 17:45:07 +0000 andrew carbn 317585@https://legacy.forums.gravityhelp.com/ <p>Thanks David! By assuming I am an idiot, you have helped me to realise I am an idiot! :-)</p> <p>I didn't realise there is more than one functions.php file!</p> <p>It's all working now. Couldn't be happier right now.</p> <p>Thanks loads for your help. </p> https://legacy.forums.gravityhelp.com/topic/gform_after_submission-writing-to-a-mysql-database#post-317472 Tue, 11 Jun 2013 16:17:21 +0000 David Peralty 317472@https://legacy.forums.gravityhelp.com/ <p>You shouldn't have received that error message. You are adding this code to the functions.php file for your theme, correct? In your wp-content/themes/selectedtheme/functions.php file? </p> https://legacy.forums.gravityhelp.com/topic/gform_after_submission-writing-to-a-mysql-database#post-317471 Tue, 11 Jun 2013 16:17:21 +0000 David Peralty 317471@https://legacy.forums.gravityhelp.com/ <p>You shouldn't have received that error message. You are adding this code to the functions.php file for your theme, correct? In your wp-content/themes/selectedtheme/functions.php file? </p> https://legacy.forums.gravityhelp.com/topic/gform_after_submission-writing-to-a-mysql-database#post-317438 Tue, 11 Jun 2013 15:39:50 +0000 andrew carbn 317438@https://legacy.forums.gravityhelp.com/ <p>Hi Bryan thanks for the quick reply. </p> <p>Yes the mySQL query does execute correctly by its self.</p> <p>I tried adding the code to functions.php but it kept crashing my site with an error code saying add_action... was undefined. So I removed just that line and that stopped it from crashing. I then added the add_action line into the php of the page, just above the form short-code, but again nothing was happening.</p> <p>I'm new to PHP and mySQL but I'm reasonably sure the problem is that the hook is not firing at all. Is there a way to check? </p> https://legacy.forums.gravityhelp.com/topic/gform_after_submission-writing-to-a-mysql-database#post-317328 Tue, 11 Jun 2013 13:32:23 +0000 smartclouddesign 317328@https://legacy.forums.gravityhelp.com/ <p>Andrew- I did get my code to work and send me an email (test) after submission. Make sure you put this code in your functions.php file of your theme. I'm on a friend's computer now (mine is in the Apple shop). Later this week when I get it back (hopefully tomorrow), if you are still having issues, I'll write to a dB to test the code.</p> <p>Does your PHP code write to a database if executed on it's own?</p> <p>Bryan </p> https://legacy.forums.gravityhelp.com/topic/gform_after_submission-writing-to-a-mysql-database#post-317312 Tue, 11 Jun 2013 13:04:57 +0000 andrew carbn 317312@https://legacy.forums.gravityhelp.com/ <p>Hey,</p> <p>I'm also trying to do exactly the same thing. I have a bit more code BUT IT ISN'T WORKING FOR ME.</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>The Entry Object is detailed here:<br /> <a href="http://www.gravityhelp.com/documentation/page/Entry_Object" rel="nofollow">http://www.gravityhelp.com/documentation/page/Entry_Object</a></p> <p>Hope this gives you some ideas. The code above shows no errors but also has no effect. </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>