@tropicalDev

n your code, the issue likely stems from the way the DSN (Data Source Name) string is constructed. When connecting to a MySQL database using PDO, the DSN should not include user and password directly in the DSN string. Instead, they should be provided as separate parameters in the PDO constructor.

Here’s how to adjust your Database class to resolve this:

class Database { public $connection;

public function __construct()
{
    $dsn = "mysql:host=localhost;port=3306;dbname=myapp;charset=utf8mb4";
    $username = 'root';       // Username here
    $password = 'tropicalDev'; // Password here

    try {
        $this->connection = new PDO($dsn, $username, $password);
        // Set PDO error mode to exception for better error handling
        $this->connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    } catch (PDOException $e) {
        echo "Connection failed: " . $e->getMessage();
    }
}

public function query($query)
{
    $statement = $this->connection->prepare($query);
    $statement->execute();

    return $statement->fetchAll(PDO::FETCH_ASSOC);
}

}

$db = new Database(); $posts = $db->query("SELECT * FROM posts"); var_dump($posts);

Separating Username and Password: In the PDO constructor, use separate $username and $password arguments.

Error Handling: Setting PDO::ATTR_ERRMODE to PDO::ERRMODE_EXCEPTION can help catch and display specific connection errors, making it easier to diagnose issues.

Extract a PHP Database Class