Tech Pagination issue (Displaying RLIKE Results) - GoFuckYourself.com

Publisher Bucks · 08-08-2022, 03:46 PM

Could someone possibly point me in the right direction as to why this query isnt showing the results that I want when adding a category but, it allows me to pull the full contents of the database and display them when no WHERE or RLIKE is present?

Quote:

<?php
include('db.php');

if (isset($_GET['page_no']) && $_GET['page_no']!="") {
$page_no = $_GET['page_no'];
} else {
$page_no = 1;
}

$total_records_per_page = 10;
$offset = ($page_no-1) * $total_records_per_page;
$previous_page = $page_no - 1;
$next_page = $page_no + 1;
$adjacents = "2";

$result_count = mysqli_query($con,"SELECT COUNT(*) As total_records FROM `Directory`");
$total_records = mysqli_fetch_array($result_count);
$total_records = $total_records['total_records'];
$total_no_of_pages = ceil($total_records / $total_records_per_page);
$second_last = $total_no_of_pages - 1; // total page minus 1

$result = mysqli_query($con,"SELECT * FROM Directory LIMIT $offset, $total_records_per_page");
while($row = mysqli_fetch_array($result)){

echo "<a href=". $link .">". $row['Name'] ."</a>";
echo "". $row['Description'] ."</a>";
echo " ";

}
mysqli_close($con);
?>

I've tried adding the following to the query itself with no luck:

Quote:

$result = mysqli_query($con,"SELECT * FROM Directory WHERE Category RLIKE catfood LIMIT $offset, $total_records_per_page");

The amount of pages in the pagination changes, it just wont show the data when I add the WHERE Catergory RLIKE catfood part :/

What am I missing please?

Miguel T · 08-08-2022, 03:58 PM

RLIKE is for REGEX matches.
You should update the query:

$result = mysqli_query($con,"SELECT * FROM Directory WHERE Category LIKE '%catfood%' LIMIT $offset, $total_records_per_page");

Publisher Bucks · 08-08-2022, 05:02 PM

Quote:

Originally Posted by Miguel T

RLIKE is for REGEX matches.
You should update the query:

$result = mysqli_query($con,"SELECT * FROM Directory WHERE Category LIKE '%catfood%' LIMIT $offset, $total_records_per_page");

*brainfart moment* Thank you

08-08-2022, 03:58 PM	#2
Miguel T ♦ Web Developer ♦ Industry Role: Join Date: May 2005 Location: Full-Stack Developer Posts: 12,468	RLIKE is for REGEX matches. You should update the query: $result = mysqli_query($con,"SELECT * FROM Directory WHERE Category LIKE '%catfood%' LIMIT $offset, $total_records_per_page"); __________________ Full Stack Webdeveloper: HTML5/CSS3, jQuery, AJAX, ElevatedX, NATS, MechBunny, Wordpress