Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
admin	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
assets	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
db	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
includes	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
uploads	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
user	[ DIR ]	drwxr-xr-x	2025-10-18 01:48
DEPLOYMENT_INSTRUCTIONS.md	3.05 KB	-rw-r--r--	2025-10-18 01:48
FIX_DUPLICATE_COMMISSIONS.md	3.63 KB	-rw-r--r--	2025-10-18 00:32
FIX_USER_EDIT_ISSUE.md	6.15 KB	-rw-r--r--	2025-10-18 00:44
IMPROVEMENTS_SUMMARY.md	4.11 KB	-rw-r--r--	2025-10-18 00:40
README.txt	2.34 KB	-rw-r--r--	2025-10-17 23:08
README_DEPLOYMENT.txt	1.74 KB	-rw-r--r--	2025-10-18 01:49
README_REFERRAL_COMMISSIONS.md	4.02 KB	-rw-r--r--	2025-10-18 00:22
SQL_CHANGES_SUMMARY.md	2.02 KB	-rw-r--r--	2025-10-18 00:25
apply_database_fixes.php	5.17 KB	-rw-r--r--	2025-10-18 00:39
check_commission_levels.php	3.16 KB	-rw-r--r--	2025-10-18 00:53
check_database_structure.php	3.9 KB	-rw-r--r--	2025-10-18 00:55
check_duplicate_commissions.php	4.38 KB	-rw-r--r--	2025-10-18 00:32
check_referrals_table.php	2.28 KB	-rw-r--r--	2025-10-18 00:39
complete_setup.sql	5.34 KB	-rw-r--r--	2025-10-18 00:25
complete_setup_for_import.sql	5.36 KB	-rw-r--r--	2025-10-18 01:59
create_table_direct.php	3.44 KB	-rw-r--r--	2025-10-18 00:09
css_test.php	999 B	-rw-r--r--	2025-10-18 02:06
debug_referral_chain.php	6.88 KB	-rw-r--r--	2025-10-18 00:54
fix_duplicate_commissions.php	2.67 KB	-rw-r--r--	2025-10-18 00:31
fix_referral_commissions.sql	677 B	-rw-r--r--	2025-10-18 00:25
fix_referral_commissions_for_import.sql	705 B	-rw-r--r--	2025-10-18 01:59
index.php	25.74 KB	-rw-r--r--	2025-10-18 02:05
index_with_css_fix.php	25.82 KB	-rw-r--r--	2025-10-18 02:06
login.php	4.15 KB	-rw-r--r--	2025-10-18 02:05
logout.php	88 B	-rw-r--r--	2025-10-17 23:02
register.php	6.58 KB	-rw-r--r--	2025-10-18 02:05
run_setup.bat	714 B	-rw-r--r--	2025-10-18 00:23
setup_referral_commissions.php	2.73 KB	-rw-r--r--	2025-10-18 00:21
test.php	59 B	-rw-r--r--	2025-10-17 23:16
test_commission_application.php	6.93 KB	-rw-r--r--	2025-10-18 00:55
test_commission_display.php	3.26 KB	-rw-r--r--	2025-10-18 00:19
test_commission_fix.php	3.16 KB	-rw-r--r--	2025-10-18 00:39
test_mobile_menu.php	2.73 KB	-rw-r--r--	2025-10-18 01:24
test_referral.php	2.07 KB	-rw-r--r--	2025-10-17 23:55
update_referral_commissions.sql	682 B	-rw-r--r--	2025-10-18 00:25
update_referral_commissions_for_import.sql	710 B	-rw-r--r--	2025-10-18 01:59
update_referrals_table.sql	398 B	-rw-r--r--	2025-10-18 00:31
update_referrals_table_for_import.sql	426 B	-rw-r--r--	2025-10-18 01:59
verify_commissions.php	3.28 KB	-rw-r--r--	2025-10-18 00:20
verify_commissions_working.php	8.2 KB	-rw-r--r--	2025-10-18 00:56

Rename

# Deployment Instructions for Share & Earn Website

## Overview
This document provides instructions for deploying your PHP-based Share & Earn website to a live hosting environment.

## Prerequisites
1. Domain name (which you already have)
2. Web hosting with PHP and MySQL support
3. FTP client (FileZilla recommended) or use your host's file manager

## Required Files for Deployment

All files in your current directory structure need to be uploaded:
```
/
├── admin/
├── assets/
├── db/
├── includes/
├── uploads/
├── user/
├── *.php files (index.php, login.php, register.php, etc.)
├── *.sql files (database structure)
└── README files
```

## Deployment Steps

### 1. Choose a Hosting Provider
You need hosting that supports:
- PHP 7.4 or higher
- MySQL database
- Apache with mod_rewrite

Recommended affordable options:
- Hostinger ($2-3/month)
- Namecheap ($3-4/month)
- Bluehost ($5-7/month)

### 2. Set Up Your Hosting Account
1. Sign up with your chosen provider
2. Connect your domain to the hosting account
3. Create a MySQL database through your hosting control panel

### 3. Update Database Configuration
Before uploading, update `includes/db.php` with your live database credentials:

```php
<?php
// Database configuration for LIVE environment
$host = 'localhost'; // Usually localhost on shared hosting
$dbname = 'your_live_database_name';
$username = 'your_live_database_username';
$password = 'your_live_database_password';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$dbname;charset=utf8", $username, $password);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
} catch(PDOException $e) {
    die("Connection failed: " . $e->getMessage());
}
?>
```

### 4. Upload Files via FTP
1. Install FileZilla or similar FTP client
2. Get FTP credentials from your hosting provider
3. Connect to your hosting account via FTP
4. Upload all files from your local shearearn folder to the public_html or www directory

### 5. Import Database Structure
1. Access phpMyAdmin through your hosting control panel
2. Create a new database
3. Select the database and click "Import"
4. Upload the SQL files:
   - complete_setup.sql
   - fix_referral_commissions.sql
   - update_referrals_table.sql
   - update_referral_commissions.sql

### 6. Test Your Website
1. Visit your domain in a web browser
2. Test all functionality:
   - Homepage
   - Registration
   - Login
   - Admin panel access

## Troubleshooting

### Common Issues:
1. **Database Connection Error**: Check your database credentials in includes/db.php
2. **404 Errors**: Ensure files are uploaded to the correct directory (usually public_html)
3. **Missing Tables**: Make sure all SQL files are imported correctly

### Permissions:
Ensure the following directories have write permissions (755 or 777):
- uploads/

## Support
If you encounter issues during deployment, contact your hosting provider's support team as they are familiar with their specific platform requirements.