<?PHP
$MysqLi = new MysqLi("hostname", "dbusername", "dbpassword", "dbname");
/* check connection */
if (MysqLi_connect_errno()) {
printf("Connect Failed: %s\n", MysqLi_connect_error());
exit();
}
if ($result = $MysqLi->query("SELECT count(*) cc FROM tablename")) {
/* fetch the first row as result */
$row = $result->fetch_assoc();
printf("Result set has %d rows.\n", $row['cc']);
/* close result set */
$result->close();
}
/* close connection */
$MysqLi->close();
?>
实际上,这是一个常见问题,您可以在任何地方找到答案。
就像http://php.net/manual/en/mysqli-result.num- rows.PHP
您可以将这个问题分为两个