/MoonBuyers

A PHP/MySQL Demonstration Project!

Primary LanguagePHPMIT LicenseMIT

MoonBuyers InterGalactic

Contact me at automated_mailbox@rigidbody.tech for access credentials.

A PHP MySQL demonstration application that manages the buying and selling of various extra-planetary bodies in an "internal business app" setting.

MoonBuyers InterGalactic is a PHP MySQL demonstration project by Chris Kearns. This repository includes everything you need to set up and start working your own project. Project utilizes multiple tables, complex queries, junction tables, full error reporting, aggressive user input sanitization, bootstrap - responsive layout with a bit of animation, and a pinch of JQuery. Note: ALL date fields throughout the demo are set 1,000 years in the future.

The demo is currently restricted to Sol System, however, feel free to add extra-solar entities... ⚠️ 😲 🛰️ 🛸 🚀 🪐

Visit and test MoonBuyers InterGalactic.

See HeadMB.php and JsIncludes.php for dependencies you'll need to consider downloading!


Links to all files with corrected tab spacing (or append '?ts=4' OR '?ts=2' to url in your browser).

Styles:

style.css

Includes:

HeadMB.php

JsIncludes.php

Sanitizer.php

Images:

favicon

SQL:

MoonBuyers-definition.sql

MoonBuyers-initialData.sql

MoonBuyers-queries.sql (read only - Do Not Import!)

How to use SQL files:

Loading Initial DataBase

public_html files:

Add New Asset

Add New Customer

Edit Asset

Main Page

Record a Transaction

Show All Accounts

Show Account By Customer ID

Show Account By Account ID

Show Account By Customer Phone

Show All Assets

Show Assets By Account ID

Show Asset By Asset ID

Show Ledger

Show Asset Ownership Chain By Asset ID

Show Total Commissions Paid by Date Range

Update Account Balance

Update Customer Details