PDFForms template - fill PDF forms with database data

With the help of PDFForms template, you can automate the process of filling PDF forms. You can fill PDF Forms using the data coming from the database, save those forms, display on the page, send them via email etc.

You can get this template for $50.

In this live demo, you can either play with the sample PDF forms or you can upload your own form. If you need to fill your form with some sample data use SQL query select * from test.

How it works

Step 1. Upload a new PDF form

Step 2. Specify SQL Query that will populate this form. Map form fields to database fields.

Step 3. Populate and display forms or use API to do this automatically in your projects.

Screenshots and live demos

Sample PDF Form

Mapping database fields to PDF form fields

Filled form

Changes history

Version 1 - April 2020

  • Upload forms, map database fields to form fields.
  • Fill forms, save to the hard drive, display in the web browser, send via email.

Live demo

You can use any of forms already uploaded to this live demo or upload your own form and play with it.

Enter live demo

System requirements

  • Version 10.3 or better of PHPRunner, ASPRunner.NET or ASPRunnerPro
  • Supported databases are MySQL, Oracle, MS Access, SQL Server and Postgre

Extensibility

Now it is time to do something that is actually useful. After you added PDFForms template to your project you can manipulate PDF forms from your events and buttons. You can use these functions in any server-side event.

Note: Temporary file will be saved to templates_c folder, make sure it is writeable by the web server user.

Populate the form and save it the hard drive

PHPRunner

ASPRunner.NET

ASPRunnerPro

Populate the form and display in the web browser

It makes the most sense to use this function at the very end of events like AfterAdd/AfterEdit or BeforeDisplay. This should be the last statement in the event code.

PHPRunner

ASPRunner.NET

ASPRunnerPro

Populate the form and send it via email

PHPRunner

ASPRunner.NET

ASPRunnerPro

Frequently Asked Questions

How to setup this template on the web server

- PDFForms template utilizes an excellent PDFtk software package. On Linux web server you need to have this package installed. It may be installed already or you can talk to your web hosting company in this regard. You would also need to go to the Settings table and specify the path to PDFtk executable. On Windows web hosting you need to make sure that web server user has permissions to run EXE files. PDFForms template already comes with Windows version of PDFtk executable so you only need to take care of the permissions part.

- PHP only - make sure that exec function is enabled in PHP settings.

- Write permissions need to be set on the files and templates_c folders. This is where PDF forms and temporary PDF files will be stored.

Do I need Adobe Acrobat in order to create PDF Forms?

While Adobe Acrobat is one of the most popular options to create PDF forms there are free and alternatives.

  1. PDFEscape
  2. JotForm
  3. DocHub
  4. Platoforms
  5. Wufoo