37: How to show database data on a website using MySQLi | PHP tutorial | Learn PHP programming

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

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

  • @davescorneroftheworld1147
    @davescorneroftheworld1147 Год назад +5

    WOW, you did that in 11:18. It took my about 5 hours... ALL MY FAULT... While I was trying to create the TABLE "users" I typed in "user"... After I finely figured out what I did wrong, got the table created, then I FORGOT the user_uid column. Had to delete and start over, I could not figure out how to "add" a column. BUT I got it done!!
    😜Go ahead and laugh... Sometimes I can not see the most simple things...😃
    I STILL thing you are the very best instructor. THANK YOU MANY TIMES OVER!!!

  • @lawrencemichael5571
    @lawrencemichael5571 4 года назад +96

    in 11 minutes you managed to explain in a simple and clear way what others take 20-30 minutes.
    You are amazing.

  • @attention2detail948
    @attention2detail948 Год назад +2

    I've never actually heard anyone actually use the word actually in any actual RUclips so often, actually! Just kidding, I love your videos and I think you speak English very well, and teach nicely

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

      Yeah i do that a lot in this older course 😂 I have a newer 2023 course on my channel, which is much better 🙂

  • @crazyedude1846
    @crazyedude1846 5 лет назад +18

    I have been staring at code and tutorials for hours now and this is the first tutorial that's actually helped! Thank you!

  • @gokhantaskan3208
    @gokhantaskan3208 6 лет назад +76

    I've learned PHP in this series! Just for helping a friend to finish his work

  • @cheesydrippin
    @cheesydrippin Год назад +2

    Man, thank you so much! I can't fathom how hard it was for me to figure this out by myself until I decided to look this up. Really detailed, understanding and genuine to follow along, this had helped me for my college assignment.
    Kudos!

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

    Came here because in university,my PHP teacher is awful. If this makes you feel proud,you are a WAY better teacher using only videos,than a University Professor with 40 years of experience struggling to explain PHP for 5 hours straight. I'll check everything in your channel and subscribe!

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

    You are the first person that I have found that is clear and simple.

  • @ishmaelbanda4504
    @ishmaelbanda4504 5 лет назад +2

    Am i the only guy who subscribed to his channel upon watching his first vid?...This guy is brilliant...He produces nice work, easy to follow and apprehend

  • @David-Rymer
    @David-Rymer 5 лет назад

    this is way easier. the php script i had copied from some regestration form worked but i didnt understand it for a long time, until i found this vid. nice one dude : )

  • @manoj.k.m4302
    @manoj.k.m4302 2 года назад

    Crystal clear explanation for anyone who is not understanding try to recall the previous videoqs

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

    Just an FYI in case anyone else has the same issues I've been having trying to get this to work: On the password variable I had to pass 'root' rather than leaving it empty. Great lessons though, thanks Daniel!

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

      Definitely helped! And thanks Daniel!

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

    thanks man, I had two hours to my deadline, and I finished my assignment thanks to you. Thank you!!

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

    Wow!!!
    I love your PHP tutorials sir.
    You're a totally amazing person, Thank You!!

  • @mathewkings9806
    @mathewkings9806 5 лет назад +2

    Thank you so much bro your video just helped me solve a problem i have been battling for the past 8 hours, I really appreciate it.

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

    IMPORTANT!! Let me tell you guys Im coming from HTML and CSS where i learned everything and all was clear in php until this lesson, but because i'm a supporter in Patreon i can download the files that MMTUTS upload there, IM SAYING this because those files are very clear "commented inside of the code" where you can understand something that is not clear at all here. thanks for all this Job, keep doing this, because you are changing peoples life's, even if you don't see it.

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

    Your videos are helping alot...Best teacher on RUclips. Respect

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

    man thank you so much you're carrying my web dev project tysm

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

    Excellent! Now I make my queries with no problems at all through PhP. Thanks a lot

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

    I'm a beginner. I'm happy with your tutorial videos. I really thank you so much.

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

    Dani, thank you so much for this online course. I can't express enough gratitude for the quality of your teaching.

  • @GaboG85
    @GaboG85 Год назад +1

    Thanks for this tutorial!!!!
    By the way, I find the mysqli method more useful and easier to understand than the PDO method.

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

    One who deserves M+ subs. keep it up bro

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

    Dude...you are like literally the best teacher...Thanks alot for this tutorial..Thank You

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

    Thank you so much for your great videos :) They are simple, clear and it is amazing how much effort you give in order to help others to understand and learn the basics. Thank you!

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

    One thing I haven't told you is that you are the one who made Me to be a software engineer, I have watched all your videos,, funny part is that I normally understand the way you teach more than anyone else

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

    It helps me a lot. Thanks from Mexico.

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

    at first i didnt understand the code but then i constantly observed and googled everything then i know great!! its not in other people channels

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

    You are awesome, especially since English is not your first language. Great teacher. Keep it up.

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

    Maaan u are a ganster.your explanations are very helpful.tnx

  • @royceronningen9934
    @royceronningen9934 7 лет назад +14

    Thanks for these videos! I have already learned this before, but it's nice to get another perspective - since you explain things very well! Great job bro!

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

    good video, like!

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

    Great video. Got me binge watching now. So far everything presented works for me without error. Wish files were available here, but code is not too long I can't just pause and type myself. Thanks again

  • @Bahelord
    @Bahelord 7 лет назад +2

    bro. i watched your video about PHP. it helps me a lot thx man

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

    You are an incredible teacher...well done and may God bless you abundantly

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

    Thank you very much i am just surprise you just explain in 11 minutes with 8 line of code thank you very much

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

    Great Job Man! You are literally saving lives and helping people better their income< the society and affecting the lives of pople around them!

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

    Thank you very much sir! You are the reason my school project finally works!

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

    Awesome! I've learned a lot from you, thanks for your tutorial, I am from taiwan

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

    In the hopes of saving someone out there some time:
    Please make sure that you are using mysqli_query/(); and not mysql_query, especially if your error is about the $conn variable or the error mentions a string was expected.

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

      Not sure why now, but I appear to be getting a parse error on that line for an unexpected comma? Any ideas why?

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

    i have no idea why i am so happy something works

  • @j-rl1153
    @j-rl1153 4 года назад

    Amazing! Crystal clear! Thank you :)

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

    best teacher. thankyou

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

    best tutorials ever!!!

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

    thanks! it worked for me.

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

    Sir the browser saying error on line 18 which is..
    echo $row['user_uid'];
    Can you tell me what is user there... I have different dataset called Name in my database so I written Name there..

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

    Really good stuff man

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

    This is the best PHP tutorial. Thank you for such a superb series of lectures!!!

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

    Nailed it Bro.... Super learning... What a great lessons... Thank you and keep posting...

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

    thanks man l learned very well from you, greetings from mexico

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

    You are super powerful and easy to follow. Thanks for sharing you skills. Thumbs up
    and I will keep checking you

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

    Thanks a lot . Your teaching method is really cool . carry on

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

    Good pacing and clear explanation. Thanks!

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

      I hope u understood this vdo fully.... Help me here.... I don't understand how he connect the SQL database table('users' ... In this vdo) with the php code.. what s d code to link SQL database table with the php code?? Thx in adv :-)

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

    this helped me solve a problem in work. Thank you very much

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

    Awesome tutorials! I LOVE THEM!

  • @rockon-wbfqlkjqhsydic72683
    @rockon-wbfqlkjqhsydic72683 4 года назад

    Great videos! You take your time and explain everything, and you are very understandable :)

  • @troyyoung8167
    @troyyoung8167 9 месяцев назад

    Works for me. Thank you.

  • @AbhishekKumar-yv6ih
    @AbhishekKumar-yv6ih 7 лет назад +1

    crystal clear concept.....Thanks man!

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

    thank you man, you're a good teacher

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

    Can you make a tutorial on how to display an image store on some location and that location is stored in a database?
    And thanks for helping me on PHP .

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

    For the file "dbh.ini.php" make sure you input the proper values that you have already create to log into your phpMyadmin and make sure the text cases match correctly.

  • @wannabehuman.production
    @wannabehuman.production 6 лет назад +1

    how to get ur var in green and stuff in sublime i am using sublime v3 and i dont get it though ?

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

    great lessons you have there mate, keep it up!

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

    Thank you so much sir

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

    So many variations on this. I had a problem with some PHP code, though I shouldn't because I had been using SQL for decades so I know all about semi colons, but I still missed it as I hadn't included a ; at the end of the code. And this is so common that It really shouldn't have been a problem for me. Even when others have come to me for help it's been a parenthesis problem.

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

    I really like your tutorials and your channel. Thank you for such a good work!

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

    Great tutorial !!!. I learn so much from you. Huge thank you.

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

    THANK YOU SIR I GOT IT!!

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

    love the video! helped me a lot, thx

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

    just love your tutorial

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

    Thanks for the videos sir! I learned PHP from scratch watching your videos. You are a great teacher. I cant understand what is mysqli_fetch_assoc( )? And ' assoc ' specially. Thanks again.

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

      "fetch_assoc" means "Get associative array". In my array video in this course I explain what associative arrays are :)

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

      Thanks!

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

      @@Dani_Krossing Fatal error: Uncaught Error: Call to undefined function mysql_fetch_assoc()
      what can I do in this case ?

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

      I know it's late but anyway. Did you tried mysqli_fetch_assoc() :)

  • @Oprekode
    @Oprekode 6 месяцев назад

    Good tutorial

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

    Do you have to make a table in PhpMyAdmin manually too?

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

    Absolutely brilliant. Would be better if you put the material free tho. An who other than me thinks this guy should work for MIT.

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

    Thanks a lot, this has been really helpful!!

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

    Thanks for these man.. this is so usefull for beginners like me.. i understand what im doing in my php code now

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

    I love your videos!! I feel like I'm learning at lightning speed! ? What code editor are you writing with?

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

    If $result variable is an array, instead a while loop we could use a foreach loop?

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

    That's cool & simple trick brother. Thank you so much. I got something from here to my project.

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

    I am a bit confused. So you can create variable inside the while condition? Or this is some kind of super variable that works with query language?

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

    Good work. Thanks.

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

    Thank you vey much for this video.

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

    Dani, you're great. THank you!

  • @زينه-س8ز
    @زينه-س8ز 2 года назад

    Thank you so much 💗💗💗

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

    Great !! thanks a lot.

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

    thanks for your video tutorials it really helps me a lot

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

    Thank you, your video really helped me

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

    . seemed i already had a guy to follow in web dev . going to follow your ways bwt authentication sir .

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

    Hey bro. Great tut but i have one question. My Sublime Text 3 doesn't have all those cool php features. Like my text isnt even colored and it doesnt find those auto complete commands. Did you install any plugin or something? thanks!

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

    mehn these your videos are so cool... thanks alot i have really improved alot on my php skills cause i was using phpmanual.net... but could'nt understand it well, now i can cause of your tutorials .. thanks man

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

    Wow this was complicated but this is the first time i had fun ! Like i was really coding . Need to practice hard ig...

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

    Man! I just love you! It worked well!

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

    Which "theme" and "Color Scheme" did you use in your Sublime text? Please tell me. I like the UI.

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

    your just fantastic men

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

    SHORT AND FABULOUS VIDEO :)

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

    Even tho I included the file in which I defined $conn it still says $conn is undefined. Can anyone help?

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

      I'm having the same problem, did you figure it out?

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

      @@DaniTimmermans Yes! If ur using PhpStorm go to:
      File -> Settings -> Editor -> Inspections -> PHP -> Undefined -> Undefined variable
      and turn on "Search for variable's definition outside the current file"

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

      @@DirkieDurky Thaaaaank you so much! I would have never find that!❤️

  • @ASouza-ut9kb
    @ASouza-ut9kb 6 лет назад

    Show! Very good and easy explanation!

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

    Finally got it. MySQL thought it didn’t exist.

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

    Well explained bro!

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

    So I've got a question, what makes the associative array saved in $row fetch the next row in the database after the first iterartion?
    I would think that $row would still be the same array and just echo out the same username over and over again so that we would be stuck in a endless loop, however this is now how it behaves..
    How come? What makes it fetch to the next row after the first iteration?

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

      PHP makes it easy to get data from your results and loop over it using a while statement. When it fails to get the next row, it returns false, and your loop ends.