What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    php script to export data to sql database

    Asked by techknowvision on January 06, 2012 at 11:39 AM

    Hi,

    I built a website for a company whos previous website developer had a "VIP" form setup on their site. Once the user submits the form it would automatically populate into a sql database usually at midnight. The old web company sent me the .php script that was being used as well as the .sql database structure file. Right now I have a basic email form on their site and they go in and manually add the entrys to their database. I want to get the automated system back in place for them. Is this possible to accomplish with JotForm? I can send you over the php file and the sql file the web company sent me. I just dont want to post it on a public board.

    Please advise.

    Thank you!

    Matt

    Page URL:
    http://www.adventureparkusa.com/vip.php

  • Profile Image

    Answered by fxr on January 06, 2012 at 12:45 PM

    Hi Matt,

    Have you seen this User Guide article ? -> http://www.jotform.com/help/126-How-to-Insert-or-update-form-submissions-to-your-MySQL-database-using-PHP

    Its a guide on how populate a mysql database using a custom thankyou URL for your JotForm.

     

    Rather than looking at editing that existing script, which must have ran on a cron job on a webserver, this may be a better approach to take.