Create Pagination in PHP and MySQL

Поділитися
Вставка
  • Опубліковано 1 січ 2025

КОМЕНТАРІ • 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 3 роки тому +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!

  • @ArmanAli-sp3sh
    @ArmanAli-sp3sh 2 роки тому

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

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

  • @MrApacis
    @MrApacis 5 років тому +10

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

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

  • @ahmedabdelmalik-3050
    @ahmedabdelmalik-3050 3 роки тому

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

  • @donnfredericklucas9705
    @donnfredericklucas9705 4 роки тому +2

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

  • @danimatuko
    @danimatuko 5 років тому +1

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

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

  • @karthikjo6875
    @karthikjo6875 3 роки тому

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

  • @shanksharma5117
    @shanksharma5117 4 роки тому

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

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

  • @kanonlast8241
    @kanonlast8241 3 роки тому

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

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

  • @vs1toronto372
    @vs1toronto372 2 роки тому

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

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

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

  • @JonathanVillafranca
    @JonathanVillafranca 3 роки тому

    Great, very, very helpfull. Thanks from Mexico.

  • @niyongaboeric
    @niyongaboeric 6 років тому

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

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

  • @LightningFox2407
    @LightningFox2407 4 роки тому

    Concise and clearly explained - brilliant. Thanks!

  • @afikile
    @afikile 7 років тому

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

  • @SharCourse
    @SharCourse 4 роки тому

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

  • @matheshrx8625
    @matheshrx8625 3 роки тому

    no wonder,useful in 2021
    tqsm Sir

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

  • @mohammadabuata3013
    @mohammadabuata3013 5 років тому

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

  • @mephystto2181
    @mephystto2181 6 років тому +1

    Works just perfectly.Thank you very much, sir.

  • @bhaskararaogummidi6133
    @bhaskararaogummidi6133 7 років тому

    easily and clearly understandable...thank you very much

  • @akshatporwal9230
    @akshatporwal9230 2 роки тому

    So easily and clearly explained

  • @user-ir4ze3hx9d
    @user-ir4ze3hx9d 6 років тому +1

    Really well structured tutorial. Thanks for that!

  • @aromalunnikrishnan161
    @aromalunnikrishnan161 4 роки тому

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

  • @alphamx13
    @alphamx13 2 роки тому

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

  • @MdMasudRana-hi4wl
    @MdMasudRana-hi4wl 7 років тому

    best tutorial i ever seen on pagination.thanks

  • @cincosolution
    @cincosolution 7 років тому

    Best pagination tutorial ever.Thank you Less.

  • @lucasianii8178
    @lucasianii8178 3 роки тому

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

  • @vasyldovhan6084
    @vasyldovhan6084 6 років тому +1

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

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

  • @hamzachoudhary1468
    @hamzachoudhary1468 5 років тому +1

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

  • @gowthambhat1498
    @gowthambhat1498 3 роки тому

    excellent man, love from India

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

  • @choyoung.p3809
    @choyoung.p3809 3 роки тому

    Awesome! So easily explained. Thanks a lot!

  • @ariescayetano6107
    @ariescayetano6107 7 років тому

    Easy and helpfull. keep up the good work mate

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

  • @ricardoalinas6167
    @ricardoalinas6167 Місяць тому +1

    Works perfectly, thanks

  • @Ayayayupiyupiyey
    @Ayayayupiyupiyey 7 років тому +5

    Very nice tutorial, its very helpful :)

    • @twinkleee4621
      @twinkleee4621 7 років тому

      HriedoPotettoGam
      99okkkkk0 A
      ..
      ₩$--

  • @mohamedsobhi3977
    @mohamedsobhi3977 4 роки тому

    THE BEST tutorial in the world .. Thank you

  • @johnmutua9863
    @johnmutua9863 4 роки тому

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

  • @pockeybearmilk264
    @pockeybearmilk264 7 років тому

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

  • @oantoniolima
    @oantoniolima 3 роки тому

    Super helpful and really clear! Thank you very much!

  • @albertmuhatia
    @albertmuhatia 6 років тому +2

    thanks!!Great tutorial..Iam implementing it somewhere

  • @photoinshot1355
    @photoinshot1355 4 роки тому

    Thanks great tutorial still works 2020

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

  • @marocchic1003
    @marocchic1003 5 років тому

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

  • @paulogbanje8472
    @paulogbanje8472 3 роки тому

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

  • @zakidzz
    @zakidzz 3 роки тому

    the best tutorial in the whole universe

  • @azolirai
    @azolirai 3 роки тому

    Very good tutorial thank you so much!

  • @zekiinworld
    @zekiinworld 7 років тому

    Thanks you our brother! it is very helpful.

  • @alifathalian9516
    @alifathalian9516 7 років тому

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

  • @robertorafulgs5423
    @robertorafulgs5423 5 років тому

    watched many tutorials, this one helped me alot

  • @PrimephotoStudio
    @PrimephotoStudio 6 років тому

    Nice video, thank you for sharing it.

  • @adeyemiadeshina3988
    @adeyemiadeshina3988 5 років тому +1

    You are good man! You just made my day.

  • @simiyukuloba3109
    @simiyukuloba3109 3 роки тому +1

    i Love the keyboard

  • @edd9353
    @edd9353 5 років тому

    Simple and helpful! Thank you 👍

  • @mustafahussien6588
    @mustafahussien6588 4 роки тому

    That was very helpful! thank you

  • @craisondigital
    @craisondigital 7 років тому

    I converted to PDO. Works great! Thanks!

  • @hd-shortz
    @hd-shortz 6 років тому

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

  • @vaskardiwakar8296
    @vaskardiwakar8296 6 років тому

    simple and superb video

  • @chigonzales6824
    @chigonzales6824 7 років тому

    Well explained!
    Commended sir.

  • @dushyanthkandiah3718
    @dushyanthkandiah3718 6 років тому

    Thank you so much
    very useful for my c# project

  • @mahirise6673
    @mahirise6673 5 років тому

    thank you very much brother, the tutorial is very helpful

  • @bobyjavascript9367
    @bobyjavascript9367 4 роки тому

    great and clean guide

  • @ilincuta
    @ilincuta 7 років тому

    You explain it so well, thank you.

  • @ApnaChannel-od1kw
    @ApnaChannel-od1kw 6 років тому

    very goood and easy tutorial thanks sir

  • @astritspanca2723
    @astritspanca2723 6 років тому

    Thanks man! It was pretty helpful to start with..

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

  • @johnbuxton2945
    @johnbuxton2945 4 роки тому

    I love this man!

  • @critbyte
    @critbyte 4 роки тому

    watching in 2020, still very helpful :)

  • @smartcityfoods2744
    @smartcityfoods2744 7 років тому

    This is awesome! Thanks Simon!

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

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

  • @michaelangeloestor5018
    @michaelangeloestor5018 6 років тому

    Best tutorial man, thumbs up !

  • @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) ;

  • @AmitShwetaSharma
    @AmitShwetaSharma 6 років тому

    Thumps up , quick to the point.

  • @furti
    @furti 3 роки тому

    Thanks! amazing tutorial

  • @ifargantech
    @ifargantech 2 роки тому

    Aww what a wonderful tutorial awww again!

  • @develocode7773
    @develocode7773 6 років тому

    Great tutorial, very helpful !

  • @rahulbhagwat8799
    @rahulbhagwat8799 4 роки тому

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

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

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

  • @scarface1013
    @scarface1013 5 років тому +1

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

  • @motivevibe2504
    @motivevibe2504 4 роки тому

    Thanks nice explanation

  • @alcaravan555
    @alcaravan555 5 років тому

    Thanks, clear explanation.

  • @anikethdeshpande8336
    @anikethdeshpande8336 7 років тому

    Very very helpful!!! Thank you