https://legacy.forums.gravityhelp.com/topic/database-look-up-validation Gravity Support Forums Topic: Database look-up validation en-US Mon, 20 Apr 2026 08:21:33 +0000 http://bbpress.org/?v=1.0.1 q https://legacy.forums.gravityhelp.com/search.php https://legacy.forums.gravityhelp.com/topic/database-look-up-validation#post-43808 Mon, 12 Dec 2011 16:59:21 +0000 Chris Hajer 43808@https://legacy.forums.gravityhelp.com/ <p>OK, that's AWESOME news. Please do let us know if you need anything else. </p> https://legacy.forums.gravityhelp.com/topic/database-look-up-validation#post-43805 Mon, 12 Dec 2011 16:21:42 +0000 briare 43805@https://legacy.forums.gravityhelp.com/ <p>It worked the first time…amazing. Gravity Forms just got a new promoter.</p> <p>If anything comes up, I will let you know.</p> <p>Thanks!!!! </p> https://legacy.forums.gravityhelp.com/topic/database-look-up-validation#post-43761 Mon, 12 Dec 2011 10:39:22 +0000 Chris Hajer 43761@https://legacy.forums.gravityhelp.com/ <p>Q1 - I put it up only so that it is not accessible by URL. Otherwise, people could download the file and get all the serial numbers, right? So, if your website example.com is visible at this location /home/briare/htdocs/example/index.php, you want to put it ABOVE that, so it can't be accessed at anything beginning with example.com. That's the only reason for doing it like this. If you put it in your theme folder, you can always give it a crazy long name and then just use that name in the function. Or protect it in some other way.</p> <p>My website gravity.chrishajer.com comes up here:<br /> /kunden/homepages/99/d12345678/htdocs/gravity/index.php</p> <p>So I went up one level:<br /> /kunden/homepages/99/d12345678/htdocs/numbers.txt</p> <p>That is not accessible by URL.</p> <p>Q2. You're right. On failure they never get to the confirmation page, so there is no issue there. When I wrote that for another project, I needed to do something crazy in the confirmation redirect, so I needed this. I think you will be fine using the form builder confirmation. You can use the query string if you need to send that 9 digit number to the next page. Just drop that last block of code altogether. Sorry for the confusion there.</p> <p>Q3. All this code goes in your theme's functions.php. You can learn where to put the code by reading here: <a href="http://www.gravityhelp.com/documentation/page/Where_Do_I_Put_This_Code%3F" rel="nofollow">http://www.gravityhelp.com/documentation/page/Where_Do_I_Put_This_Code%3F</a></p> <p>Be sure the change the form ID from 70, and make sure the field is input_1 - if it's the only field in the form, it will be. Let us know if you need more help. </p> https://legacy.forums.gravityhelp.com/topic/database-look-up-validation#post-43736 Mon, 12 Dec 2011 06:07:53 +0000 briare 43736@https://legacy.forums.gravityhelp.com/ <p>This is all very exciting, as you can tell from the time, I couldn't wait to get into it.</p> <p>Okay, question 1. line 26 how far up does the path need to be? Does it include the domain or is it until the directory where the Word Press directories are kept?</p> <p>Question 2. I am a bit confused on lines 41-44. It appears that I simple replace URL with my "success" page, but I am not 100% sure.</p> <p>Question 3. Now that I have tweaked your code to fit my form, how do I add it to the form.</p> <p>Thanks </p> https://legacy.forums.gravityhelp.com/topic/database-look-up-validation#post-43732 Mon, 12 Dec 2011 02:56:30 +0000 Chris Hajer 43732@https://legacy.forums.gravityhelp.com/ <p>Hi @briare - here is some code I have modified from something I used previously.</p> <p><a href="http://pastebin.com/7ANQh6Rc" rel="nofollow">http://pastebin.com/7ANQh6Rc</a></p> <p>There are 3 pieces to it:</p> <p>lines 4-20, validate the code that is entered and return a validation error if it fails<br /> lines 25-35, the actual function to compare the entered code to all codes in your file<br /> lines 39-45, the confirmation redirect</p> <p>See if this gets you started and ask questions as you go along. Thanks. </p> https://legacy.forums.gravityhelp.com/topic/database-look-up-validation#post-43270 Tue, 06 Dec 2011 19:07:17 +0000 briare 43270@https://legacy.forums.gravityhelp.com/ <p>Do you have a place for me to send it or do you want me to just add it to a posting? </p> https://legacy.forums.gravityhelp.com/topic/database-look-up-validation#post-43061 Sun, 04 Dec 2011 15:45:07 +0000 Chris Hajer 43061@https://legacy.forums.gravityhelp.com/ <p>@briare - I will help you with this on Monday. Please send me the file, or a portion of it, so I know what kind of data we're looking it. Thanks. </p> https://legacy.forums.gravityhelp.com/topic/database-look-up-validation#post-42851 Fri, 02 Dec 2011 04:20:56 +0000 briare 42851@https://legacy.forums.gravityhelp.com/ <p>lets go with the text file. That seems very easy for me to upload to the site. If we go with two forms, I would imagine there would be a submit button on form 1 which then takes them to form 2 where they enter the number and we take it from there.</p> <p>Is the validation different than what we see on Gravity forms now? The question is highlight in red. Would it be different? it does't really matter. If it is easier to do two forms, lets do two.</p> <p>I have the text file ready to go. What is my next step? </p> https://legacy.forums.gravityhelp.com/topic/database-look-up-validation#post-42816 Thu, 01 Dec 2011 20:15:02 +0000 Chris Hajer 42816@https://legacy.forums.gravityhelp.com/ <p>Your host may have already installed phpMyAdmin or some other tool to manage the database graphically. Installing it yourself would probably not be a good idea as it requires some configuration and decisions to ensure it is secure.</p> <p>We can't help you with the design and creation of the table. Creating a new table <strong>might</strong> be a good idea, to keep it separate from your WordPress tables, but that complicates access a little bit. It seems though that your table will be very simple, just one column of values. You could even just create a plain text file and store it on your web server somewhere, where it's not publicly accessible and downloadable. That might be an easier solution.</p> <p>You could create the file with one value per line just as you have pasted. </p> <p>On a very high level, you would need to read the code that is entered. So a simple one field form to check the code. If the code is valid, continue to the next form. Or, you can check the code entered on the form with all the other information, but if it's invalid, then they wasted their time entering all the information. That part is up to you: one form or two.</p> <p>So, read the code. Compare the code to all valid codes. If there is a match, let them continue, show success, something like that. If it fails, return a validation error and let them try again.</p> <p>Does it sound like a text file will work for you, or do you want to create a database table? </p> https://legacy.forums.gravityhelp.com/topic/database-look-up-validation#post-42749 Thu, 01 Dec 2011 14:08:29 +0000 briare 42749@https://legacy.forums.gravityhelp.com/ <p>Hi Chris, Any further words of wisdom on this? </p>