JaxPHP / JaxWeb meetup: data import, lookup, and payment app on LAMP

This is a past event

13 people went

Every 3rd Wednesday of the month

SpinSpire (new office)

6318 Arlington Rd · Jacksonville, FL

How to find us

Park at our building if there's space; otherwise just park at the hair salon parking lot right across from us. Enter through the main front entrance of the building.

Location image of event venue


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.
- Using pure client-side JavaScript, how to allow them to pay via Stripe or other payment services.
- 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.