20 | Connect to a Database From a Website Using PHP | 2023 | Learn PHP Full Course for Beginners
Vložit
- čas přidán 4. 06. 2023
- 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 CZcams 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
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!!
As always this video was jam packed with information. It will take some time to decipher all of it. THANK YOU!
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 :)
Man, first of all.. thank you for tutorials like this! But.. are you somehow related to Elon Musk?😂😂
More like Me Beast 😅
More like Mr Beast 😅
This was my first thought 😂
You are doing a great job Dani. Nice contents and nice way to break concepts into simpler ideas.
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!!!!
I have seen all of 65 episodes of PHP I love it
I really like the flow of your videos, it's slow and methodical with plenty of explanation.
There are so many videos on the internet. But you are the one who does it correctly.
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
you are doing a great job .plz never stop cz u helped mi a lot
You are the best! Thank you!! ❤
Excellent. Very clear explanation. Thenk you.
this course is worth for $200, but im watching it for free, Thank you Dani!
LEGEND! THANK YOU!
Thank you so much!!!!
Very useful tutorial thank you
wow ! It was the most informative videos I 've ever seen 😍😍
I have no errors now 😌 massive tutorials
And Another informative session from Dani 😃.
funny and simple, thank you bro 👌❤🔥
Very helpful and explanatory 👏🏻
Thank you so much this was really helpful
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
I like his tutorials too. I hope he will start teaching Laravel soon.
Great👍❗
My favorite CZcams channel. ❣️
Thanks
bro ngl you look like elone musk , good video ❤
Tx for thise❤
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.
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.
I'm trying to make a salon reservation webpage, do I need an Index.html or should I only use php?
Thank you brother can you make an oop project then anther laravel course
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!
I have question please answer me , if I use PDO extension Instead of mysqli , and use (mySQL) in mysqlworkbenck will it work?
thanks, i spent lots of time to find the answer and it is here “Mac need to put root for the password” thanks again
what database would I use to house videos ?
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?
This is PHP Musk 😂
do in mysqli also please
hi, i have face problem to show the input data in database can you help me to solve?
What happened if wanted login page on same page as sig up could teacher me
It feels like Elin Musk is teaching me PHP 🤯
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
How can I connect with other database? for example
NoSQL databases mongodb, Postgres, firebase or something like that
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.
Announcement! In Episode 21, we are shown how to change the username and password.
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?
if you say in my last video please link it
please
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.
Any suggestions?
I mean most times when there was an error it was just me, Not a single thing missed!
6:33 (Bookmark)
what if you are using html files
You convert them to PHP files, by simply changing the extensions
nice script and 0 test if it works. video ended like DUNE movie.
You are so impatient 😅 The next few videos goes over how we can use the database connection
dude is Elon Musk your brother? I saw in one video admit it that he is your relative
HI, thanks for the video, however teaching or connect to DB with PDO without teaching the basic of OOP make no sense, sorry.
you cannot be taught everything
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.
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?
@@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