https://legacy.forums.gravityhelp.com/topic/querying-external-dataset-to-validate-number-input Gravity Support Forums Topic: Querying External Dataset to Validate Number Input en-US Mon, 06 Apr 2026 01:39:06 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/querying-external-dataset-to-validate-number-input#post-74949 Wed, 12 Sep 2012 09:17:48 +0000 Chris Hajer 74949@https://legacy.forums.gravityhelp.com/ <p>I emailed the actual code to Grant, but posted a generic version of the code here for anyone interested in this: <a href="http://pastebin.com/8LaYuDZs" rel="nofollow">http://pastebin.com/8LaYuDZs</a> </p> https://legacy.forums.gravityhelp.com/topic/querying-external-dataset-to-validate-number-input#post-73815 Tue, 04 Sep 2012 12:46:53 +0000 Chris Hajer 73815@https://legacy.forums.gravityhelp.com/ <p>Please export your form, send your CSV, and your functions.php via email to <a href="mailto:chris@rocketgenius.com">chris@rocketgenius.com</a> and I will have a crack at it.. Thanks. </p> https://legacy.forums.gravityhelp.com/topic/querying-external-dataset-to-validate-number-input#post-73784 Tue, 04 Sep 2012 10:42:16 +0000 Grant Bivens 73784@https://legacy.forums.gravityhelp.com/ <p>I'm still having issues with getting this working properly. I really need to get this working as it's for registration of an event that is in November.</p> <p>Thanks,<br /> Grant </p> https://legacy.forums.gravityhelp.com/topic/querying-external-dataset-to-validate-number-input#post-72265 Thu, 23 Aug 2012 10:04:10 +0000 Grant Bivens 72265@https://legacy.forums.gravityhelp.com/ <p>Chris,</p> <p>Thanks for your reply. I've changed the ID as you described above. My 'ID' in this case won't change as that function will always be looking at just that ID of the first array value which is the first column in a text file. Anyway that did fix that issue.</p> <p>You were right about the other issue with only passing one parameter in the first function. I'm a little confused on that. I think the "$_POST['input_1']" should be "$thiscode" in my is_code_valid function. I added the first two paramaters to the function call on line 8 but now it just validates false every time. I'm sure I'm just not connecting the dots properly.</p> <p>Here is what things look like now: <a href="http://pastebin.com/UjxrLe4g" rel="nofollow">http://pastebin.com/UjxrLe4g</a></p> <p>Thanks,<br /> Grant </p> https://legacy.forums.gravityhelp.com/topic/querying-external-dataset-to-validate-number-input#post-71636 Sun, 19 Aug 2012 21:41:08 +0000 Chris Hajer 71636@https://legacy.forums.gravityhelp.com/ <p>Are you still looking for help with this one? The topic was lost for a little while.</p> <p>The error on line 69 is because you are sending a constant, not a variable, to the function (the 'ID' part.) There's usually no reason to do that, as there is no reason to send something that does not change in the function call. That's why the error is thrown. You can do something like this:</p> <pre><code>[php] $id = &#39;ID&#39;; function is_code_valid($csvdata, $id, $thiscode) {</code></pre> <p>That would make the error go away, but I don't think it will make this work.</p> <p>On line 9 you call the function is_code_valid, with one parameter. However, on line 69, your function is using three parameters. There is probably a misunderstanding of some sort with that. </p> https://legacy.forums.gravityhelp.com/topic/querying-external-dataset-to-validate-number-input#post-69958 Tue, 07 Aug 2012 15:32:17 +0000 Grant Bivens 69958@https://legacy.forums.gravityhelp.com/ <p>Still wrestling with this... anybody have an insight to my error I'm getting? </p> https://legacy.forums.gravityhelp.com/topic/querying-external-dataset-to-validate-number-input#post-69222 Thu, 02 Aug 2012 16:28:57 +0000 Grant Bivens 69222@https://legacy.forums.gravityhelp.com/ <p>Ok, I'm getting close I think in merging the two scripts. I've got a pastie with what I've got so far here: <a href="http://pastie.org/4379729" rel="nofollow">http://pastie.org/4379729</a></p> <p>I'm getting an error on line 69:</p> <p>"Parse error: syntax error, unexpected T_CONSTANT_ENCAPSED_STRING, expecting '&amp;' or T_VARIABLE in /home/ok/public_html/wp-content/themes/twentyten/functions.php on line 69"</p> <p>Am I missing something on how I'm passing those variables from Gravity Forms to this function?</p> <p>My data set still looks like this: <a href="http://pastie.org/4367213" rel="nofollow">http://pastie.org/4367213</a></p> <p>I haven't gotten there yet but I'm wondering if the query string will still work as well. What does the $lead array look like? Will I need to change that to look at my $csvdata array instead? I'll be wanting to pass all the values of the array for the matched ID. Meaning in my example data set I'll want to pass the ID, Name, and Town.</p> <p>Thanks,<br /> GB </p> https://legacy.forums.gravityhelp.com/topic/querying-external-dataset-to-validate-number-input#post-68823 Tue, 31 Jul 2012 16:38:43 +0000 Grant Bivens 68823@https://legacy.forums.gravityhelp.com/ <p>Chris,</p> <p>This definitely helps out a ton! I've got the code you supplied working on my form(s). I'm trying to expand it a little bit by using a csv file instead of just a list of IDs in a single column. Here is an <a href="http://pastie.org/4367213" rel="nofollow">example of my dataset</a>.</p> <p>I've got a script that I've stolen from php.net which splits this data from my text file into an array for each row and <a href="http://pastie.org/4367216" rel="nofollow">looks like this</a>.</p> <p>The output of that script against my data <a href="http://pastie.org/4367225" rel="nofollow">looks like this</a>.</p> <p>Is there any way you could help me marry your function with this csv to array script so it just searches the id's and the returns the three values within the matching ID's array as query strings?</p> <p>Thanks,<br /> GB </p> https://legacy.forums.gravityhelp.com/topic/querying-external-dataset-to-validate-number-input#post-68154 Thu, 26 Jul 2012 23:12:12 +0000 Chris Hajer 68154@https://legacy.forums.gravityhelp.com/ <p>Here is a good discussion regarding that:<br /> <a href="http://www.gravityhelp.com/forums/topic/database-look-up-validation" rel="nofollow">http://www.gravityhelp.com/forums/topic/database-look-up-validation</a></p> <p>I created a text file with 2000 numbers in it. Take a look at that and see if you get any ideas or need any help with that. </p> https://legacy.forums.gravityhelp.com/topic/querying-external-dataset-to-validate-number-input#post-68113 Thu, 26 Jul 2012 18:01:30 +0000 Grant Bivens 68113@https://legacy.forums.gravityhelp.com/ <p>I'm done some searching around the form and I'm just throwing this out there to see if anybody has any good ideas before I start doing anything with this. Here is the scenario:</p> <p>1. I have a form where users have to enter their ID number.<br /> 2. I have a dataset that matches those ID numbers with their address.<br /> 3. I need to validate that the ID they enter is in fact an actual ID and not made up.<br /> 4. I also need to display their address on the screen below the ID field so they can make sure they input their ID correctly.</p> <p>My dataset that I need to validate against is quite large (1,818 IDs). They are a 7 digit number that all start with 0 and range from 0071264 to 0584684 and are obviously not consecutive numbers (that really doesn't matter too much I suppose). I can put this dataset wherever I need to, in the WP database, csv or text file on the server, etc...</p> <p>The ID number is the first thing they enter on the form and I need it to validate after they enter in their ID (not upon form submission).</p> <p>I also have the form setup to redirect back to itself with half of the form being filled in automatically via query strings from the initial submission. The reason for this is users will be submitting the form anywhere from 1-10 times to register each person in their group. I realize that will require the form to revalidate the ID number when the form loads again after redirection and the fields are filled in via query strings.</p> <p>So if you have any insight or if you've seen anybody do anything similar to this and wouldn't mind giving me a push start that would be awesome. Any other suggestions would be welcomed.</p> <p>Thanks,<br /> GB </p>