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

Add to XAMPP or Similar PHP/Web Stack

• 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.