I have data coming into a data base that needs to be checked against form mail data for validation. The user is then authorized to automatically download a .pdf document.
Customer FIRSTNAME and LASTNAME rows in CUSTOMER table are populated in a MySQL database on a server with ODBC connectivity and username/pw permissions. The database generates a CustomerID primary key to identify unique customers.
Then, FormMail or something similar written in PHP is assigned to a website button selection and prompts the customer to enter the FIRSTNAME, LASTNAME and an email address for future correspondence. If the customers’ FIRST and LAST NAMES do not match those in the database (meaning the user has not made a purchase), they get an error message. If the names match, the .pdf file is automatically downloaded to their system.
There are two parts to this system: 1) the merchant account customer data FIRSTNAME, LASTNAME rows in the MySQL DB server, which I need to be parsed only from forwarded emails having the key phrase “sent 1.00 USD via Obopay”. Ignore all other emails coming in. 2) FormMail Admin, Form, and [login to view URL] PHP files attached to each individual button (there are 4 in all) that are labeled with any name and matches the database data with user entered data to receive the download.
I must have full access to edit the files created and implement them into my database and website.