St. Mary’s Parish has physical records that need to be digitized into an existing MySQL database to prevent the loss of important information for the community. Our goal is to create a bulk import function that allows the church to import CSV files containing this important information and upload the images associated with the information. This was achieved by creating PHP code files that formed the import and upload button on the database homepage and linked the connection between the code and the MySQL database. In conclusion, we created an import and upload function that enables the church to preserve their records in a MySQL database and allow them to print out the info onto a certificate. To further improve the project, adding security, reformatting the certificate printout, and fixing the search function from last year’s team would be extremely beneficial for St. Mary’s Parish.

• This report represents the work of one or more WPI undergraduate students submitted to the faculty as evidence of completion of a degree requirement. WPI routinely publishes these reports on its website without editorial or peer review.

Creator

• Lee, Adam
• Minnich, Jared
• Sarfo, Kofi
• Espinal, Javier

Subject

• Security
• Community
• Project-Based Learning
• Culture
• Innovation

Publisher

• Worcester Polytechnic Institute

Identifier

• E-project-101321-100043
• 38636

Palabra Clave

• MySQL
• XAMPP
• Database
• PHP
• Digitization

Advisor

• Sphar, Jefferson Alex

Year

• 2021

Center

• Panama City, Panama Project Center - IQP

Sponsor

• St. Mary's Parish
• Footprint Possibilities

UN Sustainable Development Goals

• 9 - Industry, Innovation and Infrastructure
• 11 - Sustainable Cities and Communities

Date created

• 2021-10-13

Resource type

• Interactive Qualifying Project

Rights statement

• In Copyright