How to get the number of rows in a resultset using medoo

Question

I would like to know how to get the number of rows in a resultset for this statement:

$data=$db->query("SELECT name FROM users")->fetchAll();

I need something similar to mysqli_num_rows but using medoo.

thanks for your help!

If `count` is not an option, because of the specific query you are running, you would need to provide us with that specific query instead - otherwise, the answers below will be flooded with answers that aren't applicable. — gravity, Jul 20 '16 at 13:35

score 1 · Accepted Answer · answered Jul 20 '16 at 12:42

1

Since the query() method returns an array, just use php's count() function to determine the number of records returned (do not set the recursive mode).

answered Jul 20 '16 at 12:42

Shadow

33,525
10
51
64

score 0 · Answer 2 · answered Jul 20 '16 at 11:52

0

In the documentation there is a count method:

$count = $database->count("users");

answered Jul 20 '16 at 11:52

ka_lin

9,329
6
35
56

Could you put the mentioned complex query (change table names if you want) to get an idea... – ka_lin Jul 20 '16 at 12:04

score 0 · Answer 3 · answered Jul 20 '16 at 11:56

0

Try This: Counts the number of rows:

$count = $database->count($table, $where);

answered Jul 20 '16 at 11:56

Harshad Hirapara

462
3
12

How to get the number of rows in a resultset using medoo

3 Answers3