php script to export data to sql database

  • Profile Image
    techknowvision
    Asked 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

  • Profile Image
    fxr
    Answered 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.