20 | Connect to a Database From a Website Using PHP | 2023 | Learn PHP Full Course for Beginners

แชร์
ฝัง
  • เผยแพร่เมื่อ 27 ก.ย. 2024
  • In this PHP tutorial I will teach you how to connect to a database using PDO, from a website using PHP! 🙂 Connecting to a database is necessary in order to query a database, so learning how to connect to it, is the first step to selecting and inserting data, directly from a website.
    ➤ GET ACCESS TO MY LESSON MATERIAL HERE!
    First of all, thank you for all the support you have given me!
    I am really glad to have such an awesome community on my channel. It motivates me to continue creating and uploading content! So thank you!
    I am now using Patreon and TH-cam Memberships to share improved and updated lesson material, and for a small fee you can access all the material either from my memberships or Patreon, depending on your preference. I have worked hard, and done my best to help you understand what I teach.
    I hope you will find it helpful :)
    Memberships: / @dani_krossing
    Patreon: / mmtuts

ความคิดเห็น • 76

  • @fangyiru8602
    @fangyiru8602 ปีที่แล้ว +15

    thank you so much for doing this, you are so good at explaining things and honestly you are giving out so many practical scenarios that happens ALL THE TIME!! I learn so much from your videos and I will watch a lot of times to fully understand all. thank you Dani!!

  • @kasunkumarasinghe6365
    @kasunkumarasinghe6365 ปีที่แล้ว +19

    There are so many videos on the internet. But you are the one who does it correctly.

  • @rodgence9641
    @rodgence9641 ปีที่แล้ว +4

    I reaĺly like your tutorials its clean and straight forward, i started waching your tutorials 2yrs ago, pls make us upgrade to laravel even if it will be a paid course, i will appreciate that Dan.
    Africa is watching

  • @sebeek00
    @sebeek00 11 หลายเดือนก่อน +36

    Man, first of all.. thank you for tutorials like this! But.. are you somehow related to Elon Musk?😂😂

    • @anasmazhar7942
      @anasmazhar7942 5 หลายเดือนก่อน +2

      More like Me Beast 😅

    • @anasmazhar7942
      @anasmazhar7942 5 หลายเดือนก่อน +3

      More like Mr Beast 😅

    • @siig9905
      @siig9905 3 หลายเดือนก่อน +1

      This was my first thought 😂

  • @AViStudioMoldova
    @AViStudioMoldova ปีที่แล้ว +7

    You're my mentor last 2 years! Right now i started to rebuild my old project in OOP mode, your lessons are right on time. Thanks!!!!

  • @KAREKINFPV
    @KAREKINFPV 11 หลายเดือนก่อน +2

    I really like the flow of your videos, it's slow and methodical with plenty of explanation.

  • @igorstrzezysz9992
    @igorstrzezysz9992 11 หลายเดือนก่อน +1

    Man/bro thank you so mutch, I am working at this moment at PHP project on my University in Poland and I didn't know why my app doesn't work,ed as app, know is working thank you so mucth :)

  • @sampulcodemine
    @sampulcodemine ปีที่แล้ว +4

    You are doing a great job Dani. Nice contents and nice way to break concepts into simpler ideas.

  • @zeppelin1qaz
    @zeppelin1qaz 7 หลายเดือนก่อน +2

    Excellent. Very clear explanation. Thenk you.

  • @LiteralHatReloaded
    @LiteralHatReloaded 4 หลายเดือนก่อน +3

    LEGEND! THANK YOU!

  • @akashgola2153
    @akashgola2153 6 หลายเดือนก่อน +2

    And Another informative session from Dani 😃.

  • @rayfushgo
    @rayfushgo 9 หลายเดือนก่อน +2

    You are the best! Thank you!! ❤

  • @shahdhossam2221
    @shahdhossam2221 9 หลายเดือนก่อน +2

    wow ! It was the most informative videos I 've ever seen 😍😍

  • @samaugustinejunior5679
    @samaugustinejunior5679 4 หลายเดือนก่อน

    I have no errors now 😌 massive tutorials

  • @montexart-og5hp
    @montexart-og5hp ปีที่แล้ว

    you are doing a great job .plz never stop cz u helped mi a lot

  • @sonamohialdin3376
    @sonamohialdin3376 ปีที่แล้ว +1

    Very useful tutorial thank you

  • @moraaoo4889
    @moraaoo4889 11 หลายเดือนก่อน +2

    funny and simple, thank you bro 👌❤‍🔥

  • @hundesabwarkebaye
    @hundesabwarkebaye 4 หลายเดือนก่อน +1

    Great👍❗

  • @МирайМустафов
    @МирайМустафов 3 หลายเดือนก่อน

    appreciations my friend

  • @aaronargottelopez3488
    @aaronargottelopez3488 2 หลายเดือนก่อน

    Thanks!

  • @dave0
    @dave0 ปีที่แล้ว

    Thank you so much!!!!

  • @osemekejoshua5287
    @osemekejoshua5287 25 วันที่ผ่านมา

    Firstly thank you for this video but you didn’t do enough justice to the object classes as well as instantiate

  • @teddyYo-wf5oe
    @teddyYo-wf5oe 6 หลายเดือนก่อน +6

    I have seen all of 65 episodes of PHP I love it

  • @solaraproject3614
    @solaraproject3614 ปีที่แล้ว

    I was like "Elon went back to coding?" You lowkey look like Elon Musk in some angles.
    Anyways. Thank you for this tutorial, youre a legend!

  • @angelmsigidi7806
    @angelmsigidi7806 ปีที่แล้ว

    Thanks

  • @ilovemusicchannel9191
    @ilovemusicchannel9191 6 หลายเดือนก่อน

    thanks, i spent lots of time to find the answer and it is here “Mac need to put root for the password” thanks again

  • @guitarplayer1434
    @guitarplayer1434 ปีที่แล้ว

    what database would I use to house videos ?

  • @zilingchen7004
    @zilingchen7004 11 หลายเดือนก่อน

    hi, i have face problem to show the input data in database can you help me to solve?

  • @DenisRozon
    @DenisRozon ปีที่แล้ว

    I am able to connect on my computer localhost to the dbase, but it does not seem to read the php code when I put it online to the public server , My php form is inside my index.php file What can be be the reason?

  • @simoncastano_
    @simoncastano_ ปีที่แล้ว +1

    How can I connect with other database? for example
    NoSQL databases mongodb, Postgres, firebase or something like that

    • @Boborjan1986
      @Boborjan1986 ปีที่แล้ว +1

      At least postgresql would be a good addition to mention. Only mentioning two and one of them is rather a "wrapper" for others isnt sufficient. In my opinion.

  • @MrAgentbozo
    @MrAgentbozo 4 หลายเดือนก่อน

    Love all the videos, however finding that for this one I'm getting this error "connection failed:sqlstate[hy000] [2002] no such file or directory". Works fine when running the php locally but not on replit.

    • @MrAgentbozo
      @MrAgentbozo 4 หลายเดือนก่อน

      Any suggestions?

    • @incredibleman2719
      @incredibleman2719 21 วันที่ผ่านมา

      @@MrAgentbozo delete environment

  • @tyraelzumwraek937
    @tyraelzumwraek937 6 หลายเดือนก่อน +2

    This is PHP Musk 😂

  • @SalmanulFaris-zv6qy
    @SalmanulFaris-zv6qy 3 หลายเดือนก่อน

    do in mysqli also please

  • @Izkawi33
    @Izkawi33 ปีที่แล้ว

    Thank you brother can you make an oop project then anther laravel course

  • @Noah-xn5th
    @Noah-xn5th หลายเดือนก่อน

    why not use an actual server instead of xxamp?

  • @edmfestival1253
    @edmfestival1253 8 หลายเดือนก่อน

    Hello Dani - I am getting "Access Denied for user 'root'@localhost (using password:NO)" error. Not sure what am I missing. Can you please help me?

  • @Bikesandbmxgaming
    @Bikesandbmxgaming ปีที่แล้ว

    What happened if wanted login page on same page as sig up could teacher me

  • @hanLi-mx6oy
    @hanLi-mx6oy 3 หลายเดือนก่อน

    I am want to be your student for get web developer in HTML and PHP and mysql , how much do need to spend per month ? i have bachelor dree of computer science, But i don't have a good skill in IT

    • @incredibleman2719
      @incredibleman2719 21 วันที่ผ่านมา

      You can pay me, feel free to contact me. I will make you a professional developer in just three days.

  • @waldoglas3412
    @waldoglas3412 ปีที่แล้ว

    if you say in my last video please link it
    please

  • @omamowhophanuel6755
    @omamowhophanuel6755 3 หลายเดือนก่อน

    It feels like Elin Musk is teaching me PHP 🤯

  • @Epic_stickman90
    @Epic_stickman90 7 หลายเดือนก่อน

    I mean most times when there was an error it was just me, Not a single thing missed!

  • @kennieKE
    @kennieKE 4 หลายเดือนก่อน

    what if you are using html files

    • @Dani_Krossing
      @Dani_Krossing  4 หลายเดือนก่อน

      You convert them to PHP files, by simply changing the extensions

  • @ixL8d
    @ixL8d หลายเดือนก่อน

    R+

  • @jediampm
    @jediampm ปีที่แล้ว

    HI, thanks for the video, however teaching or connect to DB with PDO without teaching the basic of OOP make no sense, sorry.

  • @Po0pypoopy
    @Po0pypoopy 6 หลายเดือนก่อน

    WARNING to everyone!!.....he fails to mention anything about having to DOWNLOAD and install PDO...it was such a headache not knowing why my scripts weren't working as I copied exactly what he was doing but read up that PDO needs to be installed and actually "activated" within your php.ini file whenever you download php
    this is super confusing stuff as a beginner.....and not sure if he mentions any of this in other videos, but figured this comment would save others from a headache.

    • @Dani_Krossing
      @Dani_Krossing  6 หลายเดือนก่อน +1

      PDO isn’t deactivated by default. I’m not sure why yours was, but it’s not something people will need to activate first. 🤷‍♂️ Maybe you are using another server application than XAMPP?

    • @Po0pypoopy
      @Po0pypoopy 6 หลายเดือนก่อน +2

      @@Dani_Krossing I got php from the php website itself after following the w3schools link provided and noticed that non of my PDOs have an .dll ending after installing php. Also noticed that I don’t have a simple php.ini file but two : one php.ini.development(?) and the other with something else.
      I guess I will reinstall using xampp

  • @davescorneroftheworld1147
    @davescorneroftheworld1147 ปีที่แล้ว +5

    As always this video was jam packed with information. It will take some time to decipher all of it. THANK YOU!

  • @roninleo5679
    @roninleo5679 ปีที่แล้ว +4

    Dani i love your content man i have learned a lot from you , can you start teaching laravel a little i want to upgrade to laravel framework and it will be so nice if you started an episode for teaching laravel

  • @satishg6965
    @satishg6965 ปีที่แล้ว +4

    this course is worth for $200, but im watching it for free, Thank you Dani!

  • @triumphadeniran7335
    @triumphadeniran7335 6 หลายเดือนก่อน +2

    Thank you so much this was really helpful

  • @katerinaproncheva2579
    @katerinaproncheva2579 6 หลายเดือนก่อน +2

    Very helpful and explanatory 👏🏻

  • @4n7h4r4x
    @4n7h4r4x 8 หลายเดือนก่อน +1

    bro ngl you look like elone musk , good video ❤

  • @evansjosh7333
    @evansjosh7333 3 หลายเดือนก่อน

    dude is Elon Musk your brother? I saw in one video admit it that he is your relative

  • @simplyb1178
    @simplyb1178 9 วันที่ผ่านมา

    my holy savior

  • @WillemsWimMH
    @WillemsWimMH 6 หลายเดือนก่อน

    Some question has been on my mind since a while as I am creating some system to record orders during a weekend of the sportsclub (not sure how you call it in English but with the sportsclub we have a 2-day event where we serve food). Anyway, I connect to the database as you do here. And also for the login form for the users (the people taking the orders) I do more or less the same as you do later in this course.
    Now I wonder, do you ever connect to the database with the specific user? Now we always connect with the root user and in fact we only check if the user logging in exists and uses the right password. But we never really connect to the database with that specific user, do we? Or do I misunderstand something?
    Thanks for giving this you view if and when you have some time.

  • @AA-fo4nd
    @AA-fo4nd 8 หลายเดือนก่อน

    I have question please answer me , if I use PDO extension Instead of mysqli , and use (mySQL) in mysqlworkbenck will it work?

  • @kaelthunderhoof5619
    @kaelthunderhoof5619 6 หลายเดือนก่อน

    I'm trying to make a salon reservation webpage, do I need an Index.html or should I only use php?

  • @berrykingdomiceberry6905
    @berrykingdomiceberry6905 ปีที่แล้ว

    wonderful.
    please sir, how can I merge two or more database together, so they can fetch info from one database. example email, account, password etc.

  • @peaklegacy146
    @peaklegacy146 ปีที่แล้ว

    Announcement! In Episode 21, we are shown how to change the username and password.

  • @Boylagak
    @Boylagak ปีที่แล้ว +3

    My favorite TH-cam channel. ❣️

  • @nemocedillo6185
    @nemocedillo6185 7 หลายเดือนก่อน

    6:33 (Bookmark)

  • @andreitestmail
    @andreitestmail 11 หลายเดือนก่อน

    nice script and 0 test if it works. video ended like DUNE movie.

    • @Dani_Krossing
      @Dani_Krossing  11 หลายเดือนก่อน +3

      You are so impatient 😅 The next few videos goes over how we can use the database connection