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

6 votes188 views3 answers
Mkdir recursive php
PHP
0 vote141 views1 answer
PHP Fatal error: Uncaught Error: Class 'IntlDateFormatter' not found in /var/www/html/magento/vendor/magento/framework/ObjectManager/Factory/AbstractFactory.php:121
PHP
1 vote227 views3 answers
Delete a migration laravel
PHP Laravel
0 vote190 views1 answer
How to validate email or phone number single parameter request in laravel
PHP
29 votes183 views6 answers
Laravel model with migration
PHP
12 votes227 views1 answer
Laravel model without timestamps
PHP Laravel
1 vote192 views2 answers
Install laravel in ubuntu 20.04
PHP
0 vote157 views1 answer
List all subcategories from category
PHP
8 votes221 views4 answers
Codeigniter redirect
PHP
0 vote182 views1 answer
Laravel get data from model to controller
PHP