16 | Create a Database in MySQL PHP Tutorial | 2023 | Learn PHP Full Course for Beginners
Вставка
- Опубліковано 8 тра 2023
- In this PHP tutorial I will talk about how to create a MySQL database, to use together with our PHP code! 🙂 Creating a database for our website is a very exciting point on our lessons, since it will allow us to create some extremely cool features using PHP in our 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 UA-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
Did Elon Musk and Mr Beast have a baby?
lmao
I literally came here for this comment Lmaooooo😂. Glad i am not the only one😅
My 12 yo niece said are you watching Mrbeast...
Be nice buddy
Thank you so much for taking the time to record yourself in the tutorials. It's extremely helpful for your followers to be able to stay focused and avoid distractions. Your efforts are greatly appreciated!
I find myself obliged every time watching one of your videos to thank you again and again !!!
Thank you so much Dani i really enjoy your lessons and have learnt alot..... God bless you
Video is very helpful, thank you for sharing with us.
I've always felt the PHPMyAdmin screen for creating a table needs to hide 90% of the options when filling in the column options. Just needs hiding behind an 'Advanced' shortcut...then a 'More Advanced' shortcut for the database breaking options you shouldn't be touching!
The people who would need to use those options wouldn't use PHPMyAdmin anyway.
Exactly how I feel.
I'd like just to say Thank you so much.
Thank you very much, I like your videos 👍
thanks for this awesome lesson
Great content
Thank you Sir. From Nigeria!!!
The other side of the PHP - sql. Let's go yay
I can't credit you enough for touching on issues like, error messages and others things that people wonder. Another great example was when looping though BOTH index array and associated arrays
very nice tutorial sir .
Hey Dani, When they go to make an Elon Musk movie, I recommend you do a casting. :)
Recently said this on another video.. cousins.
By pure coincidence, I watched the datetime part on the 14th of the month at exactly 11:30. What are the odds of that.
Does this content will be expanded to server database or it is just for localhost db? Because I do not understand how to handle routes and databases on server, I mean how to move project from Loalhost play ground to real live server :)
But thank you for this lesson. Fresh info is always useful :)
Whenever you buy hosting from a hosting company from your website, their dashboard should give you access to a database for your server. 🙂 In most cases the server will be a MySQL server, like the one in our localhost.
There is really no difference in setting it up. Just open PhpMyAdmin from the dashboard when you log into your hosting company site.
will you be covering using a Guid for the id vs using a int ast the id of a table
No I will be using a INT as the id in these lessons. For a beginner course it is best not to overcomplicate things, so using INT is better for beginners than trying to explain globally unique identifiers. 🙂
After checking the run as administrator, access is still denied. Can you help?
Please 🙏 sir, can you code a forum script, thanks for your efforts and understanding
Right-joins are the best joins 😂
PHPMyAdmin can use a little 2023 overhaul and have dark mode.
I would prefer it to have it as it is than to have it broken with better UI
hey should i start learning from the beginning or its okey if i follow up from here bcs i need just database
If you know the basics of PHP, then you can just follow from here on out. :) After this section, where I show the basics of databases, I will show how to interact with the database using PHP.
@@Dani_Krossing ty sooo much for ur help
It was interesting to create the database with php, not from phpmyadmin
hey just wondering what sofwere do you use for ur code
VSCode
@@Dani_Krossing thx
Please make a video on how to connect backend to frontend please
That is the plan once we have learned about SQL 🙂
@@Dani_Krossing thank you sir, I enjoy all your tutorials thanks a lot
Hi are you Elon Musk? thank you i have subscribed
Thank you sir
how to get php job ?
Php developer roadmap ?
Can you make any video for it
Learn HTML and CSS, then PHP, then whatever framework is most popular atm, and focus on getting good at that particular framework, rather than "learning more". A CMS system like WordPress isn't a bad idea either. 🙂
@@Dani_Krossing Can I go to laravel after I finish your PHP course?
How to solve this error 😢
Fatal error: Uncaught mysqli_sql_exception: Access denied for user 'root'@'localhost' (using password: NO) in C:\xampp\htdocs\phpmedi\class9.php:15 Stack trace: #0 C:\xampp\htdocs\phpmedi\class9.php(15): mysqli_connect('localhost', 'root', Object(Sensitive Parameter Value)) #1 {main} thrown in C:\xampp\htdocs\phpmedi\class9.php on line 15
Elon musk!
can someone know video where they actually use real website and data base not on they own pc pleaseeee ??
Your hosting provider should have a MySQL database available for your website, which you can access by logging into your dashboard on their website. 🙂 They also have the information you need, to connect to the database, inside your PHP code. Such as username, password, and server address.
If you can’t find that information, or your MySQL database on their website, then you need to contact them about where to find it.
And from there on out, it’s the same process as I show in my videos, since everything will be exactly the same. 👍
@@Dani_Krossing thank you 🙏 I actually watched another of your videos and it answered my question, great work brother.
😍😍😍😍😍😍😍😍😍🥰🥰🥰🥰😍😍🥰🥰🥰🥰🥰🥰🥰😍😍😍🥰🥰😍😍
1:30 What? Everything is more complicated by a database and most websites would be better off without one. Wouldn't it be better to let inexperienced users drop text files or images into a directory?
good tutorial but gah damn bro is a yap monster
I am sorry, are you virtual AI. you are blanding of Elon and Beast.
😂 Bib Blob 🤖 zzzzzzttt
To be fair, you CAN make it so that the person can go in and change those things. Or in your contract you have update/maintenance covered and either there is a fee or part of the initial cost or a monthly fee and you can still do it as well as continue to make money. There are some people that don't want to do their own updates and some that shouldn't.
10 years ago when I had my first client, I made the mistake of never agreeing on a "update period" where he could test the site for changes, or texts he wanted changed. It resulted in months of emails where he wanted changes made, which get incredibly awkward after a while... Especially considering it was my first real client, and I didn't know how to properly deal with that situation. 😅 After that I made sure to always agree on either a "update period", or by hooking up a CMS to the site, alongside a "CMS teaching period" for them to learn how it worked.
I personally never made a "maintenance contract" with anyone, in order not to bind myself to them, since I was doing freelance work short term. Anything after that they wanted changed, had to be paid, or they would have to hire another person to make the changes. 🙂
It all depends on the situation, and whether or not the developer plan to make short or long term commitment with their clients. But like you said there are of course situations where it is much more beneficial, to make a form of "maintenance contract", if you plan on being a long term freelance developer. Whether or not they "should or shouldn't touch the site content", is only relevant if the developer doesn't see those situations as "income opportunities". 🙂 But of course it is a good idea to keep clients informed about potential situations like that, otherwise you aren't keeping your clients nest interests in mind. 😊
@@Dani_Krossing Yeah totally depends on the customer and the job. With a customer that wants to be pretty hands on a prebuilt CMS(as much as I hate them lol) is way easier than making your own. That's the best part about this job is learning new ways to tackle the same problems. Love your vids btw, I enjoy watching them myself, occasionally picking up little tid-bits here and there but recommend them to people all the time that come to me for advice on how to get into programming. Seems like anymore, as soon as people know you program they want help or advice lol. Which I happily give but your vids are put together well and I generally point them in your direction! I like the calculator as good into project. My favorite I like to tell people is blackjack. It's a little bit more advanced and depending on how much you want to do extra(have the dealer actually play, other players, even the visual and animations) it can be a really good learning tool. cheers!