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.

[@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.

[@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.

[@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!

[@TheAhernFamily1]

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

[@KenSwartwout]

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

[@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

[@demiRedRush]

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

[@Xarbrough]

Thank you, this is perfect for getting started!

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

[@GabbeSama]

i'm a student and i'm here to say that your video still saves me, thanks a lot!

[@karvin9]

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

[@imtiazxkhan]

7 years and still this video is lit!!!

[@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 .

[@sistematico17]

Well explained and concise. Thanks so much!

[@venkateshprasad6432]

short and simple tutorials ,thanks dude

[@tareqmahmud3902]

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

[@tekoreypy]

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

[@tahsinhimu3609]

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

[@colinhastings9215]

You are my hero! Thank you for this video!

[@arpandas411]

Excellent video! Works Perfectly for me!

[@420blazeurmomacrossmaptoma5]

Arpan Das you don't work perfectly.

[@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!

[@ccc6495]

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

[@iconsworld9]

Found this extremely useful, appreciate it

[@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

[@arbudastudio5864]

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

[@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

[@agborie]

Great tutorial! Easy and fast.

[@DylanEscobar]

helped me with my pokemon go server! thnx!

[@Dominarfans]

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

[@tonthekid7946]

Good job, Thank you for your tutorial.

[@theossettoracle]

Thanks for that, very helpful!

[@jannvega8475]

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

[@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.

[@aerotechplustwo6914]

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

[@papaOhmTV]

Very helpful video! Thank you so much!

[@uday0532]

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

[@ankitabhishek5575]

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

[@BarkhaLomor]

very helpful. simple and great!

[@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

[@jeffmatthews3312]

very helpful, thank you!

[@elvisadjei2062]

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

[@rahulsyt_]

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

[@HustlerEli]

Amazing and well explained tutorial.

[@mohamedsuhailirfankhazi6628]

thank you friend! very well explained! :D

[@bhaveshbhoye6942]

Thanks bro
Love from India

[@aniruddhasolanki9480]

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

[@laoadventuretour5012]

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

[@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

[@sagarsole999]

Thanks It Really Helpful for me.

[@tahirabbas2811]

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

[@coolkid5146]

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

[@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

[@jeremiahrighteous7499]

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

[@aemonwarrick4654]

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

[@Lazar94SRB]

Finally code that works!

[@johnsdaniel8394]

thank you..was really helpful

[@pockeybearmilk264]

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

[@bernardnasinyama6871]

thank you, you just inspired me to go on

[@abdurrazzak1612]

thanks that was my first connection on php

[@bluffer8352]

Great explanation, cheers.

[@shahaburrahman1474]

thank u so much...it really works

[@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

[@kartikangira]

thanks for the help working like a charm

[@elieri00]

Thank you, great video.

[@himanshujoshi4435]

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

[@GlennGasner]

Thank you for this!

[@kalytheo]

Great work! Thank you!

[@Mohammed_cherkaoui_wushu]

thanks man that was helpful!😍

[@danahgarwan9585]

This is helpful, Thank you!

[@shahsulaiman851]

ulearn

[@amrityamsrivastava7598]

nicely explained.
thanks ..

[@ismailabdow3844]

Thank you so much u help mi a lot best video

[@audreyderrick4972]

thank you, answered my question

[@dennist.8018]

yup, works fine, good tut, thnx!

[@omkarpimpude4967]

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

[@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...:-)

[@meet2football]

helpful for me....thanks dude..

[@ravichandra1830]

thank u for your help this video helped me a lot

[@procoder1745]

very nice sir you are great

[@sememamos880]

Really helpful.
thank you

[@PeteMac84]

Great! Finally got it.

[@alexcharlton2316]

Very useful, Thanks!

[@abdulrashid7148]

Awesome work !!!

[@edwinmukhalisi5015]

Awesome Helped me Big Time

[@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

[@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?

[@105bobbo]

Oh my goodness, thanks bro !!

[@simonabotanicalhome]

Thanks, very useful!

[@procoder1745]

this video is mind blowing

[@thanhluanduong8616]

thanks you so much, helped a lot :))

[@dankocz1198]

zadával jsi tam heslo???

[@thanhluanduong8616]

Danko CZ xd

[@thanhluanduong8616]

ne

[@pavanimallivalli2081]

It is easy way tq you sir

[@alvinaaslam5343]

great video thank u soo much

[@NileshShinde4583]

Very nice video

[@shozab2012]

nice work ken

[@rupalichaudhari1714]

nice tutorial.

[@AdamMcquiff]

Great tutorial.