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

แชร์
ฝัง
  • เผยแพร่เมื่อ 9 พ.ย. 2024

ความคิดเห็น • 64

  • @douaacharfi6312
    @douaacharfi6312 2 ปีที่แล้ว +1

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

  • @myritebook2514
    @myritebook2514 4 ปีที่แล้ว +1

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

  • @jorgeallenadajar9259
    @jorgeallenadajar9259 2 ปีที่แล้ว

    so useful my friend!! God bless you always

  • @--INDIAN--TRADER
    @--INDIAN--TRADER 4 ปีที่แล้ว +1

    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

  • @markusaurelius1190
    @markusaurelius1190 3 ปีที่แล้ว +1

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

  • @creatorspool206
    @creatorspool206 4 ปีที่แล้ว +2

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

  • @Itsmohitrawat
    @Itsmohitrawat 4 ปีที่แล้ว +1

    veryyy Nice and easy to learn keep it up

  • @henlij
    @henlij 3 ปีที่แล้ว +1

    Thanks!

  • @hidayahburhannudin4059
    @hidayahburhannudin4059 10 หลายเดือนก่อน +1

    thank you, really help me a lot

  • @NileshPanchal-nx4pw
    @NileshPanchal-nx4pw 3 ปีที่แล้ว +1

    Very useful Video..

  • @newsmix8659
    @newsmix8659 4 ปีที่แล้ว +1

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

  • @JyotiEntertainmentProduction
    @JyotiEntertainmentProduction 2 ปีที่แล้ว

    Thank you!

  • @swapnilkadam6616
    @swapnilkadam6616 2 ปีที่แล้ว

    Very nice. Thank you so much.

  • @dhivakarsaravanan1342
    @dhivakarsaravanan1342 4 ปีที่แล้ว +4

    not working serach and sort

  • @hut_fire1490
    @hut_fire1490 5 ปีที่แล้ว +1

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

    • @DCodeMania
      @DCodeMania  5 ปีที่แล้ว

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

  • @muhdsyakir8625
    @muhdsyakir8625 3 ปีที่แล้ว +1

    Great tutorial, thank you 😊

  • @sandeepjangra7604
    @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?

  • @kaustubhpathak6880
    @kaustubhpathak6880 4 ปีที่แล้ว

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

  • @ShohanHawladar
    @ShohanHawladar 4 ปีที่แล้ว +1

    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?

  • @bhartikumawat4800
    @bhartikumawat4800 3 ปีที่แล้ว +1

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

    • @DCodeMania
      @DCodeMania  3 ปีที่แล้ว +1

      Yes ofcourse it will work

  • @kisho2679
    @kisho2679 10 หลายเดือนก่อน

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

  • @aboutiti2838
    @aboutiti2838 4 ปีที่แล้ว +1

    Thanks 🙏🏼

  • @MuhammadAdnan-gx6rd
    @MuhammadAdnan-gx6rd 5 ปีที่แล้ว +1

    Great

  • @joshuavalencia4955
    @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?

  • @Liljaxx
    @Liljaxx 4 ปีที่แล้ว +1

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

  • @meyladalazawi6354
    @meyladalazawi6354 5 ปีที่แล้ว +1

    Very good

    • @DCodeMania
      @DCodeMania  5 ปีที่แล้ว +1

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

    • @meyladalazawi6354
      @meyladalazawi6354 5 ปีที่แล้ว +1

      @@DCodeMania oky

  • @freeplay4690
    @freeplay4690 5 ปีที่แล้ว +1

    thanks bro.. it is usefull for me

    • @DCodeMania
      @DCodeMania  5 ปีที่แล้ว

      Subscribe this channel also!!!

  • @youdocssstyle5114
    @youdocssstyle5114 5 ปีที่แล้ว +1

    thx man, you are really save me

  • @luckyandroid3568
    @luckyandroid3568 2 ปีที่แล้ว

    is can using into php which version it?

  • @photoinshot1355
    @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

  • @user-cq1ji8my8o
    @user-cq1ji8my8o 4 ปีที่แล้ว

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

  • @iamsourin
    @iamsourin 5 ปีที่แล้ว +1

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

  • @chukwumandubuisi856
    @chukwumandubuisi856 5 ปีที่แล้ว +2

    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
      @DCodeMania  5 ปีที่แล้ว +1

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

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

  • @--INDIAN--TRADER
    @--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

  • @ancoorbanerjee
    @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

  • @nirajdeshmukh7514
    @nirajdeshmukh7514 4 ปีที่แล้ว +1

    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
      @justcreativejalore9877 4 ปีที่แล้ว

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

    • @nirajdeshmukh7514
      @nirajdeshmukh7514 4 ปีที่แล้ว +1

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

    • @nirajdeshmukh7514
      @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
      @nirajdeshmukh7514 4 ปีที่แล้ว

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

  • @erwincaloing3929
    @erwincaloing3929 5 ปีที่แล้ว

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

  • @dstar2211
    @dstar2211 5 ปีที่แล้ว

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

  • @karlrussellmenil9460
    @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

  • @iamsourin
    @iamsourin 5 ปีที่แล้ว +1

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

    • @DCodeMania
      @DCodeMania  5 ปีที่แล้ว

      Okay I'll also upload this tutorial.

  • @janramilintong1187
    @janramilintong1187 2 ปีที่แล้ว

    mine is not working

  • @charlesderek7107
    @charlesderek7107 4 ปีที่แล้ว

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

  • @MuhammadAdnan-gx6rd
    @MuhammadAdnan-gx6rd 5 ปีที่แล้ว +1

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

    • @DCodeMania
      @DCodeMania  5 ปีที่แล้ว +1

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

    • @MuhammadAdnan-gx6rd
      @MuhammadAdnan-gx6rd 5 ปีที่แล้ว

      okay okay. ....

  • @ShyamKumar-zn8hp
    @ShyamKumar-zn8hp 4 ปีที่แล้ว

    Sir,
    Please Share Code !!

  • @bloodshotgamingff
    @bloodshotgamingff 4 ปีที่แล้ว

    provide source code download link