Creating a bank transaction history with PHP + Astra's Stargate REST API

Getting Started

Start by creating free tier Astra database found at https://astra.datastax.com.
Create a keyspace called bank.
Import the Bank Transactions Studio notebook that contains the transactions schema, some example queries, and example SAI indexes. This schema is also found in the transactions.cql file.
Load data. Download the secure connect bundle for the Astra database. Download dsbulk. Decompress transactions.csv.gz. Load the data with:

dsbulk load \
-b secure-connect-datastax-bank.zip \
-k bank -t transactions \
-u username -p password \
-header true \
-url transactions.csv

Install the XAMPP stack from the apache friends website.
Put the contents of the htdocs directory into the XAMPP or web server's htdocs/bank directory.
Copy the db-sample.ini file to db.ini and replace the values with the information from your Astra database.
Go to http://localhost/bank to find the interface to your bank transactions store.

Name		Name	Last commit message	Last commit date
htdocs		htdocs
.gitignore		.gitignore
LICENSE		LICENSE
README.md		README.md
bank-transactions.studio-nb.tar		bank-transactions.studio-nb.tar
transactions.cql		transactions.cql
transactions.csv.gz		transactions.csv.gz