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.

[@kenson_kw]

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!

[@maxmoore8480]

This tutorial was not only exactly what I needed but well explained, clear, and slow but concise, thanks a lot!

[@Mayur_]

Thank you! :) I was trying to connect html form to my database, wasn't working. But it's perfect now. Simple and correct video.

[@stevodoe4900]

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.

[@99plus89]

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.

[@TheOriginalDarkGlitch]

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.

[@Tommeke11]

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]

Getting started can be intimidating. Very happy to help!

[@ismailabdow3844]

Now connected after 10hrs of struggling with other videos .. Very helpful

[@itstobystic]

This guy's voice is cool, he made the video sound like a movie trailer. Thank you

[@haritastbg]

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]

Great to hear. Getting started with a test bed like XAMPP is a large barrier to overcome!

[@shahsulaiman851]

ulearn

[@PanduricaBlues]

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

[@robynbazsika239]

Thanks so much. I am just teaching MySQL and PHP to my High School Students. This is a great video and very informative.

[@KenSwartwout]

Great to hear. Getting started is one of the more difficult parts of the process.

[@420blazeurmomacrossmaptoma5]

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]

Robyn Bazsika 22 Middleton Rd, Kew, Dunedin 9012 got u bitch

[@420blazeurmomacrossmaptoma5]

420blazeurmom acrossmaptomahawk im coming to teach ur students a real lesson \ for once

[@420blazeurmomacrossmaptoma5]

420blazeurmom acrossmaptomahawk .

[@davidsmith-ws4bz]

For learning right click the XAMPP ICON and select" Run as Administrator", otherwise its easy to end up locked out. Thanks for the vid.

[@tahsinhimu3609]

finalllyyyy after trying for 3 days your way got this connected!

[@karvin9]

Thank you Ken, I found this video a lot more helpful than other videos I found online

[@demiRedRush]

amazing tutorial, clear,concise and exactly the tutorial i needed.

[@imtiazxkhan]

7 years and still this video is lit!!!

[@tareqmahmud3902]

this is the cleanest tutorial ever! thank you, god bless you!

[@TheAhernFamily1]

This is really easy to follow thanks for the great tutorial.

[@KenSwartwout]

+Aheezy Da Islander You are welcome and thanks for the feedback.

[@Xarbrough]

Thank you, this is perfect for getting started!

[@ethanlee2197]

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]

When you are not sure exactly what you should be doing it can be a nightmare!

[@venkateshprasad6432]

short and simple tutorials ,thanks dude

[@aashimamadaan2]

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

[@soudabuhanak7141]

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

[@arbudastudio5864]

This is really easy to follow thanks for the great tutorial. ☺

[@colinhastings9215]

You are my hero! Thank you for this video!

[@iconsworld9]

Found this extremely useful, appreciate it

[@uday0532]

Information never dies this is exactly what I need and it is from 9 years ago 😄😄😄

[@tekoreypy]

great tutorial, the best one for sure, clear and simple

[@ankitabhishek5575]

thanks a lot.was misguided by other videos.saw yours and it worked.

[@elvisadjei2062]

Good work done. uv really helped me in my assignment. Thumps Up......

[@sistematico17]

Well explained and concise. Thanks so much!

[@rahulsyt_]

10 years later I am watching these videos. Real G(Old) videos.

[@Dominarfans]

thanks for the support , that really worked , GREAT WORK !!!!

[@agborie]

Great tutorial! Easy and fast.

[@HustlerEli]

Amazing and well explained tutorial.

[@arpandas411]

Excellent video! Works Perfectly for me!

[@420blazeurmomacrossmaptoma5]

Arpan Das you don't work perfectly.

[@MikesTrackBuilding]

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

[@DaleGomes]

Thanks Ken. Worked just the way you said it!

[@KenSwartwout]

That is always good to hear. There are many places that the process can go the wrong direction

[@laoadventuretour5012]

Very good Video which easy to understand and thank you for sharing

[@aerotechplustwo6914]

thank you for clarifying that for me.. this is very much greatly appreciated sir.

[@DylanEscobar]

helped me with my pokemon go server! thnx!

[@ccc6495]

Thank you so much, echo"Great work!!!"

[@coolkid5146]

Thank you so much. My code actually works. You earned a sub and a like.

[@tonthekid7946]

Good job, Thank you for your tutorial.

[@theossettoracle]

Thanks for that, very helpful!

[@papaOhmTV]

Very helpful video! Thank you so much!

[@Lazar94SRB]

Finally code that works!

[@jeremiahrighteous7499]

God bless! it works and you save me alot of works. thanks

[@ramasamy6098]

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

[@tahirabbas2811]

You're love man and of course KZbin is love. Thanks

[@jannvega8475]

Ahh ,, Thank you. This video's really help me a lot. :)

[@jeffmatthews3312]

very helpful, thank you!

[@lakemartin4959]

I got it, so i'm giving you a thumbs up and because you don't move super fast and speak very plainly i.m going to subscribe...:-)

[@BarkhaLomor]

very helpful. simple and great!

[@vyuutuube]

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

[@mohamedsuhailirfankhazi6628]

thank you friend! very well explained! :D

[@bluffer8352]

Great explanation, cheers.

[@PeteMac84]

Great! Finally got it.

[@bhaveshbhoye6942]

Thanks bro Love from India

[@Mohammed_cherkaoui_wushu]

thanks man that was helpful!😍

[@pockeybearmilk264]

thank you so much now I understand how it works , thank you again

[@kartikangira]

thanks for the help working like a charm

[@abdurrazzak1612]

thanks that was my first connection on php

[@aemonwarrick4654]

Sir, You are a god send thank you so much.

[@abdulrashid7148]

Awesome work !!!

[@aniruddhasolanki9480]

thank you so much!! that was super easy.....

[@kalytheo]

Great work! Thank you!

[@sagarsole999]

Thanks It Really Helpful for me.

[@elieri00]

Thank you, great video.

[@bernardnasinyama6871]

thank you, you just inspired me to go on

[@amrityamsrivastava7598]

nicely explained. thanks ..

[@shozab2012]

nice work ken

[@dennist.8018]

yup, works fine, good tut, thnx!

[@edwinmukhalisi5015]

Awesome Helped me Big Time

[@GlennGasner]

Thank you for this!

[@gtuouts794]

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?

[@himanshujoshi4435]

grate video it's gain my knowledge..... thanks/////

[@alexcharlton2316]

Very useful, Thanks!

[@meet2football]

helpful for me....thanks dude..

[@danahgarwan9585]

This is helpful, Thank you!

[@shahsulaiman851]

ulearn

[@procoder1745]

very nice sir you are great

[@ismailabdow3844]

Thank you so much u help mi a lot best video

[@johnsdaniel8394]

thank you..was really helpful

[@shahaburrahman1474]

thank u so much...it really works

[@ravichandra1830]

thank u for your help this video helped me a lot

[@105bobbo]

Oh my goodness, thanks bro !!

[@proo5577]

Just used this works great. Any updated info I should look into?

[@omkarpimpude4967]

thank you very much :) ...!!!

[@simonabotanicalhome]

Thanks, very useful!

[@BrofaBloke]

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]

assigned to a function mysqli with new prefix. i think both variable works differently even after having same name

[@IshaqKhan010]

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 ?

[@swimsoundwave]

DUDE! Thank you!

[@sememamos880]

Really helpful. thank you

[@denisram8619]

good man! cool video

[@audreyderrick4972]

thank you, answered my question

[@chethanabhaskara480]

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?

[@AdamMcquiff]

Great tutorial.

[@lewioesports]

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?

[@alvinaaslam5343]

great video thank u soo much