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

Подписаться 21 тыс.

Просмотров 27 тыс.

50% 1

Hello Friends! In this video I'm showing you how to create Advanced Pagination, Live Searching and Sorting of Records Using Bootstrap 4, PHP, MySQLi and a very powerful open source library that is jQuery DataTable.
In this video, I'm showing first how to fetch all the records using PHP and MySQLi in a table format, then after that I'm showing you how to implement jQuery DataTable to make pagination, searching and sorting of records!
#jQuery_Datatable
#advanced_pagination
If you like my works and my video tutorials then you can donate me some amount. You can donate through these links :
Paypal : www.paypal.me/...
Instamojo (Credit/Debit Card & UPI) : www.instamojo....
Thanks for watching this video. If you like this video then hit like button, share this video, And Subscribe my Channel. Also like my Facebook page for latest updates.
♥ Facebook Page - / dcodemania
♥ Myself On FB - / sahil4rock
♥ Instagram - / sahil4rock
♥ Twitter - / dcodemania

Опубликовано:

16 окт 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 64

@douaacharfi6312 2 года назад

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

@Itsmohitrawat 4 года назад

veryyy Nice and easy to learn keep it up

@henlij 3 года назад

Thanks!

@hidayahburhannudin4059 9 месяцев назад

thank you, really help me a lot

@markusaurelius1190 3 года назад

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!!!

@newsmix8659 4 года назад

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

@jorgeallenadajar9259 2 года назад

so useful my friend!! God bless you always

@creatorspool206 4 года назад

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

@myritebook2514 4 года назад

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

@NileshPanchal-nx4pw 3 года назад

Very useful Video..

@swapnilkadam6616 2 года назад

Very nice. Thank you so much.

@hut_fire1490 5 лет назад

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

@DCodeMania 5 лет назад

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

@JyotiEntertainmentProduction 2 года назад

Thank you!

@ShohanHawladar 4 года назад

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?

@muhdsyakir8625 3 года назад

Great tutorial, thank you 😊

@sandeepjangra7604 5 месяцев назад

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?

@--INDIAN--TRADER 4 года назад

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 3 года назад

this is my problem right now.

@kisho2679 9 месяцев назад

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

@joshuavalencia4955 4 года назад

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

@kaustubhpathak6880 4 года назад

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

@bhartikumawat4800 3 года назад

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

@DCodeMania 3 года назад

Yes ofcourse it will work

@aboutiti2838 4 года назад

Thanks 🙏🏼

@chukwumandubuisi856 5 лет назад

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 5 лет назад

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

@chukwumandubuisi856 5 лет назад

@@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.

@Liljaxx 4 года назад

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

@justcreativejalore9877 4 года назад

Sublime text have feature with tab key

@youdocssstyle5114 4 года назад

thx man, you are really save me

@--INDIAN--TRADER 4 года назад

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

@freeplay4690 5 лет назад

thanks bro.. it is usefull for me

@DCodeMania 5 лет назад

Subscribe this channel also!!!

@dhivakarsaravanan1342 4 года назад

not working serach and sort

@luckyandroid3568 2 года назад

is can using into php which version it?

@iamsourin 5 лет назад

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 5 лет назад

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.

@photoinshot1355 4 года назад

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 5 лет назад

Great

@user-cq1ji8my8o 4 года назад

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

@ancoorbanerjee 4 года назад

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

@meyladalazawi6354 5 лет назад

Very good

@DCodeMania 5 лет назад

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

@meyladalazawi6354 5 лет назад

@@DCodeMania oky

@nirajdeshmukh7514 4 года назад

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 4 года назад

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

@nirajdeshmukh7514 4 года назад

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

@nirajdeshmukh7514 4 года назад

@@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 4 года назад

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

@erwincaloing3929 5 лет назад

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

@dstar2211 5 лет назад

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

@iamsourin 5 лет назад

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

@DCodeMania 5 лет назад

Okay I'll also upload this tutorial.

@janramilintong1187 2 года назад

mine is not working

@charlesderek7107 4 года назад

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

@karlrussellmenil9460 3 года назад

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

@MuhammadAdnan-gx6rd 5 лет назад

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

@DCodeMania 5 лет назад

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

@MuhammadAdnan-gx6rd 5 лет назад

okay okay. ....