Answers for "php number rows"

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); 
}

mysql get number of rows php

$count_query = "select count(*) from users";