Database With Web Form
I issue debit cards. My clients need to be able to CHECK to see if their debit card has been funded. I need a web form that will ask the client for his CARD NUMBER once the client clicks submit it should then display a page with his status.
I also want to be able to deliver the response statuses in a way that would work with
GET and POST commands so that I can deliver statuses via HTTP.
Database Fields:
I need to able to upload data daily, existing records need to get updated with new or revised data and new records created for non existing data:
Date Issued (Date Field)
Card Number (Numerical Field)
Office Number (Numerical Field)
Card Status (text field – Awaiting Deposit, Funded)
*Admin Fee (Currency)
Preparer Fee (Currency
Date Funded (Date Field)