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

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 KZbin 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

[@fangyiru8602]

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]

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

[@AViStudioMoldova]

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

[@teddyYo-wf5oe]

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

[@davescorneroftheworld1147]

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

[@igorstrzezysz9992]

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 :)

[@KAREKINFPV]

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

[@sampulcodemine]

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

[@rodgence9641]

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

[@rayfushgo]

You are the best! Thank you!! ❤

[@satishg6965]

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

[@sebeek00]

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

[@anasmazhar7942]

More like Me Beast 😅

[@anasmazhar7942]

More like Mr Beast 😅

[@zeppelin1qaz]

Excellent. Very clear explanation. Thenk you.

[@Richterical]

LEGEND! THANK YOU!

[@hundesabwarkebaye]

Great👍❗

[@montexart-og5hp]

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

[@samaugustinejunior5679]

I have no errors now 😌 massive tutorials

[@katerinaproncheva2579]

Very helpful and explanatory 👏🏻

[@akashgola2153]

And Another informative session from Dani 😃.

[@shahdhossam2221]

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

[@triumphadeniran7335]

Thank you so much this was really helpful

[@sonamohialdin3376]

Very useful tutorial thank you

[@moraaoo4889]

funny and simple, thank you bro 👌❤‍🔥

[@dave0]

Thank you so much!!!!

[@Boylagak]

My favorite KZbin channel. ❣️

[@Siddhakumbhar12]

Tx for thise❤

[@tyraelzumwraek937]

This is PHP Musk 😂

[@4n7h4r4x]

bro ngl you look like elone musk , good video ❤

[@roninleo5679]

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

[@abdullahisuleimangwani6859]

I like his tutorials too. I hope he will start teaching Laravel soon.

[@WillemsWimMH]

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.

[@kaelthunderhoof5619]

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

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

[@angelmsigidi7806]

Thanks

[@AA-fo4nd]

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

[@ilovemusicchannel9191]

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

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

[@guitarplayer1434]

what database would I use to house videos ?

[@Izkawi33]

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

[@user-pd6kp1kj8n]

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?

[@peaklegacy146]

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

[@MrAgentbozo]

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]

Any suggestions?

[@zilingchen7004]

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

[@edmfestival1253]

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]

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

[@simoncastano_]

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

[@Boborjan1986]

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.

[@nemocedillo6185]

6:33 (Bookmark)

[@Epic_stickman90]

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

[@waldoglas3412]

if you say in my last video please link it please

[@motivationtv8563]

what if you are using html files

[@Dani_Krossing]

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

[@andreitestmail]

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

[@Dani_Krossing]

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

[@jediampm]

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

[@chikowamambo3786]

you cannot be taught everything

[@Po0pypoopy]

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]

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]

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