Email Marketing Script Documentation

1. Ensure MySQL is installed: Make sure MySQL is running on your local or remote server.
2. Create the Database: Run the following command in your MySQL terminal or a database management tool like phpMyAdmin or MySQL Workbench:

   -- Create database
   CREATE DATABASE your_email_app_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

3. Create the Database: Run the following command in your MySQL terminal or a database management tool like phpMyAdmin or MySQL Workbench:
   -- Create database
   CREATE DATABASE your_email_app_db CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
   -- Create database user (optional but recommended)
   CREATE USER 'email_app_user'@'localhost' IDENTIFIED BY 'strong_password_here';
   GRANT ALL PRIVILEGES ON your_email_app_db.* TO 'email_app_user'@'localhost';
   FLUSH PRIVILEGES;

4. Create the user: Run the following command in your MySQL terminal or a database management tool like phpMyAdmin or MySQL Workbench:

   -- Create database user (optional but recommended)
   CREATE USER 'email_app_user'@'localhost' IDENTIFIED BY 'strong_password_here';
   GRANT ALL PRIVILEGES ON your_email_app_db.* TO 'email_app_user'@'localhost';
   FLUSH PRIVILEGES;

5. Import the .sql File: Run the following command in your MySQL terminal or a database management tool like phpMyAdmin or MySQL Workbench using the .SQL file that you found in the installation files. Replace path/to/your/database.sql with the actual location of the .sql file. You will be prompted to enter the password for email_app_user.

   mysql -u email_app_user -p your_email_app_db < path/to/your/database.sql;

APP_NAME="Your Email Marketing App"
APP_ENV=production
APP_KEY=
APP_DEBUG=false
APP_URL=https://yourdomain.com

# Database Configuration
DB_CONNECTION=mysql
DB_HOST=127.0.0.1
DB_PORT=3306
DB_DATABASE=your_email_app_db
DB_USERNAME=email_app_user
DB_PASSWORD=your_database_password

# Mail Configuration
MAIL_MAILER=smtp
MAIL_HOST=your-smtp-server.com
MAIL_PORT=587
MAIL_USERNAME=your-email@yourdomain.com
MAIL_PASSWORD=your-email-password
MAIL_ENCRYPTION=tls
MAIL_FROM_ADDRESS=noreply@yourdomain.com
MAIL_FROM_NAME="${APP_NAME}"

# Queue Configuration (Important for bulk emails)
QUEUE_CONNECTION=database

# Session and Cache
SESSION_DRIVER=database
CACHE_DRIVER=file

# AWS SES (Optional - for better deliverability)
AWS_ACCESS_KEY_ID=
AWS_SECRET_ACCESS_KEY=
AWS_DEFAULT_REGION=us-east-1
SES_KEY="${AWS_ACCESS_KEY_ID}"
SES_SECRET="${AWS_SECRET_ACCESS_KEY}"
SES_REGION="${AWS_DEFAULT_REGION}"

RECAPTCHA_SITE_KEY=your_site_key
RECAPTCHA_SECRET_KEY=your_site_secret
RECAPTCHA_SITE_KEY_V3=your_site_key_v3
RECAPTCHA_SECRET_KEY_V3=your_site_secret_v3

This step is optional because the zip file contains all the PHP dependencies and JavaScript assets.

# Install PHP dependencies
composer install --optimize-autoloader --no-dev

# Install Node.js dependencies and build assets
npm install
npm run production

# Generate application key
php artisan key:generate

# Create storage symlink
php artisan storage:link

# Set correct permissions for Laravel
sudo chown -R www-data:www-data /path/to/your/app
sudo chmod -R 755 /path/to/your/app
sudo chmod -R 775 /path/to/your/app/storage
sudo chmod -R 775 /path/to/your/app/bootstrap/cache

    RewriteEngine On
    RewriteRule ^(.*)$ public/$1 [L]

server {
    listen 80;
    server_name yourdomain.com;
    root /path/to/your/app/public;
    
    add_header X-Frame-Options "SAMEORIGIN";
    add_header X-Content-Type-Options "nosniff";
    
    index index.php;
    
    charset utf-8;
    
    location / {
        try_files $uri $uri/ /index.php?$query_string;
    }
    
    location = /favicon.ico { access_log off; log_not_found off; }
    location = /robots.txt  { access_log off; log_not_found off; }
    
    error_page 404 /index.php;
    
    location ~ \.php$ {
        fastcgi_pass unix:/var/run/php/php8.1-fpm.sock;
        fastcgi_param SCRIPT_FILENAME $realpath_root$fastcgi_script_name;
        include fastcgi_params;
    }
    
    location ~ /\.(?!well-known).* {
        deny all;
    }
}