Connect to MySQL with PHP in XAMPP / Create a new database
Тәжірибелік нұсқаулар және стиль
This video will discuss how to create a database using PhpMyAdmin and connect to that database using PHP- mysqli. Syntax is discussed as well as some best practices. There a re many outdated tutorials which use mysql - these should not be used interchangeably.
Пікірлер: 383
I just realized, information never dies! This video is 8 years old and turns out this information is exactly what i needed and how i needed it in 2022 😮💨. Thank you dude!
This tutorial was not only exactly what I needed but well explained, clear, and slow but concise, thanks a lot!
Thank you! :) I was trying to connect html form to my database, wasn't working. But it's perfect now. Simple and correct video.
It was a day saver for me! I tried 5-7 another PHP ways connect to the database on latest versions XAMPP Unsuccessfully. This video obviously showed the right way. Thank You very much.
Very Helpful thank you! As someone who struggles with learning PHP I thought this was one the best videos I've seen in a while. If you haven't done so would you consider doing a beginner PHP / MySqL Tutorial Series for phpMyAdmin. Preferably focus on more the PHP aspect but general overview of the others would amazing also.
Thank you for this video! My course notes weren't complete for the starting part and connection. This video saved me from a lot of headaches. The start is definitely the most difficult part.
@KenSwartwout
10 жыл бұрын
Getting started can be intimidating. Very happy to help!
Thanks for making this video. I just started fooling around with MySQL and was following another tutorial that didn't explain this part at all.
Thank you Ken. I have just started learning php. This video is of great help to me to create my database and first php program.
@KenSwartwout
9 жыл бұрын
Great to hear. Getting started with a test bed like XAMPP is a large barrier to overcome!
@shahsulaiman851
4 жыл бұрын
ulearn
This is really easy to follow thanks for the great tutorial.
@KenSwartwout
8 жыл бұрын
+Aheezy Da Islander You are welcome and thanks for the feedback.
Thank you, this is perfect for getting started!
That´s the voice I want to have in my tutorials. Even if you´d be talking about how to eat pudding I would listen to you :)
This guy's voice is cool, he made the video sound like a movie trailer. Thank you
amazing tutorial, clear,concise and exactly the tutorial i needed.
Thank you Ken, I found this video a lot more helpful than other videos I found online
Thanks so much. I am just teaching MySQL and PHP to my High School Students. This is a great video and very informative.
@KenSwartwout
9 жыл бұрын
Great to hear. Getting started is one of the more difficult parts of the process.
@420blazeurmomacrossmaptoma5
9 жыл бұрын
Robyn Bazsika You're a teacher you swine, you should know this shit and not have to google it in order to understand it - i hate you and your students.
@420blazeurmomacrossmaptoma5
9 жыл бұрын
Robyn Bazsika 22 Middleton Rd, Kew, Dunedin 9012 got u bitch
@420blazeurmomacrossmaptoma5
9 жыл бұрын
420blazeurmom acrossmaptomahawk im coming to teach ur students a real lesson \ for once
@420blazeurmomacrossmaptoma5
9 жыл бұрын
420blazeurmom acrossmaptomahawk .
Now connected after 10hrs of struggling with other videos .. Very helpful
Well explained and concise. Thanks so much!
Thank you so very much for the little series. Are you by chance going to do some more videos showing how to create and query databases? Mike
You are my hero! Thank you for this video!
great tutorial, the best one for sure, clear and simple
Hi there, I wanted you to know how much I appreciate you video. Thank you very much. I've been having trouble connecting to database for like a whole day and then after watching this video, man its funny really. I put the password as root.
@KenSwartwout
10 жыл бұрын
When you are not sure exactly what you should be doing it can be a nightmare!
really ...thanks a lot !!!!!!!Your work is appreciable....it seemed so difficult but you made it easy :) I hope you will make more such videos all the best
I didt everything you did in the video, but when i open the connect.php (i have it in the right folder /htdocs) it loads infinitly. Does someone know why it is loading all time?
Ahh ,, Thank you. This video's really help me a lot. :)
Thank you so much, echo"Great work!!!"
thankss.. i question : we connect android to mysql database through localhost as we connect in java through mysql jdbc driver ? and the php script is neccessary to connect mysql database ?
Excellent video! Works Perfectly for me!
@420blazeurmomacrossmaptoma5
9 жыл бұрын
Arpan Das you don't work perfectly.
helped me with my pokemon go server! thnx!
This is really easy to follow thanks for the great tutorial. ☺
this is the cleanest tutorial ever! thank you, god bless you!
Thanks Ken. Worked just the way you said it!
@KenSwartwout
10 жыл бұрын
That is always good to hear. There are many places that the process can go the wrong direction
i'm a student and i'm here to say that your video still saves me, thanks a lot!
finalllyyyy after trying for 3 days your way got this connected!
Thanks for that, very helpful!
short and simple tutorials ,thanks dude
This video is great. However, after creating a database using phMyAdmin, if I open the mysql shell via xampp control panel and query "Show databases" , I'm only seeing the 'test' database and not the one I created. How I do I access it using the shell?
when i click on the admin button, it gives me error 404 not found message . please tell me how tosolve this problem, please someone help me
thanks for the support , that really worked , GREAT WORK !!!!
Found this extremely useful, appreciate it
7 years and still this video is lit!!!
Great tutorial! Easy and fast.
Good job, Thank you for your tutorial.
Just used this works great. Any updated info I should look into?
thank you for clarifying that for me.. this is very much greatly appreciated sir.
If i change my port for phpmyadmin,do i have to specify in the code too? or 'localhost' is all i need to write?
Thank you so much. My code actually works. You earned a sub and a like.
very helpful, thank you!
Very helpful video! Thank you so much!
wow very nice indeed great thank you verymuch sir. I was struggling past two days how to connect it helped me a lot.......... :) god may bless you
thank you friend! very well explained! :D
Information never dies this is exactly what I need and it is from 9 years ago 😄😄😄
+Ken Swartwout What should I do when I don't have a hosting (yet)?
@KenSwartwout
8 жыл бұрын
+GoatSkills If you don't have a host, then a tool like XAMPP is exactly what you need. XAMPP (or similar tools) turn your local machine into a host.
cool cool cook i watched a 100's of video regarding this, but all of that video no going success you are only the one who make it success 100% thank you so much voice tone amazing!!! i appreciate this video since 2013
which program are you using in notepad++ to 'RUN' the php code? i lick run and it asks me to choose a program to run it. i dont know which program to choose.
No comments pointing out he used the $db variable twice? (Once to store the dbname and again to create the connection). Either way good video as this bit of information is often overlooked in the classroom...
@knlkumar
5 жыл бұрын
assigned to a function mysqli with new prefix. i think both variable works differently even after having same name
very helpful. simple and great!
For learning right click the XAMPP ICON and select" Run as Administrator", otherwise its easy to end up locked out. Thanks for the vid.
" your php server doesn’t have the mysql module loaded or you can’t use mysql_(p)connect function." How do I fix this? Thanks
@krank3869
5 жыл бұрын
Make sure you have mysql running
@theoschnell2272
4 жыл бұрын
You can start mysql in the control window that you can see in 0:05 in this video. Next to mysql is a start button.
thanks a lot.was misguided by other videos.saw yours and it worked.
Good work done. uv really helped me in my assignment. Thumps Up......
I installed the xamp program on my own pc using Windows 10 and all seems fine and up and running but when i connect the mysql and follow your instruction its seems i am getting an error. I am not sure as to what is wrong here but something is telling me the directory folder for this script is incorrect. If i write basic php script all goes to plan using xamp but soemthing is telling me that the url of the data base is incorrect Any ideas?
hi thanks for your great work. i tried at once and it worked but then i dont know what happened. when i load the connect.php file on the browser it echos the html content. what is happenning?
It can be access with different computers or guest ? Who connected to your hub.
Warning: mysqli::mysqli(): (HY000/1049): Unknown database 'testdb' in C:\xampp\htdocs\connect.php on line 7 . im getting this error could u please guide..?
Finally code that works!
Hi, i did the same thing but it just shows my code when i run it ? how can i fix this
ken thanks for the video but i am getting access denied error and the message i have printed
Sir, You are a god send thank you so much.
when i want to connect to database of other than the root then it was not connected what can i do to connect to the datbase of user account
THANK YOUUUUU!!!!... I was so close to giving up... thanks for the detail too... Do you have a video on how to link a user's password to the phpMyAdmin database?
how can i create database on my computer only when i don't have phpmyadmin account set up already?
how do you access the db now bc i barely know sql
God bless! it works and you save me alot of works. thanks
hi sir I want to change MariaDB to Mysql on xampp. plz tell me.
I've made a website but I cant save the data in the database which was entered by the user(me) in the website. I'm wondering whats wrong.
10 years later I am watching these videos. Real G(Old) videos.
it does not kick me to phpmyadmin HTTP Error 404. The requested resource is not found. what can i do?
You're love man and of course KZread is love. Thanks
I got this 'Parse error: syntax error, unexpected 'new' (T_NEW) in C:\xampp\htdocs', solution please ?
I started with these: define('DB_NAME', 'test'); /** Username MySQL */ define('DB_USER', 'root'); /** Password to the database MySQL */ define('DB_PASSWORD', ''); /** The server name MySQL */ define('DB_HOST', 'localhost'); And I get this messange: Could not establish database connection. Please check the username, password and hostname in the config file, and if necessary set up the appropriate MySQL user and privileges. Any idea?
will "mysql_connect(host,user,password)" work. if yes please tell me how. i am having a problem when i have used it.
Great work! Thank you!
Got it, after i added the port number it worked... (80 was occupied so i changed it to 81) but then how to connect was: localhost:81/phpmyadmin the panel like in the video came available then. GREAT
sorry but when i'm running your code is giving that "sqli" was not found can you help me out on this one ?
Amazing and well explained tutorial.
How to do same task using different users ie other than root user It's giving error.What to do?
Thank you, great video.
Do you have a video on an event locator database..just like this one
thank you, you just inspired me to go on
thank you so much now I understand how it works , thank you again
what coding you using for connect.php
well i tried to connect to databse in xampp through brackets but it gives me error , while i verified that php code like echo" xxxx"; runs well, but could not connect with the database ,always get some error please help
iam using vmware so that i used port 8080 in mysql so localhost:8080/myweb/conn.php is not working how i can get-rid of this problem Ken Swartwout plz?
Great explanation, cheers.
yup, works fine, good tut, thnx!
Can someone help me, when I click on admin button, my web browser opens but it says This site can't be reached. What to do?
thanks man that was helpful!😍
i have a problem in starting the MySQL and i dont know wht to do
thanks for the help working like a charm
Sir, will this also work on wamp server?