A virtual money system developed using PHP and MySQL that features a user login system, balance reporting, transaction logs, and a transfer money page.
## Deliverables
This is the ground-work for a website idea I had. I would like to have an extremely simple website that meets the following requirements:
- User Login using Sessions, authentication using encrypted password in MySQL DB
- (Potential) Database design below
Table Name: Users
| ID | Username | md5(Password) | Email | DateCreated | Balance | TransCount |
| | | | | | | |
| | | | | | | |
Table Name: Transactions
| ID | Donor | Recipient | Amount | Date |
| | | | | |
| | | | | |
Table Name: Username History
| ID | FormerUsername | NewUsername | Date | IP |
| | | | | |
Table Name: Logins
| Date | UserID | IP | Time |
| | | | |
Table Name: Settings
| Setting | Value |
| | |
| | |
Table Name: Session
| SessionID | SessionKey | UserID | IP |
| | | | |
**File Hierarchy**
- Root
o config (folder)
? [login to view URL]
? mysql db connection information
? [login to view URL]
? common functions
o [login to view URL]
? Login, about, etc
o [login to view URL]
? html form: amount, recipient --> Submit --> [login to view URL]
o [login to view URL] (see above)
o [login to view URL]
? balance, recent transactions, settings
o [login to view URL]
? change email, username, password
- To ensure that the worker has read this information and is a human, please include the following comment in your bid: "I am a human"