test-php.php

<?php
/**
 * Simple PHP test file
 */

echo "<h1>PHP Test Page</h1>";
echo "<p>PHP Version: " . phpversion() . "</p>";
echo "<p>Current Time: " . date('Y-m-d H:i:s') . "</p>";

// Test SQLite
if (extension_loaded('pdo_sqlite')) {
    echo "<p style='color: green;'>✓ SQLite PDO extension is available</p>";
    
    try {
        $db_file = '/var/www/html/wp-content/database/wordpress.db';
        $pdo = new PDO('sqlite:' . $db_file);
        echo "<p style='color: green;'>✓ SQLite connection successful</p>";
        
        // Test a simple query
        $result = $pdo->query("SELECT name FROM sqlite_master WHERE type='table'");
        $tables = $result->fetchAll(PDO::FETCH_COLUMN);
        
        if (count($tables) > 0) {
            echo "<p>Database tables found: " . implode(', ', $tables) . "</p>";
        } else {
            echo "<p>No tables found in database (this is normal for a fresh install)</p>";
        }
        
    } catch (Exception $e) {
        echo "<p style='color: red;'>✗ SQLite connection failed: " . $e->getMessage() . "</p>";
    }
} else {
    echo "<p style='color: red;'>✗ SQLite PDO extension is NOT available</p>";
}

// Test file permissions
echo "<h2>File Permissions</h2>";
$files = [
    '/var/www/html/wp-config.php',
    '/var/www/html/wp-content/db.php',
    '/var/www/html/wp-content/database'
];

foreach ($files as $file) {
    if (file_exists($file)) {
        $perms = substr(sprintf('%o', fileperms($file)), -4);
        echo "<p>$file: $perms</p>";
    } else {
        echo "<p style='color: red;'>$file: NOT FOUND</p>";
    }
}

echo "<hr>";
echo "<p><a href='/'>Try WordPress</a> | <a href='/debug.php'>Debug Info</a></p>";
?>