Create Pagination in PHP and MySQL

Поделиться
HTML-код
  • Опубликовано: 10 сен 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

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

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

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

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

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

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

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

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

    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.

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

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

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

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

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

    u explained flue and plain.great thanks

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

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

    Best Tutorial and helpful. thanks buddy:)

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

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

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

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

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

  • @akshayshrivastav866
    @akshayshrivastav866 5 лет назад +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.

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

    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!

  • @yanjim
    @yanjim 6 лет назад +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.

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

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

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

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

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

    One of the best pagination video i have watched on youtube

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

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

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

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

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

    Works just perfectly.Thank you very much, sir.

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

    Concise and clearly explained - brilliant. Thanks!

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

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

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

    So easily and clearly explained

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

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

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

    Best pagination tutorial ever.Thank you Less.

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

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

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

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

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

    Great, very, very helpfull. Thanks from Mexico.

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

    best tutorial i ever seen on pagination.thanks

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

    Awesome! So easily explained. Thanks a lot!

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

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

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

    Really well structured tutorial. Thanks for that!

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

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

    the best tutorial in the whole universe

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

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

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

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

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

    very easy to understand and really helpful...

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

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

    I converted to PDO. Works great! Thanks!

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

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

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

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

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

    no wonder,useful in 2021
    tqsm Sir

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

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

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

    easily and clearly understandable...thank you very much

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

    excellent man, love from India

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

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

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

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

    Thanks great tutorial still works 2020

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

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

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

    thanks!!Great tutorial..Iam implementing it somewhere

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

    Super helpful and really clear! Thank you very much!

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

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

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

    You are good man! You just made my day.

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

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

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

    Outstanding! Thank you!

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

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

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

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

    Very nice tutorial, its very helpful :)

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

      HriedoPotettoGam
      99okkkkk0 A
      ..
      ₩$--

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

    I love this man!

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

    You explain it so well, thank you.

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

    watched many tutorials, this one helped me alot

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

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

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

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

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

    Very good tutorial thank you so much!

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

    Simple and helpful! Thank you 👍

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

    That was very helpful! thank you

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

    Thank you very much for this tutorial !

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

    watching in 2020, still very helpful :)

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

    goodjob bro my salary was doubled because of this tutorial

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

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

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

    Thanks you our brother! it is very helpful.

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

    Thank you so much
    very useful for my c# project

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

    great and clean guide

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

    Thumps up , quick to the point.

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

    This is awesome! Thanks Simon!

  • @Dexter101x
    @Dexter101x 7 лет назад +25

    Is it possible to make the keyboard a bit louder, I can't quite hear it

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

      haha I laughed out loud, smashing those keys.

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

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

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

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

    Thanks! amazing tutorial

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

    Easy and helpfull. keep up the good work mate

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

    thank you very much brother, the tutorial is very helpful

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

    Best tutorial man, thumbs up !

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

    Thanks, clear explanation.

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

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

    i Love the keyboard

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

    thanks Simon Suh

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

    A great tutorial, thank you!

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

    excellent thank you very much

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

    I have an error please fix for me. Notice: A non well formed numeric value encountered in C:\Test\htdocs\page.php on line 41

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

    Great tutorial, very helpful !

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

    Very very helpful!!! Thank you

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

    Thank you so much!

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