Num_rows in php

Mysql num rows

//number of rows retrieved from a query
<?php

$link = mysql_connect("localhost", "mysql_user", "mysql_password");
mysql_select_db("database", $link);

$result = mysql_query("SELECT * FROM table1", $link);
$num_rows = mysql_num_rows($result);

echo "$num_rows Rows\n";

?>

Source: php.net

Num_rows in php

// Fetch Query
$query = "SELECT user_name from registered_users where user_name like '%ank%'"; 

// Execute the query and store the result set 
$result = mysqli_query($con, $query); 

if ($result) { 
  // it return number of rows in the table. 
  $row = mysqli_num_rows($result); 
}

Php mysqli number row

mysqli_num_rows($result);

Similar codes

7 votes315 views2 answers
How to check the day of any date in php
PHP
1 vote340 views1 answer
Edit data using model in laravel 8
PHP Laravel
1 vote271 views1 answer
How to install php curl (linux) apache2
PHP
1 vote311 views1 answer
How to insert multiple data at a time with create method in laravel
PHP
0 vote290 views1 answer
Laravel - Comparison betweeon two column values - whereColumn
PHP Laravel
0 vote289 views1 answer
Add Payment Type to WooCommerce Admin Email
PHP
0 vote263 views2 answers
How to lookup value inside object php
PHP
3 votes283 views1 answer
Events.js:174 error discord.js
PHP
0 vote306 views1 answer
Laravel curl request
PHP Laravel
0 vote273 views2 answers
Yii2 activerecord bulk insert
PHP