I have a database with all information that my Jotform will be asking

  • Profile Image
    patriccia
    Asked on January 13, 2012 at 03:05 PM

    I have a database with all information that my jotform will be asking the user to fill out in the form. How do I get jotform to access that database when the user type in registration number, so that jotbase will automatically prepopulate the rest of the information.



    This is a re-post of a comment on Prepopulating Fields to Your Jotform via URL Parameters

  • Profile Image
    patriccia
    Answered on January 15, 2012 at 07:45 AM

    No, the form is not hosted on a membership site.

  • Profile Image
    patriccia
    Answered on January 16, 2012 at 07:27 PM

    It is a excel database, I also uploaded the database to MySgl.

    The field names are:

    REG, KENNELCLUB, DOG, BREED, VARIETY, SEX, FIRST, LAST, OWNER2, ADDRESS, CITY, STATE, ZIP, PHONE, COUNTRY, BREEDER, SIRE, DAM, BDATE, PLACEBORN, EMAIL, HEIGHT, CALLNAME, MODIFIED

     

  • Profile Image
    Joel
    Answered on January 17, 2012 at 09:11 AM

    I would like to see the solution for this matter too. :)

  • Profile Image
    patriccia
    Answered on January 17, 2012 at 11:51 PM

    Thank you for helping me.  I understand what has to be done, but I am having issues getting the webpage to display.  I must be using the wrong code or not doing something correctly.

     

    I changed database name, username, password and table name.  I also used my embed code for my jotform.  But I kept getting

    This program cannot display the webpage
    Most likely causes: You are not connected to the Internet. The website is encountering problems. There might be a typing error in the address.
  • Profile Image
    patriccia
    Answered on January 18, 2012 at 07:15 PM

    Okay, now I am getting this error: No input file specified, I get this error after I press the get form button.

    here is the link to my webpage. http://www.patriciashawsss.com/page17.html

  • Profile Image
    patriccia
    Answered on January 19, 2012 at 09:58 PM

    Thank you for helping me.  It solve my problem.   But it create another.

    1- I had a online entry fee that was "disabled" so that the user would have to pay for an fee.  Now I am unable to put that code back in: checked="checked" disabled="disabled"

    2 - I need to recreate a link directly to my jotform, for those user whom registration number is not in my database.

    How can I accomplish this.

  • Profile Image
    patriccia
    Answered on January 20, 2012 at 11:15 AM

    I resolve the issue #1.  I'm using the hide condition.

     

    I still unable to create a link directly to my jotform, for those user whom information is not in my msyql.

  • Profile Image
    patriccia
    Answered on January 20, 2012 at 12:17 PM

    Yes, it can open on a separate page.

  • Profile Image
    patriccia
    Answered on January 20, 2012 at 02:08 PM

    Okay,  I'm not getting it. It seems quite simpe, but I must be leaving something out.

    The changes do not come up. 

    I have to change my php to http://pastie.org/3220108 and add http://pastie.org/3220133.  But It's not showing on my webpage. 

  • Profile Image
    patriccia
    Answered on January 20, 2012 at 07:58 PM

    Thank You

  • Profile Image
    patriccia
    Answered on January 22, 2012 at 10:47 AM

    Thank for the help,  it was working, but now it is not.  Another issue has cropped up regarding this issue.

    When I click on the yes button, nothing is happeining.  The field for me to put the number in, is not coming up.  I have to click in the field to bring the form up and sometimes it do not come up.  If it does come up and I go back, the form will not come up again. 

  • Profile Image
    patriccia
    Answered on January 22, 2012 at 04:19 PM

    It still not working.  It is not loading the form on my computer.  Is it loading for you on your computer/  The page that I am working on is page is  

    https://patriciashawsss.com/page15.html

  • Profile Image
    patriccia
    Answered on January 22, 2012 at 05:23 PM

    yeah, I already changed it back.

    Everything is working great now.  

    I am trying to tidy up mysql now.  

    My other issues with jotform, is that I have to make a choice of sending my customer back to my website to make another online entry after they submit their form or have the information that is on the form updated to mysql.  Right now, I have them redirected back to my website.  Is there a way that I could have both.

  • Profile Image
    patriccia
    Answered on January 23, 2012 at 10:53 AM

    Sorry,  what I meant is that I want the user information to also upload to my database,myysgl.   But I also want the user to also be directed back to my website so they can make another purchase.

     

    Right now, I have them directed back to my website.

  • Profile Image
    patriccia
    Answered on February 11, 2012 at 11:07 AM

    Hi,

    I have a new issue that I have been trying to resolve.

    In mysql database I use the symbol "&".  Example:  Mr. & Mrs James Doe.

    My jotform is not reading the  "&" and will do not populate the field with the complete name.  If only put in Mr.  

    If I change the "&" to "and"  the complete name will populate in the field.  "Mr and Mrs James Doe"

    How can I resolved this issue

  • Profile Image
    liyam
    Answered on February 11, 2012 at 01:47 PM

    The reason for this is because in URL parameters, the ampersand (&) actually is a separator.  If you wish to add the ampersand as a string value, you will need to have it translated via URL encode (%26).

    If you're accessing the data from your database and would want it to be posted as a URL parameter, you might want to use something like PHP's str_replace function to translate the ampersand characters.

    Example:

    <?php

    $datafromdbvalue = "Harold & Harry";

    // Returns: Harold %26 Harry
    $convertedvalue = str_replace("&", "%26", "$datafromdbvalue");

    echo "<a target="_blank" href="https://www.google.com/search?q=$convertedvalue" rel="nofollow noopener ugc" rel="nofollow">test URL params</a>";

    ?>

  • Profile Image
    patriccia
    Answered on February 11, 2012 at 06:33 PM

     I want the data to posted to my jotform field.

    You lost me.  I understand this part

    <?php

    $datafromdbvalue = "Harold & Harry";

    // Returns: Harold %26 Harry
    $convertedvalue = str_replace("&", "%26", "$datafromdbvalue");

    but I don't understand this part   echo "<a target="_blank" href="https://www.google.com/search?q=$convertedvalue" rel="nofollow noopener ugc" rel="nofollow" rel="nofollow">test URL params</a>";

     

    I already have my data field echo so how do I incoprated this.

    Sorry for not getting it.

  • Profile Image
    liyam
    Answered on February 11, 2012 at 10:15 PM

    The echo that I have in my code is just an example.  If you are to use that it will just send you to google with the variable in the search box as well as the URL parameter.

    To make it work on your own code, just change your variables (or insert the str_replace function codes) and then just leave the echo alone and it will work fine.

    Example:

    $kennel = str_replace("&", "%26", $row['KENNELCLUB']);
    $dog
    =
    str_replace("&", "%26", $row['DOG']);
    $breed
    =
    str_replace("&", "%26", $row['BREED']);

    This way, you won't have to touch anything that calls the $kennel, $dog, and $breed variables.

    Sorry for the confusion.

  • Profile Image
    patriccia
    Answered on February 12, 2012 at 01:01 AM

    Thank you, it works

  • Profile Image
    patriccia
    Answered on March 17, 2012 at 06:43 PM

    Hello, I had a issue back in January regarding upload data to my database.  You instructed me to:  Please review this user guide article on how to populate a mysql database with a form submission with a php 'thankyou' page.

    I am just now trying it out and the data is not posting to my mysql database.

  • Profile Image
    liyam
    Answered on March 18, 2012 at 01:02 AM

    Hello patriccia.  Sorry if I'm going to ask this, can you share the form ID which is having this issue? Or is this a matter of having the query inserting to your database?

    May I ask as well to post the details on a new thread so that we can make a fresh start of this case?  You may set it to private as well if some details have sensitive information in it.

    Thanks.

  • Profile Image
    jacknab
    Answered on October 11, 2012 at 11:15 PM

    Hello I am wanting to make my form to work like this thread, however i do not know anything about developing, could I pay jotform support to develope me this solution?

     

    I tried, but what I dont understand is if you must create a new database table with fields that match the jotform field names, or if you could use your existing database fields.

  • Profile Image
    jeanettebmz
    Answered on October 11, 2012 at 11:47 PM

    @jacknab

    Can you please open a new thread and provide us with more details . Hopefully somebody in the Support Staff will be able to assist you

  • Profile Image
    jeanettebmz
    Answered on July 03, 2013 at 09:57 PM

    We are very proud to announce that our team of developers have released Jotform Webhooks,  this feature would help you to transfer forms data to your own database using your own script codes

    Please find out more about it here

    Cheers!

  • Profile Image
    digiosolutions
    Answered on May 15, 2014 at 02:59 PM

    I was wondering, is something like what was asked for here possible via a Google spreadsheet on Google drive? Jotform send that order # and then prepopulate a few fields for a payment form enabling the user not to have to manually invoice orders that require manual verification and they do not want to process payments on immediately, and instead, send the new jotform url, have the user enter their order number, and have the form prepopulate their calculation total field and unique ID dummy text field and transfer it to paypal widget then onto check out?
  • Profile Image
    KadeJM
    Answered on May 15, 2014 at 05:05 PM

    @digiosolutions

    We appreciate your interest in a follow-up question to this original thread. However to avoid confusion and optimize our forum I have moved your thread here.

  • Profile Image
    patriccia
    Answered on May 19, 2014 at 10:41 AM
    New response receivedI think you have the wrong person, I did not email you.
    ...
  • Profile Image
    NRFEMS 
    Answered on January 11, 2015 at 01:14 AM

    Seems like a great solution, but I use Wix as a web editor, and cant use java scripts or create the database.php file.  Any work around for that?

     

    Seems to be a lot of requests for pre-population using mySQL, from years ago why hasn't there been a integration code?

     

    Thanks in advance for any advice

  • Profile Image
    frontrowjdh
    Answered on October 07, 2015 at 12:36 AM

    So here is a question somehow related to the conversation above. 

    I have a form in which I would like the reponder to type in NCES School ID: which is the look up key for retrieving name of school, address etc.  The database is a public website

    https://nces.ed.gov/ccd/schoolsearch/index.asp

    Is it possible to have the form look up the information above and then populate it back to the form?

    Thanks for a great support forum

     

  • Profile Image
    Chriistian
    Answered on October 07, 2015 at 06:09 AM

    Hi frontrowjdh,

     

    I have moved your concern to a separate thread so we can better assist you. You can check the thread here: http://www.jotform.com/answers/677758. We will attend to your concern on that thread accordingly.

     

    If you have any further question, please feel free to contact us again by creating a new thread
    Regards.