#!/bin/bash
# MySQL PDO Driver Installation Script for Production

echo "=== Installing MySQL PDO Driver ==="

# Detect PHP version
PHP_VERSION=$(php -r "echo PHP_MAJOR_VERSION . '.' . PHP_MINOR_VERSION;")
echo "Detected PHP version: $PHP_VERSION"

# Install MySQL PDO driver
echo "Installing php$PHP_VERSION-mysql..."
sudo apt-get update
sudo apt-get install -y php$PHP_VERSION-mysql

# Restart Apache
echo "Restarting Apache..."
sudo systemctl restart apache2

# Test installation
echo "Testing installation..."
php /var/www/factur-x/production_db_test.php

echo "=== Installation Complete ==="