Gravity Support Forums Topic: Grabbing $_POST to simulanteously store in a second database

Gravity Support Forums Topic: Grabbing $_POST to simulanteously store in a second database https://legacy.forums.gravityhelp.com/topic/grabbing-_post-to-simulanteously-store-in-a-second-database Gravity Support Forums Topic: Grabbing $_POST to simulanteously store in a second database en-US Mon, 20 Apr 2026 01:16:02 +0000 http://bbpress.org/?v=1.0.1 <![CDATA[Search]]> q https://legacy.forums.gravityhelp.com/search.php TheWizardGuy on "Grabbing $_POST to simulanteously store in a second database" https://legacy.forums.gravityhelp.com/topic/grabbing-_post-to-simulanteously-store-in-a-second-database#post-34372 Sat, 03 Sep 2011 16:44:16 +0000 TheWizardGuy 34372@https://legacy.forums.gravityhelp.com/ Chris: Thank-you! Thank-you! I will try this out and get back to you! Lawrence Chris Hajer on "Grabbing $_POST to simulanteously store in a second database" https://legacy.forums.gravityhelp.com/topic/grabbing-_post-to-simulanteously-store-in-a-second-database#post-34289 Fri, 02 Sep 2011 18:43:24 +0000 Chris Hajer 34289@https://legacy.forums.gravityhelp.com/ Looks like in my example I forgot to single quote the $entry['1'], so it's passed as unquoted to mysql_query, which won't work. Try building the query separately, then pass it to mysql_query: <pre><code>[php] $query = 'INSERT INTO gns_registration (fname) VALUES (\'' . $entry["1"] . '\')'; mysql_query($query, $con);</code></pre> Sorry about the earlier syntax error. I will edit that now. TheWizardGuy on "Grabbing $_POST to simulanteously store in a second database" https://legacy.forums.gravityhelp.com/topic/grabbing-_post-to-simulanteously-store-in-a-second-database#post-34281 Fri, 02 Sep 2011 17:23:26 +0000 TheWizardGuy 34281@https://legacy.forums.gravityhelp.com/ I think I'm missing something. This line works perfectly and puts a new record into the table: <code>mysql_query("INSERT INTO gns_registration (fname) VALUES ('testvalue')", $con);</code> (and I started to cheer and say, "Hey that made my long weekend; I can relax") but this one: <code>mysql_query("INSERT INTO gns_registration (fname) VALUES ($entry['1']", $con);</code> generates an error message: <code>Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING'</code> (and that made me sad) Have I misunderstood or am I typing something really wrong? Lawrence Chris Hajer on "Grabbing $_POST to simulanteously store in a second database" https://legacy.forums.gravityhelp.com/topic/grabbing-_post-to-simulanteously-store-in-a-second-database#post-31425 Tue, 02 Aug 2011 11:32:53 +0000 Chris Hajer 31425@https://legacy.forums.gravityhelp.com/ Couple things to make this work. This line: <pre><code>add_action("gform_post_submission_1", "post_submission", 10, 2);</code></pre> You need to change the "post_submission" there to the name of your function. You're hooking YOUR function to the "gform_post_submission" action. Since the name of your function is store_in_db2 the line above should look like this: <pre><code>add_action("gform_post_submission_1", "store_in_db2", 10, 2);</code></pre> Otherwise, your function will never run. Also in that line: this hook will be run for form #1 only (that's the _1 added to the end of the hook name.) Be sure the ID of your form is 1. If not, change this number to match your form. Finally, in the same line, you're saying that 2 arguments are accepted (that's what the 2 at the end is.) So, you should call your function with 2 arguments. This line: <pre><code>function store_in_db2($entry){</code></pre> Should look like this: <pre><code>function store_in_db2($entry, $form){</code></pre> After that, you will be able to get all the values from your form submission. You can determine the field id to use by looking at the source of a rendered page. For the name field, if you're using a name field, the ID might look like this: <pre><code><input type='text' name='input_1.3' id='input_12_1_3' value='' tabindex='1' /> <input type='text' name='input_1.6' id='input_12_1_6' value='' tabindex='2' /></code></pre> In that case, the values you want are 1.3 and 1.6. Maybe it's not clear from this example that input_12_1_3 becomes 1.3, but if you dump the $entry array, you will see this: <pre><code>[1.3] => Chris2 [1.6] => Hajer2 [2.1] => 1234 Maple [2.3] => Berwyn [2.4] => IL [2.5] => 60402 [2.6] => United States [3] => this is my awesome comment</code></pre> That is part of a submission I made with this form: <a href="http://gravity.chrishajer.com/testing-the-post/" rel="nofollow">http://gravity.chrishajer.com/testing-the-post/</a> If you look at the source of the page, you will see the input_12_1_3 and input_12_1_6 I referenced above, and how they correlate to the [1.3] and [1.6] in the $entry object. In your MySQL query line, if your form were identical to mine, you would do this: [EDITED 9/2/2011] <pre><code>[php] $query = 'INSERT INTO affiliates (FirstName, LastName) VALUES (\''. $entry['1.3'] . '\', \'' . $entry['1.6'] . '\')'; mysql_query($query);</code></pre> For me, that resulted in this query being generated: <pre><code>INSERT INTO affiliates (FirstName, LastName) VALUES ('Chris2', 'Hajer2')</code></pre> Replace the 1.3 and 1.6 with the id of the form fields from your form and you'll be good to go. Please post if you need more assistance, or if this works out for you. Thanks. imagebox on "Grabbing $_POST to simulanteously store in a second database" https://legacy.forums.gravityhelp.com/topic/grabbing-_post-to-simulanteously-store-in-a-second-database#post-31379 Mon, 01 Aug 2011 19:27:17 +0000 imagebox 31379@https://legacy.forums.gravityhelp.com/ Thanks - I realize this requires custom PHP...that is not a problem. I am just having a problem identifying exactly how gform_post_submission works. I have placed the following in my functions.php file. I know this is not correct, but I am looking to get put on the right track. <a href="http://www.pastie.org/2306344" rel="nofollow">http://www.pastie.org/2306344</a> Thanks Carl Hancock on "Grabbing $_POST to simulanteously store in a second database" https://legacy.forums.gravityhelp.com/topic/grabbing-_post-to-simulanteously-store-in-a-second-database#post-31306 Mon, 01 Aug 2011 11:29:47 +0000 Carl Hancock 31306@https://legacy.forums.gravityhelp.com/ You have to use the gform_post_submission hook which has access to the Entry Object which contains the data. You'd then have to write custom PHP to read the values you want from the Entry object and insert them into your database table. Here is documentation on the gform_post_submission hook: <a href="http://www.gravityhelp.com/documentation/page/Gform_post_submission" rel="nofollow">http://www.gravityhelp.com/documentation/page/Gform_post_submission</a> Here is documentation on the entry object: <a href="http://www.gravityhelp.com/documentation/page/Entry_Object" rel="nofollow">http://www.gravityhelp.com/documentation/page/Entry_Object</a> So this requires knowledge of PHP and hook usage to be able to implement it properly. You want to use the gform_post_submission hook because this is going to give you access to the data AFTER form validation has taken place. imagebox on "Grabbing $_POST to simulanteously store in a second database" https://legacy.forums.gravityhelp.com/topic/grabbing-_post-to-simulanteously-store-in-a-second-database#post-31270 Sun, 31 Jul 2011 12:21:19 +0000 imagebox 31270@https://legacy.forums.gravityhelp.com/ I have the user registration add-on setup and its working great. However I have a separate affiliate script running outside of the confines of wordpress. When a user fills out the gravity form and is added to the WP database I need to be able to grab the $_POST entry variables and store them in a separate database for the affiliate script. I realize this is custom, but I need some guidance on gform_post_submission I think after reading the forums that it should be pretty easy to do, but I can't seem to figure out gform_post_submission. I see that each $_POST is actually stored in and entry array. Is it as simple as creating a basic MySQL function to store each $entry[]; submission in my second database?