使用MySQL和PHP检查线程中有多少帖子的最快方法

$dsn = "mysql:host=localhost;dbname=mydatabase";
$username = "myusername";
$password = "mypassword";

try {
    $pdo = new PDO($dsn, $username, $password);
} catch (PDOException $e) {
    echo "Connection failed: " . $e->getMessage();
}

SELECT COUNT(*) FROM posts;

$sql = "SELECT COUNT(*) FROM posts";
$stmt = $pdo->prepare($sql);
$stmt->execute();
$result = $stmt->fetchColumn();

echo "There are $result posts in the thread.";