29: How to Create a MySQL Database for PHP | PHP Tutorial | Learn PHP Programming | PHP Lesson
HTML-код
- Опубликовано: 26 авг 2024
- How to create a MySQL database for PHP - Learn PHP backend programming. Today we will start learning about MYSQL databases. This is important since PHP is commonly used together with databases to make a website more interactive.
➤ 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 to share improved and updated lesson material, and for a small fee you can access all the material. I have worked hard, and done my best to help you understand what I teach.
I hope you will find it helpful :)
Material for this lesson: / lesson-material-42361704
Have an interview with a company needing a Backend PHP Developer. Your videos are helping re-enforce my knowledge! THANK YOU
Hi I'm 15 in a country where computer coding is rare for teenagers
If you said NIGERIA you are correct.
I always loved watching those movies where people create and execute stuff through coding .
I learnt html and css and was confused on what to do but since I started these series it has been awesome .
And his technique is wonderful
Even though this video is 5 years old I still wanted to say that these videos helped me a lot with PHP. Thank you
Thank you so much for this video. Keep up the good work.
I learned PHP coding and say 'actually' by watching your tutorials. Thanks!
You are my hero! I started the php series today and got to this class already. YOu just make it look easy!
very good tutorial ....I'm really satisfied with this,exactly what i needed to know. Are you using XAMPP for php??
yes.., he's using a XAMPP SERVER
yes.
Yeah. Xampp is the best for these tasks.
Can I use xampp in Mac?
@@ravik1884 Yes
I always question why you call forwardslash '/' as backslash '\' in your videoes. Not sure if it is your country or not. Like the carret '^' is not an up arrow. Being a PC users since 91' back then I did not know shift from ctrl. Everytime I hear you say backslash and then type forwardslash, it cracks me up! But I do enjoy watching your videoes and I will continue to watch them to absorb as much as I can. Thank you for bringing us such precision content! YOU ROCK DANI! Keep up the good work you provide here, we love them, keep em' coming!
Yes some years ago I kept saying backslash 🙂 it was a language thing since English isn’t my first language
@@Dani_Krossing No worries. We get it and accept it. Just do you thing bro!
Hi Danni
First off thanks a million for your great videos. You are a natural teacher! I have been finally able to understand php concepts that I never did before. Just ONE issue so far
I am on lesson 29 and I get a phpMyAdmin - Error
"The mysqli extension is missing. Please check your PHP configuration. See our documentation for more information."
I am using everything you taught (ie xampp etc)
I have searched the web for answers and they say I have to change some details in the php.ini file...but there isn't one...I have no php.ini file
I used the
to see if I could find where the file is but it just shows :
"Configuration file (php.ini) Path = no value
Loaded configuration file = none"
Please can you help?
Thank you your video really help me to learn PHP and MYSQL step by step.
Excellent video!!!
Last year I downloaded directly from Oracle a MySQL relational database and the setup seemed very different from the Phpmyadmin version of MySQL?
The version I downloaded from Oracle was so much different in comparison to the Php version? The oracle version you have to use SQL to create a database or even a table. The Php version I saw you in this video create it with a click of a button?
Do you know if your able to use the Oracle version which you download directly from the Oracle site could be used with PHP? Or are you only allowed to use the MAMP or XAMP version only?
Man your videos are great! Hope you keep it up!
You D Man, Man 💪
You are the besttttttttttttttttt!!!
Now i knew you are from Denmark LOL i was wondering whats your accent, respect to Denmark from Algeria
I have a question about getting to the myadmin page. It only works when I include localhost:8080. Without ':8080' it doesn't work and since I'm new to all this so I don't really know what any of it means. Do you know why 8080 is needed? Thank you for doing this series. It continues to be incredibly helpful!
8080 is a port in your computer, which means the phpmyadmin runs on your computer port that is 8080, and the reason why you need it is because your pc is set to use that port when trying to run phpmyadmin,hope it helps
I am only learning how to write, but I don't know how to implement it or practice php anywhere, what should I do to practice it ?
watch this series.
Hey Daniel,
thanks for your tutorials, they are very instructive. Which hosting company you recommend I used.
Thank you for the tutorial,
i'm new to web development, is it possible to select and display a .db or a .csv file into a table in a website using php? please help
nice tutorial series!!!! loved it
Well explained
Love this tutorial
Direct and straightforward :)
I am happy to find this channel
More videos to watch now for me
Great tutorials!
great course, i'm at lesson 30 now, and i noticed that lesson 44 is private. How can i access it?
i love u
i really don't know what to do without u 💔
Can I create an image upload site in php.
danish brother 💪💪💪
Is there some way that I could access and edit the SQL database directly from my website? For admins only?
I have a signup script and the sqli code in it doesn't work. When I plug the exact same code into phpmyadmin though, it works. Can you tell me what the problem is
hi, your video very helpful
I need to ask how to create a database for files, what is the datatype?
You are the best
Great effort i appreciate it man thanks & / is forward slash
why don't you provide links to the things you use bro? That would be really helpful
I do at the start of this series ;) If you jump in mid way you might miss things like that hehe
@@Dani_Krossing You're right, that's exactly what happened lol.. but can in this series will we capture user given data and post it to the database we created?
Yes :)
@@Dani_Krossing You are fucking awesome mate
Hey, my phpMyAdmin page doesn't have the create database like yours does.
thank you.
Can I use xampp server in MacBook?
For all those who might have problem in login to phpMyAdmin, just type 'root' for username and keep password field blank and press 'Go'.
Error
SQL query: Edit
SET lc_messages = 'en_US';
MySQL said:
#1193 - Unknown system variable 'lc_messages'
cant solve this error when i open localhost/phpmyadmin
I am getting an error 200 when i click on creat database
It shows me the processing request and nothing works after that
Plz anyone tell me how can i fix it
great tutorial, can you please explain how to open no localhost server? I mean a real hostserver and what to write into the connection to php?
what hoster are you using? im using 2freehosting and in it you need to go to:
1. cPanel
2. mySQL databases
3. register one
4. go back
5. go to phpMyAdmin
6. click on the one you've registered
7. click on "enter phpMyAdmin"
8. type in the password and done
And for the code:
database name is: Mysql Database (something like a123456789_login)
username is: Mysql User (something like a123456789_admin)
And the password is what you've typed in before.
@@CredixNetwork this comment is gold i wish i could save it on youtube. a screenshot will do
When I try and run MySQL on Apache
04:27:39 م [mysql] Error: MySQL shutdown unexpectedly.
04:27:39 م [mysql] This may be due to a blocked port, missing dependencies,
04:27:39 م [mysql] improper privileges, a crash, or a shutdown by another method.
04:27:39 م [mysql] Press the Logs button to view error logs and check
04:27:39 م [mysql] the Windows Event Viewer for more clues
04:27:39 م [mysql] If you need more help, copy and post this
04:27:39 م [mysql] entire log window on the forums
Keep on getting this error
Knocker SSeries me to
change the pannel
my database is not saving in htdocs... how do I get it to save there.
please help
We have entered the big guns
TKS
can u create a video for how to use the php source code
I do a few videos ahead of these phpMyAdmin videos
MySQL is free right.pls reply
Yes
Interclassement must be collation today! For the db creation part, isn'It?
\ = backslash
/ = divide
\ = backslash
/ = slash
\ = Backslash
/ = Forwardslash
comment send php
Im stuck on loading when i open phpmyadmin
chrismass te7et 7essmass
How much can a single advertisement pay? Apology for a wrong and direct question. But what are the reasons a video gets an advertisement? If you don't want to reply, you can ignore it as well. I just don't mean to freak you out. But as always I am curious.