php如何测试mysql

<?php
try {
    // 创建PDO实例
    $pdo = new PDO('mysql:host=localhost;dbname=testdb', 'username', 'password');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    // 测试连接
    $stmt = $pdo->query('SELECT 1');
    if ($stmt->fetchColumn() == 1) {
        echo "数据库连接成功";
    } else {
        echo "数据库连接失败";
    }
} catch (PDOException $e) {
    echo "数据库连接失败: " . $e->getMessage();
}
?>

<?php
use PHPUnit\Framework\TestCase;

class DatabaseTest extends TestCase
{
    protected function setUp(): void
    {
        $this->pdo = new PDO('mysql:host=localhost;dbname=testdb', 'username', 'password');
        $this->pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    }

    public function testConnection()
    {
        $stmt = $this->pdo->query('SELECT 1');
        $this->assertEquals(1, $stmt->fetchColumn());
    }

    public function testQuery()
    {
        $stmt = $this->pdo->query('SELECT * FROM users WHERE id = 1');
        $this->assertNotEmpty($stmt->fetch());
    }
}

phpunit DatabaseTest.php