MoonBuyers InterGalactic
A fully operational PHP/MySQL demonstration site for your review!
For site access, request a free, no obligation Credential Set today!
Show All Accounts
See the Code!SQL Definitions file.
SQL Initial Data Loading file.
SQL Query Samples.
Show Account By Customer Phone
See The Code!Both Show Account By Customer ID
and Show Account By Customer Phone
will return multiple rows if Customers have multiple accounts. Above, RigidBody Tech maintains, and thus returns, both their Buying and Selling accounts.
Show Assets Owned By Account Number
See The Code!Please feel free to test MoonBuyers InterGalactic. You can establish an account and then buy and sell assets, add to your balance, etc.
Get Credentials
Update Customer Balance
See The Code!Update Customer Balance
and Update Customer Details
are separate queries in order to facilitate differing access credential levels by employees.
Show Transactions and Commisions Paid by Date Range
See The Code!
Show Ownership Chain By Asset ID
See The Code!MoonBuyers InterGalactic
MoonBuyers InterGalactic is a PHP/MySQL demonstration project designed to convince you that the author has a grasp of database Schema design, database creation from scratch, security issues around databases, indexing, junction tables for many to many
relationships, various query constructs, and data presentation architecture client
.
server dbase server client
