如何在php中正确获取count(*)

try {
    $pdo = new PDO('mysql:host=your_host;dbname=your_db', 'username', 'password');
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);

    $stmt = $pdo->query('SELECT COUNT(*) FROM your_table');
    $count = $stmt->fetchColumn();

    echo 'Total records: ' . $count;
} catch (PDOException $e) {
    echo 'Error: ' . $e->getMessage();
}

$mysqli = new mysqli('your_host', 'username', 'password', 'your_db');

if ($mysqli->connect_errno) {
    echo 'Failed to connect to MySQL: ' . $mysqli->connect_error;
    exit();
}

$result = $mysqli->query('SELECT COUNT(*) FROM your_table');
$row = $result->fetch_row();
$count = $row[0];

echo 'Total records: ' . $count;

$mysqli->close();