How to display the number of found materials?

Question

PHP

How to display the number of found materials on the site? I use num_rows but it only displays how many on one page and not the number of all found materials. what do you advise?

Answer 1

<?php 
$Query = mysqli_query($CONNECT, "SELECT `id`, `title`, `himg`, `readed` FROM `news` WHERE `content` LIKE '%{$keywords}%' OR `title` LIKE '%{$keywords}%');
?> 
найдено <?php echo $Query->num_rows; ?>

That is, you need another request and just remove LIMIT and OFFSET from it

Answer 2

$r = mysql_query( "SELECT count(*) FROM ...." );
$count = mysql_result( $r, 0, 0 );

Answer 3

You can use the SQL_CALC_FOUND_ROWS option to SELECT
Find Materials
SELECT SQL_CALC_FOUND_ROWS * FROM tbl_name WHERE id > 100 LIMIT 10;
Number of records
SELECT FOUND_ROWS();