Create Pagination in PHP and MySQL

Поділитися
Вставка
  • Опубліковано 25 жов 2024
  • source code: github.com/sim...
    Join my Facebook group to learn more about web development - www.facebook.c...

КОМЕНТАРІ • 246

  • @joelpeterson4263
    @joelpeterson4263 5 років тому +84

    Amazing tutorial, loudest keyboard in the whole universe

    • @Vikrantvirdi
      @Vikrantvirdi 4 роки тому +1

      hahaha

    • @jeremievoyer6093
      @jeremievoyer6093 3 роки тому +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 2 роки тому

    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

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

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

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

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

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

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

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

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

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

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

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

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

  • @Bestin2maria
    @Bestin2maria 7 років тому +28

    Best Tutorial and helpful. thanks buddy:)

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

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

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

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

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

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

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

    One of the best pagination video i have watched on youtube

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

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

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

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

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

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

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

  • @Ait-uz1vc
    @Ait-uz1vc 4 роки тому

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

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

    Awesome! So easily explained. Thanks a lot!

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

    Concise and clearly explained - brilliant. Thanks!

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

    Great, very, very helpfull. Thanks from Mexico.

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

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

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

    Works just perfectly.Thank you very much, sir.

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

    Best pagination tutorial ever.Thank you Less.

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

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

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

    best tutorial i ever seen on pagination.thanks

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

    very easy to understand and really helpful...

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

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

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

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

    Really well structured tutorial. Thanks for that!

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

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

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

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

  • @akshatporwal9230
    @akshatporwal9230 Рік тому

    So easily and clearly explained

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

    easily and clearly understandable...thank you very much

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

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

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

    no wonder,useful in 2021
    tqsm Sir

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

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

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

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

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

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

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

    the best tutorial in the whole universe

  • @alphamx13
    @alphamx13 Рік тому

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

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

    THE BEST tutorial in the world .. Thank you

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

    I converted to PDO. Works great! Thanks!

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

    Easy and helpfull. keep up the good work mate

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

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

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

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

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

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

    Very nice tutorial, its very helpful :)

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

      HriedoPotettoGam
      99okkkkk0 A
      ..
      ₩$--

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

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

    You are good man! You just made my day.

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

    Super helpful and really clear! Thank you very much!

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

    I love this man!

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

    Thanks great tutorial still works 2020

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

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

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

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

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

    very goood and easy tutorial thanks sir

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

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

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

    Thanks you our brother! it is very helpful.

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

    watched many tutorials, this one helped me alot

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

    watching in 2020, still very helpful :)

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

    thanks!!Great tutorial..Iam implementing it somewhere

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

    That was very helpful! thank you

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

    Thanks! amazing tutorial

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

    Aww what a wonderful tutorial awww again!

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

    Nice video, thank you for sharing it.

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

    You explain it so well, thank you.

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

    simple and superb video

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

    Very good tutorial thank you so much!

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

    Best tutorial man, thumbs up !

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

    great and clean guide

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

    goodjob bro my salary was doubled because of this tutorial

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

    Well explained!
    Commended sir.

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

    Simple and helpful! Thank you 👍

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

    Thumps up , quick to the point.

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

    This is awesome! Thanks Simon!

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

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

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

    Nice tutorial sir

  • @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 4 роки тому

      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😭

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

    Outstanding! Thank you!

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

    i Love the keyboard

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

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

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

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

    Thanks, clear explanation.

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

    Great tutorial, very helpful !

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

    Simply great 🤘

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

    Great tutorial, very helpful ! :)

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

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

    Really really great tutorial :)

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

    Thank you so much
    very useful for my c# project

  • @BilalRehan-bl6bx
    @BilalRehan-bl6bx 5 років тому

    very nice very helpful.

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

    Very very helpful!!! Thank you

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

    Thanks nice explanation