⚙️ System Configuration
API Configuration
Enter your PHP API URL to connect to the MySQL database.
This is typically: http://your-domain.com/api.php
📋 Setup Instructions:
- Install MySQL Database:
- Use phpMyAdmin to import
database_schema.sql - This creates the expense_tracker database with all tables
- Use phpMyAdmin to import
- Upload PHP Files:
- Upload
config.phpandapi.phpto your server - Update database credentials in
config.php
- Upload
- Test API:
- Visit:
http://your-domain.com/api.php?action=getPeople - Should return JSON with list of people
- Visit:
- Connect Here:
- Enter your API URL above (e.g., http://localhost/expense-tracker/api.php)
- Click "Connect to API"
- If successful, you can start using the app!
💡 Default Users (Password: admin123):
- admin (Admin) - Full access
- manager (Sub-Admin) - Management access
- john (User) - Personal access
- sarah (User) - Personal access
⚠️ Change these passwords after first login!
🔗 MySQL API Setup (Admin Only)
Connect to your MySQL database via the PHP API backend
- Database Setup:
- Import
database_schema.sqlto phpMyAdmin - This creates 10 tables with sample data
- Default users: admin, manager, john, sarah (password: admin123)
- Import
- Upload PHP Files:
- Upload
config.phpto your server - Upload
api.phpto your server - Update database credentials in config.php
- Upload
- API URL:
- Local:
http://localhost/expense-tracker/api.php - Online:
https://yoursite.com/api.php
- Local:
- Connect:
- Paste your API URL below and click Connect
- Or enter it on the login screen
📝 Quick Setup Guide
For XAMPP (Local):
1. Start Apache + MySQL
2. Import database_schema.sql to phpMyAdmin
3. Copy config.php and api.php to: C:\xampp\htdocs\expense-tracker\
4. API URL: http://localhost/expense-tracker/api.php
For Online Hosting:
1. Upload files via FTP
2. Import database via phpMyAdmin
3. Update config.php with hosting credentials
4. API URL: https://yoursite.com/api.php
Default Login:
Username: admin
Password: admin123
1. Start Apache + MySQL
2. Import database_schema.sql to phpMyAdmin
3. Copy config.php and api.php to: C:\xampp\htdocs\expense-tracker\
4. API URL: http://localhost/expense-tracker/api.php
For Online Hosting:
1. Upload files via FTP
2. Import database via phpMyAdmin
3. Update config.php with hosting credentials
4. API URL: https://yoursite.com/api.php
Default Login:
Username: admin
Password: admin123
Today's Income
₹0.00
Today's Expenses
₹0.00
Daily Balance
₹0.00
Today's Expenses by Person
Today's Transactions
🔍 Filters
Period Income
₹0.00
Period Expenses
₹0.00
Period Balance
₹0.00
Period Expenses by Person
Expense by Category
Expense by Person
Income by Category
Expense by Sub-Category
Income by Person
Transaction Type Distribution
Period Transactions
🏗️ Project Management
Total Projects
0
Active Projects
0
Total Budget
₹0.00
All Projects
👥 User Management
Total Users
0
Admins
0
Regular Users
0
All Users
👷 Labor Management
Total Labours
0
Active Labours
0
Contractors
0
Labour Directory
Edit labour details, mark attendance manually, or open the monthly calendar.| Date | Name | Contractor | Day | Work | Rate (₹) | Per Day (₹) | Total (₹) | Paid (₹) | Outstanding (₹) | ||
|---|---|---|---|---|---|---|---|---|---|---|---|
| ⏳ Loading... | |||||||||||
🏢 Contractor Management
Total Contractors
0
Active Contractors
0
Total Salary
₹0
Total Paid
₹0
Outstanding
₹0
All Contractors
Pending Approvals
0
Pending Income
₹0.00
Pending Expenses
₹0.00