如何获得与mysqli的总行数(how to get the total row count wit

我试图了解mysqli扩展，并做了谷歌，但有不同的php.net这是有帮助这个极少数的信息。

现在这一切后我试图达到什么样的，我可以与MySQL扩展，如下所示：

// MYSQL STYLE OF fetching array, query limit and perform total row count all at once

$sql = "SELECT SQL_CALC_FOUND_ROWS *, post.id as pid, bla bla FROM account ORDER BY pid ASC". $eb["array"]['querylimit'];

$result = mysql_query($sql, $eb["con"]);
$TotalRcount = mysql_fetch_row(mysql_query("SELECT FOUND_ROWS()"));

// Performing record count [current]
// $RecordCount = mysql_num_rows($result);

while($row = mysql_fetch_array($result)){
    // read columns
}

与mysqli的我怎样才能做到这一点？我相信我错过了很多东西。请帮我用例子就如何实现我的目标。

Answer 1:

使用的mysqli你做下面的方式（假设mysqli的对象已经创建-你也可以用程序方法，只是略有不同）：

$sql = "SELECT SQL_CALC_FOUND_ROWS *, post.id as pid, bla bla 
        FROM account ORDER BY pid ASC". $eb["array"]['querylimit'];
$result = $mysqli->query($sql);
$TotalRcount = $result->num_rows;
while($row=$result->fetch_assoc()){
    $col1 = $row['col1'];  // col1 is a placeholder for whatever column you are reading
    //read columns
}

Answer 2:

你可以试试这个：

//Establish connection using mysqli api
$conn = mysqli_connect('hostname', 'username', 'password', 'database_name');

$sql = "SELECT SQL_CALC_FOUND_ROWS *, post.id as pid, bla bla FROM account ORDER BY pid ASC". $eb["array"]['querylimit'];

$sql2 = "SELECT FOUND_ROWS()";

$result1 = $conn->query($sql);
$result2 = $conn->query($sql2);
$TotalRcount = $result2->fetch_row();

// Performing record count [current]
// $RecordCount = $result->num_rows();

while($row = $result->fetch_array(MYSQLI_BOTH)){
    // read columns
}

在while循环中我已经使用MYSQLI_BOTH不变，但你可能会改变它MYSQLI_NUM或任何你需要MYSQLI_ASSOC。