<?php
// test_db_debug.php
error_reporting(E_ALL);
ini_set('display_errors', 1);

echo "<h2>PHP Info za bazu podataka</h2>\n";

// Proveri PDO drajvere
echo "PDO dostupni drajveri: ";
print_r(PDO::getAvailableDrivers());
echo "<br><br>\n";

// Proveri PHP verziju
echo "PHP Version: " . PHP_VERSION . "<br>\n";

// Test konekcije korak po korak
define('DB_HOST', 'localhost');
define('DB_NAME', 'temperature_db');
define('DB_USER', 'temperature_user');
define('DB_PASS', 'secure_password_123');

echo "<h3>Test konekcije:</h3>\n";
echo "DSN: mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . "<br>\n";
echo "User: " . DB_USER . "<br>\n";

try {
    // Korak 1: Pokušaj konekcije
    $pdo = new PDO(
        "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME, 
        DB_USER, 
        DB_PASS,
        [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]
    );
    
    echo "✅ Konekcija uspela!<br>\n";
    
    // Korak 2: Proveri tabele
    $tables = $pdo->query("SHOW TABLES")->fetchAll(PDO::FETCH_COLUMN);
    echo "✅ Tabele u bazi: " . implode(', ', $tables) . "<br>\n";
    
    // Korak 3: Proveri temperature_logs tabelu
    if (in_array('temperature_logs', $tables)) {
        $stmt = $pdo->query("SELECT COUNT(*) as count FROM temperature_logs");
        $result = $stmt->fetch();
        echo "✅ Broj zapisa u temperature_logs: " . $result['count'] . "<br>\n";
    }
    
    // Korak 4: Test INSERT
    $testInsert = $pdo->prepare("
        INSERT INTO temperature_logs 
        (sensor_id, temperature, humidity, pressure, heating_command) 
        VALUES (?, ?, ?, ?, ?)
    ");
    
    $success = $testInsert->execute(['debug-sensor', 23.5, 50.0, 1015.0, 'off']);
    
    if ($success) {
        echo "✅ Test INSERT USPEO! ID: " . $pdo->lastInsertId() . "<br>\n";
    } else {
        echo "❌ Test INSERT FAILED!<br>\n";
        print_r($testInsert->errorInfo());
    }
    
} catch (PDOException $e) {
    echo "❌ Greška: " . $e->getMessage() . "<br>\n";
    
    // Dodatne debug informacije
    echo "Error Code: " . $e->getCode() . "<br>\n";
    
    // Probaj bez baze da vidimo da li se može spojiti na MySQL
    try {
        $pdo2 = new PDO("mysql:host=" . DB_HOST, DB_USER, DB_PASS);
        echo "✅ Konekcija na MySQL server uspela (bez baze)<br>\n";
        
        // Proveri da li baza postoji
        $databases = $pdo2->query("SHOW DATABASES")->fetchAll(PDO::FETCH_COLUMN);
        echo "✅ Dostupne baze: " . implode(', ', $databases) . "<br>\n";
        
        if (in_array('temperature_db', $databases)) {
            echo "✅ Baza temperature_db postoji!<br>\n";
        } else {
            echo "❌ Baza temperature_db NE postoji!<br>\n";
        }
        
    } catch (PDOException $e2) {
        echo "❌ Ne može se spojiti ni na MySQL server: " . $e2->getMessage() . "<br>\n";
    }
}
?>