Create Pagination in PHP and MySQL

Поделиться
HTML-код
  • Опубликовано: 24 дек 2024

Комментарии • 249

  • @joelpeterson4263
    @joelpeterson4263 5 лет назад +84

    Amazing tutorial, loudest keyboard in the whole universe

    • @Vikrantvirdi
      @Vikrantvirdi 4 года назад +1

      hahaha

    • @jeremievoyer6093
      @jeremievoyer6093 4 года назад +9

      Call me weird but I love keyboard sounds like that. Very soothing

    • @richardlovas4590
      @richardlovas4590 3 года назад +3

      @@jeremievoyer6093 Same, like asmr keyboard coding xd

  • @mohseneini8487
    @mohseneini8487 2 года назад +1

    u explained flue and plain.great thanks

  • @hameedmanji8552
    @hameedmanji8552 3 года назад

    This should’ve broke the internet! Great Work! Can’t find this anywhere..not even in any of the php books I’ve bought! Thank you again!

  • @donnfredericklucas9705
    @donnfredericklucas9705 4 года назад +2

    I've watched a lot of pagination tutorial, but this is the simplest of it

  • @gabryvitale4671
    @gabryvitale4671 4 года назад

    tu sei un grande, in poche righe di codice hai fatto ciò che altri hanno fatto in un centinaio di righe. Sei un grande

  • @anuragmishra6475
    @anuragmishra6475 4 года назад +3

    Awesome tutorial, each and every step is so crystal clear. First I totally watched it and then tried, it doesn't require me to look back to the tutorial again, so nicely he has explained.

  • @ArmanAli-sp3sh
    @ArmanAli-sp3sh 2 года назад

    Simplest tutorial on youtube to implement pagination... Thank you

  • @MrApacis
    @MrApacis 5 лет назад +10

    I wish everyone was explaining stuff as you do.
    Great tutorial man!
    Thank you!

  • @Mustafakamal-lt4ib
    @Mustafakamal-lt4ib 6 лет назад

    you are great this video is really helpfull.for two days i fall in trouble to paginate pages this video remove my troubleness.I love you brother
    God bless u and all of your family members.

  • @danimatuko
    @danimatuko 5 лет назад +1

    Watched too many tutorials, this is the best. Simple and easy.

  • @ahmedabdelmalik-3050
    @ahmedabdelmalik-3050 3 года назад

    it's not just helpful bro, it's amazing , the way you explain and code, great work.

  • @buynsell365
    @buynsell365 5 лет назад +1

    WOW !!!! This is the BEST tutorial I have ever seen for pagination. I have been struggling with doing this for a long time until I came across your video. Everything works GREAT and I actually understand it now. THANK YOU !!!

  • @vs1toronto372
    @vs1toronto372 2 года назад

    In the hall of geniuses you definitely have a seat, fantastic tutorial!!!

  • @shanksharma5117
    @shanksharma5117 4 года назад

    One of the best video still..!!, since 2016
    Thanks dear for sharing your advanced knowledge ;)

  • @karthikjo6875
    @karthikjo6875 3 года назад

    Very useful for me.....your teaching is very awesome....

  • @PeterKokot
    @PeterKokot 6 лет назад +1

    Very nicely and simple explained. Thanks for sharing this. Just one minor yet crucial part - the usage of prepared statements are missing. SQL injection concern is always present no matter how you embed external part of the SQL string into the main SQL sentence (for example, in the video where the LIMIT part consists of external variables. That's just in case when in the future something not trusted might get pasted into the SQL string. And also XSS injection in case that happens might be good to be aware of (when echoing the $page number).

    • @ifargantech
      @ifargantech 2 года назад

      Any one who can explain this issue in detail, please?

  • @kanonlast8241
    @kanonlast8241 3 года назад

    Awesome explanation!!!! loved the keyboard sound !!!! Amazing

  • @niyongaboeric
    @niyongaboeric 6 лет назад

    idea of pagination video was indeed long-term thinking. thanks brother keep up

  • @prakashjangir412
    @prakashjangir412 5 лет назад

    One of the best pagination video i have watched on youtube

  • @yanjim
    @yanjim 7 лет назад +1

    Logic is quite exciting. Thank you mate, I'm learning PHP now and these pagination things always seemed wonderfull for me, even though it's very simple.

  • @Ruhgtfo
    @Ruhgtfo 6 лет назад

    Finally, a short and simple code that works, immediate subscribed

  • @akshayshrivastav866
    @akshayshrivastav866 6 лет назад +1

    I was creating a blog model from scratch in which I needed to create a pagination system, this video helps me perfectly step by step. Thanks, also would like to know how to keep them SEO Friendly.

  • @alphamx13
    @alphamx13 Год назад

    Awesome! I added some extra options to show only 10 records per page on the pagination.

  • @zakidzz
    @zakidzz 3 года назад

    the best tutorial in the whole universe

  • @akshatporwal9230
    @akshatporwal9230 2 года назад

    So easily and clearly explained

  • @SharCourse
    @SharCourse 4 года назад

    You made it easy to understand it. Thank you very much for the tutorial 🇿🇦

  • @victorchioke3437
    @victorchioke3437 2 года назад

    Thank you so much for this video. This helped alot.
    It's quite inspiring how this video from 6 years ago is still helping today lol. Thanks tho and God bless!

  • @Ait-uz1vc
    @Ait-uz1vc 4 года назад

    Thanks for the explanation! One of the best videos of pagination out there!

  • @ishagupta932
    @ishagupta932 4 года назад

    very easy to understand and really helpful...

  • @Bestin2maria
    @Bestin2maria 7 лет назад +28

    Best Tutorial and helpful. thanks buddy:)

  • @Cianuncios
    @Cianuncios 3 года назад

    Very good. Your code is working fine. Thank very much for sharing. Best regards

  • @gowthambhat1498
    @gowthambhat1498 3 года назад

    excellent man, love from India

  • @LightningFox2407
    @LightningFox2407 4 года назад

    Concise and clearly explained - brilliant. Thanks!

  • @MdMasudRana-hi4wl
    @MdMasudRana-hi4wl 7 лет назад

    best tutorial i ever seen on pagination.thanks

  • @afikile
    @afikile 7 лет назад

    Just for your clarity, I've subscribed. Thanks mate, very easy to follow tutorial. 100 thumbs up.

  • @user-ir4ze3hx9d
    @user-ir4ze3hx9d 6 лет назад +1

    Really well structured tutorial. Thanks for that!

  • @JonathanVillafranca
    @JonathanVillafranca 3 года назад

    Great, very, very helpfull. Thanks from Mexico.

  • @cincosolution
    @cincosolution 7 лет назад

    Best pagination tutorial ever.Thank you Less.

  • @marocchic1003
    @marocchic1003 5 лет назад

    i wish for you all the best , the best tutorial better than indians tutorials :'D

  • @mephystto2181
    @mephystto2181 6 лет назад +1

    Works just perfectly.Thank you very much, sir.

  • @TrueFactors
    @TrueFactors 3 года назад

    very nice tutorial man, i could recreate it using PDO because i understand the logic beside the programm, you explain very well

  • @bhaskararaogummidi6133
    @bhaskararaogummidi6133 7 лет назад

    easily and clearly understandable...thank you very much

  • @lucasianii8178
    @lucasianii8178 3 года назад

    Just what I was looking for to learn, Voyager thanks.

  • @matheshrx8625
    @matheshrx8625 3 года назад

    no wonder,useful in 2021
    tqsm Sir

  • @mohammadabuata3013
    @mohammadabuata3013 5 лет назад

    You've earned a subscriber for this great and straight to the point tutorial.

  • @ricardoalinas6167
    @ricardoalinas6167 Месяц назад +1

    Works perfectly, thanks

  • @craisondigital
    @craisondigital 7 лет назад

    I converted to PDO. Works great! Thanks!

  • @hamzachoudhary1468
    @hamzachoudhary1468 5 лет назад +1

    Great Explanation man Very very helpful thanks a lot man...

  • @aromalunnikrishnan161
    @aromalunnikrishnan161 4 года назад

    Watched it just now. and it helped me. very useful

  • @ariescayetano6107
    @ariescayetano6107 7 лет назад

    Easy and helpfull. keep up the good work mate

  • @akhilvijay8670
    @akhilvijay8670 5 лет назад

    Thanks for the great tutorial..Nice and simple...Please continue the part-2 video with style sheet and remaining portions.Make it a complete tutorial

  • @vasyldovhan6084
    @vasyldovhan6084 6 лет назад +1

    You are the best man, it was so helpful in my work. Thanks

  • @choyoung.p3809
    @choyoung.p3809 3 года назад

    Awesome! So easily explained. Thanks a lot!

  • @mohamedsobhi3977
    @mohamedsobhi3977 4 года назад

    THE BEST tutorial in the world .. Thank you

  • @lynnnana5633
    @lynnnana5633 7 лет назад

    Great Tutorial, very simple and with a good explanation. it works great. I trying to add previous and next links using bootstrap

  • @simiyukuloba3109
    @simiyukuloba3109 3 года назад +1

    i Love the keyboard

  • @vaskardiwakar8296
    @vaskardiwakar8296 6 лет назад

    simple and superb video

  • @robertorafulgs5423
    @robertorafulgs5423 5 лет назад

    watched many tutorials, this one helped me alot

  • @pockeybearmilk264
    @pockeybearmilk264 7 лет назад

    very gooooood tutorial , you explain it very well , thank you

  • @sudheer-suri
    @sudheer-suri 3 года назад

    Great, but what happens if we upload something thats not image, how to send error message back to view incase of errors

  • @AhmedAli-ky6jt
    @AhmedAli-ky6jt 5 лет назад +1

    it's work on local host but when i upload it on live server it don't work can you please help me to solve this problem ??

  • @jamesoduro6772
    @jamesoduro6772 5 лет назад +6

    I think you should improve your code to add PREV ,NEXT buttons
    also set limit for pagers...else if we have ...lets say 1,000 pages ...pagers will be echoed 1,000 times....which is very awful

    • @jeffersondulay3756
      @jeffersondulay3756 5 лет назад

      Yeah thats what im thinking, i manage to make the next and prev links for this code but i still dont know hoe to limit my links😭

  • @Ayayayupiyupiyey
    @Ayayayupiyupiyey 7 лет назад +5

    Very nice tutorial, its very helpful :)

    • @twinkleee4621
      @twinkleee4621 7 лет назад

      HriedoPotettoGam
      99okkkkk0 A
      ..
      ₩$--

  • @adeyemiadeshina3988
    @adeyemiadeshina3988 5 лет назад +1

    You are good man! You just made my day.

  • @PrimephotoStudio
    @PrimephotoStudio 6 лет назад

    Nice video, thank you for sharing it.

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

    Thanks great tutorial still works 2020

  • @oantoniolima
    @oantoniolima 3 года назад

    Super helpful and really clear! Thank you very much!

  • @albertmuhatia
    @albertmuhatia 6 лет назад +2

    thanks!!Great tutorial..Iam implementing it somewhere

  • @RayZde
    @RayZde 3 года назад

    For advanced users you need to do a count then a second query with limit and offset.

  • @VFRodriguez
    @VFRodriguez 4 года назад

    Good job! What I do not understand is why some people use the database connection in two lines, selecting the database name in the second line and not this one which seems more simple $con = mysqli_connect('localhost','root', '', ''databasename) ;

  • @alifathalian9516
    @alifathalian9516 7 лет назад

    in fact this is a good tutorial , thanks for your spared time.

  • @johnmutua9863
    @johnmutua9863 4 года назад

    Thank you VERY much. This code WORKED PERFECTLY! God bless you.

  • @theplatinum1898
    @theplatinum1898 2 года назад

    my code works perfectly but only for the first page , immediately when i select the second page it shows me all the page numbers with results i didnt apply the filter to

  • @ilincuta
    @ilincuta 7 лет назад

    You explain it so well, thank you.

  • @bobyjavascript9367
    @bobyjavascript9367 4 года назад

    great and clean guide

  • @hd-shortz
    @hd-shortz 6 лет назад

    I resolve my mistake thanks so much😊 Ultimate video Great work

  • @jiolomilesngo6065
    @jiolomilesngo6065 4 года назад

    goodjob bro my salary was doubled because of this tutorial

  • @critbyte
    @critbyte 4 года назад

    watching in 2020, still very helpful :)

  • @hemasingamsetty5555
    @hemasingamsetty5555 7 лет назад

    hi this tutorial is clean and clear.my doubt is suppose say there are 20000 records in the databse.I would like to display 50 records per page.Then the total no of pages are 400.Then how to display pagination?

  • @rahulbhagwat8799
    @rahulbhagwat8799 4 года назад

    very good explanation..only query i have is that can we change the page index number design somehow...?

  • @paulogbanje8472
    @paulogbanje8472 3 года назад

    Thank you so very much, I am grateful for this.

  • @johnbuxton2945
    @johnbuxton2945 4 года назад

    I love this man!

  • @chigonzales6824
    @chigonzales6824 7 лет назад

    Well explained!
    Commended sir.

  • @Deepak-dx3ox
    @Deepak-dx3ox 7 лет назад

    i am using these code with where clouse and it work but when i click on next button it doesn't show anything and just showiing undefined variable name...what to do...???

  • @ApnaChannel-od1kw
    @ApnaChannel-od1kw 6 лет назад

    very goood and easy tutorial thanks sir

  • @JyotiEntertainmentProduction
    @JyotiEntertainmentProduction 2 года назад +1

    Sir,
    1) If the Total number of selected records(parameterized) is less than $results_per_page, how to disable or hide the pagination?
    2) What if the number of selected record is huge, say more than 100, will it display more than 100 pagination links?
    Please reply. Thank You.

  • @PrinceAjibola
    @PrinceAjibola 8 лет назад

    This tutorial is grate. Please i need a help on a section your your snippet. How can i change the result to display
    from latest entry. That is to display form back (latest entry) to the first (old Entry) in descending order. Thanks

  • @youwindizz
    @youwindizz 4 года назад

    how about if its random(1,20) and 1 question per page

  • @zekiinworld
    @zekiinworld 7 лет назад

    Thanks you our brother! it is very helpful.

  • @ifargantech
    @ifargantech 2 года назад

    Aww what a wonderful tutorial awww again!

  • @AmitShwetaSharma
    @AmitShwetaSharma 6 лет назад

    Thumps up , quick to the point.

  • @ved_ituas
    @ved_ituas 4 года назад

    Ok this code is smart, as i type it in my IDE, i keep on asking myself "HOW DID HE FIGURE THIS OUT"...thank you man

    • @geren_pulse
      @geren_pulse 4 года назад

      That's not the best way to create a pagination system. In this way, if you have 3000 posts you will have 300 links in your pagination. The hardest part of the pagination system is showing current page, its next page and its previous page along with first page and last page

    • @ved_ituas
      @ved_ituas 4 года назад

      @@geren_pulse I was also kind of thinking about the number of links in the pagination when the number of posts increases.... You're right, so now I'll have to figure the hard part, showing the first and last link and also hiding some of the links....

    • @hmza-themes4786
      @hmza-themes4786 4 года назад

      @@ved_ituas you found a solution for prev and next bro ?

    • @ved_ituas
      @ved_ituas 4 года назад

      @@hmza-themes4786 Yeah i did, but its got a bit more code.

    • @hmza-themes4786
      @hmza-themes4786 4 года назад

      @@ved_ituas can you please share with me ?

  • @scarface1013
    @scarface1013 5 лет назад +1

    Outstanding! Thank you!

  • @mustafahussien6588
    @mustafahussien6588 4 года назад

    That was very helpful! thank you

  • @azolirai
    @azolirai 3 года назад

    Very good tutorial thank you so much!

  • @epul_luppy
    @epul_luppy 3 года назад

    Hello, I really hope you can see my comment at this time, your tutorial is great, but, I have a little bit problem. I am using server host which is cPanel phpmyadmin. When trying to redirect back to index page, its not working, and not display any data. Can you help me?

  • @mahirise6673
    @mahirise6673 5 лет назад

    how create next and previous buttons???

  • @twiggy99
    @twiggy99 7 лет назад

    Any reason you choose to go against the industry standard PSRs?

  • @michaelangeloestor5018
    @michaelangeloestor5018 6 лет назад

    Best tutorial man, thumbs up !

  • @furti
    @furti 3 года назад

    Thanks! amazing tutorial