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

3 votes265 views1 answer
Send multiple mail in laravel
PHP Laravel
1 vote209 views2 answers
Laravel eloquent join two models
PHP
1 vote175 views1 answer
TreeBuilder::getRootNode()" before creating the root node is not supported, migrate to the new constructor signature instead.
PHP
35 votes166 views6 answers
Syntax error or access violation: 1071 Specified key was too long; max key length is 1000 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))
PHP
0 vote216 views1 answer
Laravel 8 get app folder
PHP Laravel
2 votes177 views2 answers
Get template name wordpress
PHP
0 vote239 views1 answer
Codeigniter 4 query builder get inserted id
PHP CodeIgniter
107 votes552 views6 answers
Php get current date
PHP
2 votes240 views2 answers
Php get youtube code
PHP
0 vote167 views2 answers
Sort names alphabetically php
PHP