Gecko [ fastearnlimited.com ]

Name	Size	Permission	Date
data	[ DIR ]	drwxr-xr-x	2025-09-15 23:22
uploads	[ DIR ]	drwxr-xr-x	2025-09-15 18:00
COMPLETE_SETUP_GUIDE.md	5.02 KB	-rw-r--r--	2025-09-15 23:45
DATABASE_SETUP.md	2.84 KB	-rw-r--r--	2025-09-15 23:41
FIX_ACCESS_DENIED.md	2.36 KB	-rw-r--r--	2025-09-16 00:07
MIGRATION_SUMMARY.md	4.28 KB	-rw-r--r--	2025-09-15 23:45
NEXT_STEPS.md	2.18 KB	-rw-r--r--	2025-09-15 23:45
PHPMYADMIN_SETUP_GUIDE.md	3.61 KB	-rw-r--r--	2025-09-15 23:43
QUICK_FIX_INSTRUCTIONS.md	1.99 KB	-rw-r--r--	2025-09-16 00:09
admin-dashboard.html	25.26 KB	-rw-r--r--	2025-09-15 17:29
admin-login.html	5.25 KB	-rw-r--r--	2025-09-15 02:24
admin-profile.html	24.21 KB	-rw-r--r--	2025-09-15 17:43
analytics.html	25.08 KB	-rw-r--r--	2025-09-15 16:13
check_mysql.php	1.33 KB	-rw-r--r--	2025-09-15 23:44
cleanup_duplicates.php	1.46 KB	-rw-r--r--	2025-09-15 23:08
complete_workflow_test.php	4.46 KB	-rw-r--r--	2025-09-15 23:22
create_test_user.php	1.15 KB	-rw-r--r--	2025-09-15 23:20
database.php	4.29 KB	-rw-r--r--	2025-09-15 23:43
database_mysql.php	9.98 KB	-rw-r--r--	2025-09-16 00:08
db_config.php	587 B	-rw-r--r--	2025-09-16 00:07
demo-enhanced.html	45.46 KB	-rw-r--r--	2025-09-15 01:43
deposit.html	10.83 KB	-rw-r--r--	2025-09-15 17:08
error_log	825 B	-rw-r--r--	2025-10-04 15:48
fastearnads.sql	6.12 KB	-rw-r--r--	2025-09-15 23:39
fastearnads_tables_only.sql	5.96 KB	-rw-r--r--	2025-09-16 00:07
final_test.php	4.73 KB	-rw-r--r--	2025-09-15 23:29
import_database.bat	1.03 KB	-rw-r--r--	2025-09-15 23:45
index.php	50.11 KB	-rw-r--r--	2025-09-15 23:40
manage-ads.html	25.39 KB	-rw-r--r--	2025-09-15 16:12
manage-users.html	42.4 KB	-rw-r--r--	2025-09-15 16:54
manage-withdraws.html	49.19 KB	-rw-r--r--	2025-09-15 15:54
migrate_data.php	1.6 KB	-rw-r--r--	2025-09-15 23:40
simple-login.html	1.19 KB	-rw-r--r--	2025-09-15 02:08
start_mysql.bat	948 B	-rw-r--r--	2025-09-15 23:45
test_admin_approval.php	3.55 KB	-rw-r--r--	2025-09-15 23:21
test_connection_with_user.php	1.9 KB	-rw-r--r--	2025-09-15 19:19
test_db_connection.php	1.54 KB	-rw-r--r--	2025-09-15 23:41
test_deposit_fix.php	2.88 KB	-rw-r--r--	2025-09-15 23:09
test_frontend.html	3.49 KB	-rw-r--r--	2025-09-15 23:22
test_user_activity_history.php	2.96 KB	-rw-r--r--	2025-09-15 23:21
user-ads.html	18.36 KB	-rw-r--r--	2025-09-15 14:39
user-dashboard.html	47.77 KB	-rw-r--r--	2025-09-15 23:26
user-login.html	5.78 KB	-rw-r--r--	2025-09-15 02:27
user-profile.html	33.93 KB	-rw-r--r--	2025-09-15 18:33
user-register.html	7.56 KB	-rw-r--r--	2025-09-15 02:27
user-transactions.html	31.83 KB	-rw-r--r--	2025-09-15 22:58
user-withdraw.html	29.48 KB	-rw-r--r--	2025-09-15 21:52
user-withdrawals.html	29.17 KB	-rw-r--r--	2025-09-15 21:51
waiting-approval.html	5.46 KB	-rw-r--r--	2025-09-15 03:23

Rename

# FastEarnAds Database Setup Guide

This guide will help you set up the MySQL database for your FastEarnAds application using phpMyAdmin.

## Prerequisites

1. phpMyAdmin installed and running
2. MySQL server running
3. Access to phpMyAdmin interface

## Step 1: Create the Database

1. Open phpMyAdmin in your browser (usually at http://localhost/phpmyadmin)
2. Click on the "New" button in the left sidebar
3. Enter "fastearnads" as the database name
4. Select "utf8mb4_unicode_ci" as the collation
5. Click "Create"

## Step 2: Import the Database Structure

1. Select the "fastearnads" database from the left sidebar
2. Click on the "Import" tab at the top
3. Click "Choose File" and select the `fastearnads.sql` file from your project
4. Make sure "Format" is set to "SQL"
5. Click "Go" to import the database structure

## Step 3: Configure Database Connection

1. Open the `db_config.php` file in your project
2. Modify the database connection parameters if needed:
   ```php
   define('DB_HOST', 'localhost');    // Your database host
   define('DB_NAME', 'fastearnads');  // Your database name
   define('DB_USER', 'root');         // Your database username
   define('DB_PASS', '');             // Your database password
   ```

## Step 4: Migrate Existing Data (Optional)

If you have existing data in JSON files that you want to transfer to the MySQL database:

1. Run the migration script:
   ```bash
   php migrate_data.php
   ```

## Step 5: Test the Connection

1. Start your PHP server:
   ```bash
   php -S localhost:8000 -t public
   ```
2. Visit http://localhost:8000 in your browser
3. The application should now be using the MySQL database

## Troubleshooting

### Common Issues:

1. **Access denied for user 'root'@'localhost'**
   - Make sure your MySQL root user has the correct password
   - Update the `DB_PASS` in `db_config.php` if needed

2. **Database 'fastearnads' doesn't exist**
   - Make sure you've created the database in Step 1

3. **Connection failed**
   - Check that your MySQL server is running
   - Verify the database connection parameters in `db_config.php`

### Verifying the Setup:

You can verify that everything is working by running:
```bash
php db_config.php
```

This should output your database configuration details.

## Database Structure

The database includes the following tables:

- `users` - User accounts and information
- `deposits` - User deposit records
- `user_activities` - User activity logs
- `ads` - Advertisement information
- `withdraws` - Withdrawal requests
- `withdraw_methods` - Available withdrawal methods
- `user_withdraw_permissions` - User-specific withdrawal permissions
- `settings` - Application settings
- `admin_activities` - Admin activity logs

Each table is designed to match the structure of your existing JSON data files.