Advanced Pagination, Live Searching & Sorting of Records Using PHP, MySQLi & jQuery DataTable

[@henlij]

Thanks!

[@douaacharfi6312]

thank you very much 🥰🥰 it's working🤩🤩

[@hidayahburhannudin4059]

thank you, really help me a lot

[@markusaurelius1190]

Hi mate. Awesome video! Really helped me with a solution to my problem. I was trying to get a paginator class to work and was pretty well hitting the wall. Thank you!!!

[@jorgeallenadajar9259]

so useful my friend!! God bless you always

[@creatorspool206]

This video has really helped me a lot. Thank you sir!

[@Itsmohitrawat]

veryyy Nice and easy to learn keep it up

[@myritebook2514]

I have applied this code. it is worked. thanks a lot.

[@swapnilkadam6616]

Very nice. Thank you so much.

[@newsmix8659]

Hi sir! Great work there! Keep up the beautiful work!

[@muhdsyakir8625]

Great tutorial, thank you 😊

[@NileshPanchal-nx4pw]

Very useful Video..

[@sparx_super]

Keep doing this kind of stuffs ! We need it ! Thank you my brother

[@DCodeMania]

Welcome bro!! Please subscribe this channel also!!!

[@aboutiti2838]

Thanks 🙏🏼

[@JyotiEntertainmentProduction]

Thank you!

[@youdocssstyle5114]

thx man, you are really save me

[@freeplay4690]

thanks bro.. it is usefull for me

[@DCodeMania]

Subscribe this channel also!!!

[@kaustubhpathak6880]

thanks dear for this, just a query that how to make individual column search autocomplete in this?

[@dhivakarsaravanan1342]

not working serach and sort

[@kisho2679]

how can CRUD actions be added in a separate column as drop-down selection?

[@Liljaxx]

really awesome - thanks . how do i get this autocomplete when you for examples write div. it competes the tag?

[@justcreativejalore9877]

Sublime text have feature with tab key

[@--INDIAN--TRADER]

total 5 mins of time for 65000 record with fetching only 4 columns its good for less than 2-4 thousand record i think like categories etc but not for thousand of records just for information thumbs up for your efforts keep up the good work

[@jayrheylicong8104]

this is my problem right now.

[@bhartikumawat4800]

Thank you so much. I have one question, will this sorting work for the large database as well?

[@DCodeMania]

Yes ofcourse it will work

[@ShohanHawladar]

Hello, your video is very helpful for me. thanks. But I need another thing, that is default showing entries need to increase. How can I increase default showing entries 10 to 50?

[@meyladalazawi6354]

Very good

[@DCodeMania]

Thanks!!😊😊😊 Subscribe this channel also!!!!

[@meyladalazawi6354]

@@DCodeMania oky

[@chukwumandubuisi856]

Plenty thanks for this great resource on pagination. besides selecting and paginating data from table rows is there a way i can paginate a lengthy string or characters using php. (example: to paginate a story of 5000 words into 1000 characters each). Thanks in anticipation.

[@DCodeMania]

You can create your own custom pagination using PHP & MySQLi...!!

[@chukwumandubuisi856]

@@DCodeMania Thanks so much for your concern and immediate presence to assist and proffer us uncommon solutions. i have faced this challenge for long now before i luckily get across your video and there currently seem to be no sample video illustration of solution to this. Could you be kind to offer us a brief one. i will so dearly appreciate. Thanks a million.

[@photoinshot1355]

Thanks for a great tutorial, how can the bootstrap components be edited such as altering the show entries number? Thanks again for a great tutorial

[@MuhammadAdnan-gx6rd]

Great

[@luckyandroid3568]

is can using into php which version it?

[@joshuavalencia4955]

So this will not work if you don't have internet connection? Since everything is in the online CSS, you can't modified it?

[@sandeepjangra7604]

Hlo it is soo helpful, But if we have to modify the show paging ourselves, how will we do it, like we want to show 50 or 100 products on one page?

[@user-cq1ji8my8o]

How would you change colors with this table, everything is in the online css file and cannot be modified

[@iamsourin]

Sir I want to ask u one question if I use jQuery new formdata method with isset method , you told me that we have to pass one extra thing what is that thing

[@DCodeMania]

No need to send extra data....but it is better to send for checking in PHP part that this part gonna be execute if multiple form you have in your page.

[@ancoorbanerjee]

when nothing changes for me when i applied the same on my table.. just the edit and delete icon color changed. can you help me out here

[@nirajdeshmukh7514]

Hello, Its me Again I tried to follow same step. i am getting well table records show but sorting,searching,pagination can't see.

[@justcreativejalore9877]

Sorry, its may some spelling mistakes. I have also done silly mistakes. Like funtion or function.....😋

[@nirajdeshmukh7514]

@@justcreativejalore9877 oh i see..for me i was put mistake version of cdn link 😐

[@nirajdeshmukh7514]

@@marufislam9959 Please use correctly version of datatables link reference..for example if you tick bootstrap 3.5 then you should correct version as well others.

[@nirajdeshmukh7514]

@@marufislam9959 did you used another link as only bootstrap? if had please remove it and only use one from datatables.

[@--INDIAN--TRADER]

i have 2 table on same page .. i have done all the links but still not working .. how to get 1 specific table .. plese guide

[@dstar2211]

how can do it in div class .... in table its eassy...bt how in div ?????????

[@erwincaloing3929]

Hi, its not working on more than 1000 rows, how can i fix it? Thanks

[@iamsourin]

Sir my next request is bs4 dynamic carousel with captions using PHP, ajax, MySQL if possible in future

[@DCodeMania]

Okay I'll also upload this tutorial.

[@karlrussellmenil9460]

Topic: Full stack javascript - Data Pagination and Filtering Good day, If I may humbly ask a little help, any hints, comments and suggestions are very much welcome, thank you in advance for all your help, please see question below, how do I code this?: /* Create the `showPage` function This function will create and insert/append the elements needed to display a "page" of nine students */ /* Create the `addPagination` function This function will create and insert/append the elements needed for the pagination buttons */ // Call functions

[@janramilintong1187]

mine is not working

[@charlesderek7107]

jquery is like learning how to only walk with crutches.. Vanilla code please.

[@MuhammadAdnan-gx6rd]

Han mene kaha tha pagi ka great Bro. .butttttt it's datatable so without it. ...

[@DCodeMania]

Wait I'll also upload how to make pagination without datatable....!!!!

[@MuhammadAdnan-gx6rd]

okay okay. ....

[@bloodshotgamingff]

provide source code download link

[@ShyamKumar-zn8hp]

Sir, Please Share Code !!