mirror of
https://github.com/myronblair/tomsjavajive-app
synced 2026-06-30 17:50:56 -05:00
37 lines
1.2 KiB
PHP
37 lines
1.2 KiB
PHP
<?php
|
|
// Test file to check PHP and database connection
|
|
error_reporting(E_ALL);
|
|
ini_set('display_errors', 1);
|
|
|
|
echo "<h1>PHP Test Page</h1>";
|
|
echo "<p>PHP Version: " . phpversion() . "</p>";
|
|
|
|
// Test database connection
|
|
try {
|
|
require_once __DIR__ . '/config/database.php';
|
|
|
|
$dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=" . DB_CHARSET;
|
|
$pdo = new PDO($dsn, DB_USER, DB_PASS, DB_OPTIONS);
|
|
|
|
echo "<p style='color:green;'>✅ Database connection successful!</p>";
|
|
|
|
// Check if tables exist
|
|
$tables = $pdo->query("SHOW TABLES")->fetchAll(PDO::FETCH_COLUMN);
|
|
echo "<p>Tables found: " . count($tables) . "</p>";
|
|
|
|
if (empty($tables)) {
|
|
echo "<p style='color:orange;'>⚠️ No tables found. Please import schema.sql via phpMyAdmin.</p>";
|
|
echo "<p>Schema file location: <code>/public_html/install/schema.sql</code></p>";
|
|
} else {
|
|
echo "<ul>";
|
|
foreach ($tables as $table) {
|
|
echo "<li>$table</li>";
|
|
}
|
|
echo "</ul>";
|
|
}
|
|
|
|
} catch (PDOException $e) {
|
|
echo "<p style='color:red;'>❌ Database error: " . htmlspecialchars($e->getMessage()) . "</p>";
|
|
}
|
|
?>
|