mysqli 取记录数

$mysqli = new mysqli("localhost", "user", "password", "database");

if ($mysqli->connect_error) {
    die("连接失败: " . $mysqli->connect_error);
}

$sql = "SELECT * FROM table_name";
$result = $mysqli->query($sql);

if ($result) {
    $row_count = $result->num_rows;
    echo "记录数: " . $row_count;
} else {
    echo "查询失败: " . $mysqli->error;
}

$mysqli->close();

$mysqli = new mysqli("localhost", "user", "password", "database");

if ($mysqli->connect_error) {
    die("连接失败: " . $mysqli->connect_error);
}

$sql = "SELECT COUNT(*) AS total FROM table_name";
$result = $mysqli->query($sql);

if ($result && $result->num_rows > 0) {
    $row = $result->fetch_assoc();
    $row_count = $row['total'];
    echo "记录数: " . $row_count;
} else {
    echo "查询失败: " . $mysqli->error;
}

$mysqli->close();