PDF repository. Adding custom overlay or text to a PDF file and saving changes in Database
Creating a database of user with appropriate fields (10) and tables (users, certificates).
Two pages are needed:
1. Admin access page where the admin will upload a PDF and assign it to a specific user. The PDFs of the user can be deleted or overwritten. The PDF contains a table and data is augmented in one of the fields (see below)
2. Client page with login (username & password).
Client will have to login to access his/hers PDF file.
On a textarea field client will have an option to enter new info saved in the field CERTIFICATE_HOLDER in table certificates and a timestamp assigned.. This info is rendered in the PDF at a particular cell. The original cell is empty.
The admin can see on his page per user the trail of these changes ( CERTIFICATE_HOLDER , timestamp). After the user edits the field, CERTIFICATE_HOLDER, and saves the changes an option to print the PDF is given.
The PDF as created by Amyuni PDF Converter version [url removed, login to view]