PHPize - format run and share PHP code with SQL queries online

mysqli_num_rows

mysqli_num_rows — Gets the number of rows in a result.

Description

mysqli_num_rows(
    mysqli_result $result
): int|string

Returns the number of rows in the result set. The behaviour of mysqli_num_rows() depends on whether buffered or unbuffered result sets are being used. For unbuffered result sets, mysqli_num_rows() will not return the correct number of rows until all the rows in the result have been retrieved.

Parameters

A mysqli_result object returned by mysqli_query(), mysqli_store_result(), mysqli_use_result() or mysqli_stmt_get_result().

result

A mysqli_result object returned by mysqli_query(), mysqli_store_result(), mysqli_use_result() or mysqli_stmt_get_result().

Return Values

Returns number of rows in the result set.

More information about mysqli_num_rows on official PHP documentation site

mysqli_num_rows - Popular snippets

PHP 7.4 / mysqli_query mysqli_num_rows ceil print_r mysqli_query mysqli_num_rows ceil print_r last run: 2025-01-31 18:00:39
185
PHP 8.0 / mysqli_query mysqli_num_rows ceil print_r mysqli_query mysqli_num_rows ceil print_r last run: 2025-01-31 18:00:40
184
/ mysqli_query mysqli_num_rows ceil print_r last run: 2025-01-31 15:45:23
182
PHP 8.1 / mysqli_query mysqli_num_rows ceil print_r mysqli_query mysqli_num_rows ceil print_r last run: 2025-01-31 18:00:41
181
PHP 8.1 / printf mysqli_num_rows mysqli_fetch_array last run: 2023-05-17 07:38:58
23
PHP 8.1 / printf mysqli_num_rows mysqli_fetch_array last run: 2023-05-17 07:39:52
11
PHP 8.0 / MySQL 8.0 mysqli_query mysqli_num_rows mysqli_fetch_assoc last run: 2022-02-16 13:43:51
10

mysqli_num_rows - New snippets

PHP 8.4 / MySQL 8.0 mysqli_query mysqli_num_rows mysqli_fetch_assoc added at: 2025-04-04 05:09:24
1
PHP 8.3 / MySQL 8.0 mysqli_query mysqli_num_rows mysqli_fetch_array added at: 2025-02-18 18:43:23
3
PHP 8.3 / MySQL 8.0 mysqli_query mysqli_num_rows mysqli_fetch_array added at: 2025-02-18 18:43:18
1
PHP 8.3 / MySQL 8.0 mysqli_query mysqli_num_rows mysqli_fetch_array added at: 2025-02-18 18:42:57
1
PHP 8.4 / MySQL 8.0 mysqli_query mysqli_num_rows var_dump added at: 2025-02-17 04:22:03
1
PHP 8.3 / MySQL 8.0 mysqli_query mysqli_num_rows ceil print_r added at: 2025-01-31 18:25:19
5
PHP 8.2 / MySQL 8.0 mysqli_query mysqli_num_rows ceil print_r added at: 2025-01-31 18:25:17
5
PHP 8.4 / MySQL 8.0 mysqli_query mysqli_num_rows ceil print_r mysqli_query mysqli_num_rows ceil print_r added at: 2025-01-31 18:22:09
7
PHP 8.1 / MySQL 8.0 mysqli_query mysqli_num_rows ceil print_r added at: 2025-01-31 18:03:11
8

PHPize.online - Popular functions

print_r

15k

var_dump

12k

printf

json_decode

file_get_contents

count

json_encode

phpversion

date

var_export

explode

preg_match

implode

strlen

preg_replace

simplexml_load_string

strtotime

substr

array_map

preg_match_all

array_merge

mysqli_query

is_array

str_replace

array_push

trim

array_filter

907

mysqli_prepare

880

round

799

str_repeat

789

array_keys

782

array_count_values

769

array_reduce

753

mysqli_fetch_assoc

678

sprintf

658

mysqli_fetch_array

626

in_array

619

array_fill

619

unserialize

582

array_sum

575

strpos

531

array_values

524

microtime

501

array_search

495

mysqli_num_rows

489

time

476

rand

469

array_column

455

intval

452

mb_substr

396

max

393

usort

383

array_slice

381

end

377

str_split

376

preg_split

369

range

362

array_unique

355

number_format

349

strtolower

331

min

316

base64_decode

309

sort

308

ceil

305

gettype

290

floor

286

mysqli_real_escape_string

282

strtoupper

275

join

266

curl_init

262

chr

259

curl_close

257

is_numeric

254

preg_replace_callback

242

mb_strlen

242

array_pop

236

mktime

229

array_reverse

225

session_start

221

curl_setopt

220

array_diff

213

mt_rand

206

header

205

substr_replace

205

htmlspecialchars

204

md5

201

reset

198

array_walk

193

parse_url

191

array_key_exists

189

key

187

str_pad

185

curl_exec

184

array_shift

183

arsort

183

filter_var

178

ord

178

error_reporting

177

define

173

Like the site? Share it!

Have a questions? Ask in our telegram chat!

PHP versions: PHP 7.4, PHP 8.0, PHP 8.1, PHP 8.2, PHP 8.3, PHP 8.4
RDBMS versions: MariaDB 11.4, MariaDB 11.5, MariaDB 10, MariaDB 10 Sakila (ReadOnly), MySQL 8.0, MySQL 8.0 Sakila (ReadOnly), MySQL 9.3.0, SQLite 3, SQLite 3 Preloaded, PostgreSQL 10 Bookings (ReadOnly), PostgreSQL 13, PostgreSQL 14, PostgreSQL 15, PostgreSQL 16, PostgreSQL 17, MS SQL Server 2017, MS SQL Server 2019, MS SQL Server 2022, MS SQL Server 2022 AdventureWorks (ReadOnly), Firebird 4.0, Firebird 4.0 (Employee), Oracle Database 19c (HR), Oracle Database 21c, Oracle Database 23c Free, SOQOL

PHPize Online / SQLize Online / SQLtest Online

mysqli_num_rows - Popular snippets

mysqli_num_rows - New snippets

PHPize.online - Popular functions