How to Create PHP Stripe Subscription Database Using MySQL

Visit course website: http://bit.ly/stripe-checkout-php-combo-courses

What do you need for a database to track customers in a subscription service?

This covers the database needs to handle Stripe recurring payments for a PHP based subscription service

This section covers the creation of an SQLite3 database with a customers table. It includes the code to add records to the customers table and the testing code.

So lets see what we need to do to get that done.

We will create a database infrastructure that will be independent of the application and of the user interface.

To do that we learn how to use the PHP PDO library to interact with the database.

This will make it easy to change database engines.

Our database engine for the course is SQLite3.

It is easy to set up.

And its lets us write code that we can reuse with other databases.

To help with that we learn to use the Firefox SQLite Manager.

It makes accessing the database easy.

And we can use it to help us in testing and learning.

We will create a script to configure the database settings.

For SQLite3 that is simply the location and name of the database file.

We will create a script to configure the database settings.

For SQLite3 that is simply the location and name of the database file.

We will include in the script checks for the correct installed libraries.

And we will set the database to throw PHP exceptions for error handling.

We will also write the SQL statements to create a customers table.

The table will handle the data for logging into our service.

We will also keep some profile information about the customer in our database.

And we will have fields to track the customer subscription status.

And to process this SQL we also use the PHP PDO library.

Another SQL statement that we write adds the new customers that subscribe to our service.

Some of that data is coming from user input.

So we will learn how to use the PDO library to protect the SQL statement from tampering.

And we are also encrypting the customer's login password for another level of security.

Wow it does look like a lot to cover.
But we will break it down.

Then we put it together step by step as you go through this section.

For example we will write testing scripts.

They will help you understand what is in the code and how it works.

Plus they help insure that database code is error free.
Well thats a wrap.

Time to tool up and to get going!

See you at the first session.