Checking Settings with the getAttribute() Method

The getAttribute() method allows you to retrieve the values of specific attributes of your PDO connection. You can use it to determine which database driver you are currently using (e.g., mysql), what the server version is, or how the error reporting modes are configured. This is extremely useful when developing libraries that need to run in diverse environments and handle data based on the server's capabilities.

EXAMPLE

<?php
class Database {
    private $server = "localhost";
    private $username = "root";
    private $password = "";
    private $db_name = "pdo_db";
    public $connection;

    public function __construct() {
        try {
            // Added charset=utf8mb4 for character support
            $dsn = "mysql:host=" . $this->server . ";dbname=" . $this->db_name . ";charset=utf8mb4";
            $this->connection = new PDO($dsn, $this->username, $this->password);
            $this->connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        } catch(PDOException $e) {
            die("Connection failed: " . $e->getMessage());
        }
    }

    public function getServerVersion() {
        // Retrieve the attribute for the server version
        return $this->connection->getAttribute(PDO::ATTR_SERVER_VERSION);
    }
}

// PART 3: Usage
$db = new Database();
$version = $db->getServerVersion();

echo "Your server is running version: " . $version;
?>

RESULT

The result will be displayed here...

Practical Application: We most commonly use the getAttribute method to check the server version or connection status to ensure code compatibility. Check the process at home by following these steps:

Start the Apache and MySQL modules in the XAMPP control panel.
The pdo_db database must be created so that you can connect to it successfully.
The method returns the value of the requested attribute, which can be a string, a number, or an array.
Insert the example below into a PHP file and see which MySQL server version your XAMPP is running.