Fastest way to count mysql rows using mysqli (or another method)

[jamesjmann]

Is there a way to get the count of rows like this?

$count = somefunctionthatreturnscount(mysqli_query($mysqli, "SELECT COUNT(*) FROM table"));

Instead of...

$count = mysqli_num_rows(mysqli_query($mysqli, "SELECT id FROM table"));

//or even...

$count = mysqli_fetch_array(mysqli_query($mysqli, "SELECT COUNT(*) as count FROM table"));

Ultimately, I want the method that will get the count the quickest and if can be done similarly to the first code and still have good performance.

 

Thanks in advance!

 

Update: Reported post as duplicate. Need moderate to delete duplicates as that option is not appearing for me.

Edited April 16, 2015 by jamesjmann

[Barand]

I use

$res = $mysqli->query("SELECT COUNT(*) FROM table");
list($count) = $res->fetch_row();

[jamesjmann]

 

I use

$res = $mysqli->query("SELECT COUNT(*) FROM table");
list($count) = $res->fetch_row();

 

This works, thank you!