Comments on: Ajax Pagination with Search and Filter in PHP

By: Dawid

Dawid — Fri, 20 Oct 2023 23:10:25 +0000

How can I add to this code export to pdf buttons?

This function doesn’t work with this 🙁
$(document).ready(function() {
$(‘#example’).DataTable( {
dom: ‘Bfrtip’,
buttons: [
‘copy’, ‘csv’, ‘excel’, ‘pdf’, ‘print’
]
} );
} );

Can You help with this maybe?
Thank You a lot!

By: willcgg@mail.com

willcgg@mail.com — Fri, 10 Jun 2022 19:54:29 +0000

thanks mens you are godt

By: Senthil Kumar P

Senthil Kumar P — Sun, 17 Apr 2022 19:41:58 +0000

Hello Sir,

If I use the code same as yours, it is working great.

I just changed the query code as per my requirement

In Index.php
//Count of all records
$query=mysqli_query($conn,”SELECT COUNT(*) as rowNum FROM calibrationdata WHERE Branch = ‘$userbranch'”);

// Fetch records based on the offset and limit
$query=mysqli_query($conn,”SELECT * FROM calibrationdata WHERE Branch = ‘$userbranch’ ORDER BY id ASC LIMIT

I just add the $userbranch. If I add in index.php it is displaying table rows.

In getData.php

//Count of all records
$query=mysqli_query($conn,”SELECT COUNT(*) as rowNum FROM calibrationdata WHERE Branch = ‘$userbranch’ .$whereSQL”);

// Fetch records based on the offset and limit
$query=mysqli_query($conn,”SELECT * FROM calibrationdata WHERE Branch = ‘$userbranch’ $whereSQL ORDER BY id ASC LIMIT $offset,$limit”);

If I modify the code in getData.php, while searching or filtering the table I am getting the following error

Fatal error: Uncaught Error: Call to a member function fetch_assoc() on boolean in /storage/ssd1/112/16994112/public_html/chart_data.php:41 Stack trace: #0 {main} thrown in /storage/ssd1/112/16994112/public_html/chart_data.php on line 41

Can you please help me to solve this issue

By: brate

brate — Sat, 06 Nov 2021 07:34:58 +0000

Hello Sir,

Can you share me CSS and javascript file for this pagination project.
Thanking you,

with regards,
Brate

By: Remie

Remie — Sun, 16 Feb 2020 15:45:58 +0000

Great article! Love it.

Is there a back button available when using the pagination. Clicking on a link on page 2 for example and than going back brings up page1.

Thanks.

By: Rohit Kumar

Rohit Kumar — Mon, 14 Oct 2019 07:10:54 +0000

Really a great article. i need help, how to add serial number on starting title.

By: gabriel

gabriel — Thu, 08 Mar 2018 21:46:34 +0000

Please is there a way one can display results only when one searches instead of displaying everything?

By: Mark

Mark — Tue, 24 Oct 2017 19:34:53 +0000

Thank you for the rapid response. I read through the https://www.codexworld.com/php-pagination-class-with-mysql/ tutorial and still cannot find the solution. Javascript is not my forte. I will continue to work on it.

By: CodexWorld

CodexWorld — Tue, 24 Oct 2017 18:53:07 +0000

In reply to Mark. Use PHP pagination to fulfill your requirements. See this tutorial to implement Pagination in PHP with MySQL - https://www.codexworld.com/php-pagination-class-with-mysql/

By: Mark

Mark — Tue, 24 Oct 2017 18:23:15 +0000

Apologies . . . I should have posted it here as this was the set of scripts that I was working with:

Right now, I have the $row[‘title’] values showing up as paginated hyperlinked items in the browser. Very nice. They hyperlink only to a javascript void command as is determined in the scripts. I’d like to change it so that the hyperlink allows the visitor to view the record based on the record ID value ($row[‘id’].

I managed to change the value in the index.php script to make it work, but can’t seem to get it working in the Pagination.php script.

Thoughts?