Recently, one of our members had the need to do account balance lookup for customers only and allow them to pay their balance online. There was also the need to import a CSV file directly into MySQL tables.
In this meetup, we will take this use-case from analysis to implementation on the LAMP (Linux-MySQL-Apache-PHP) stack.
- How to import CSV files into MySQL tables with LOAD DATA INFILE and shell scripts.
- In PHP, how to authenticate incoming customers (website visitors) using their own data and show them their account balance.
- With just a token (without credit card info) how to charge their card on server side in PHP in a secure and PCI compliant manner.
- In PHP, how to record the payment and email the customer once the payment is successful.
Robert Half will sponsor pizza. So please RSVP, so we know the headcount for ordering food.
We'll be hands-on. So please bring your laptops.