Connect to MySQL with PHP in XAMPP / Create a new database

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

[@PrasanthS-f2o]

now it's useful for me in 2024

[@GabbeSama]

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

[@maxmoore8480]

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

[@rahulsyt_]

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

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

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

[@imtiazxkhan]

7 years and still this video is lit!!!

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

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

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

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

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

[@uday0532]

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

[@TheAhernFamily1]

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

[@KenSwartwout]

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

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

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

[@tareqmahmud3902]

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

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

[@ankitabhishek5575]

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

[@HustlerEli]

Amazing and well explained tutorial.

[@venkateshprasad6432]

short and simple tutorials ,thanks dude

[@arbudastudio5864]

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

[@laoadventuretour5012]

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

[@iconsworld9]

Found this extremely useful, appreciate it

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

[@bhaveshbhoye6942]

Thanks bro Love from India

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

[@GlennGasner]

Thank you for this!

[@elvisadjei2062]

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

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

[@arpandas411]

Excellent video! Works Perfectly for me!

[@420blazeurmomacrossmaptoma5]

Arpan Das you don't work perfectly.

[@Dominarfans]

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

[@demiRedRush]

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

[@abdurrazzak1612]

thanks that was my first connection on php

[@tahadaboussi7831]

almost 9 years old , but still great tutorial

[@colinhastings9215]

You are my hero! Thank you for this video!

[@aerotechplustwo6914]

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

[@agborie]

Great tutorial! Easy and fast.

[@PeteMac84]

Great! Finally got it.

[@proo5577]

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

[@tahirabbas2811]

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

[@tekoreypy]

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

[@Lazar94SRB]

Finally code that works!

[@sistematico17]

Well explained and concise. Thanks so much!

[@Herculean61]

Do you have a video on an event locator database..just like this one

[@jeremiahrighteous7499]

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

[@papaOhmTV]

Very helpful video! Thank you so much!

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

[@procoder1745]

very nice sir you are great

[@bluffer8352]

Great explanation, cheers.

[@sagarsole999]

Thanks It Really Helpful for me.

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

[@Xarbrough]

Thank you, this is perfect for getting started!

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

[@tonthekid7946]

Good job, Thank you for your tutorial.

[@pockeybearmilk264]

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

[@kennethkath6527]

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.

[@procoder1745]

this video is mind blowing

[@edwinmukhalisi5015]

Awesome Helped me Big Time

[@aniruddhasolanki9480]

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

[@gunner9456]

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

[@swolyjr]

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.

[@goatskills2382]

+Ken Swartwout What should I do when I don't have a hosting (yet)?

[@KenSwartwout]

+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.

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

[@radeepyenni5541]

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

[@chrisniell3915]

It can be access with different computers or guest ? Who connected to your hub.

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

[@apoozkan8361]

Hi, i did the same thing but it just shows my code when i run it ? how can i fix this

[@Ackerman_cher]

thanks man that was helpful!😍

[@user-en5vj6vr2u]

how do you access the db now bc i barely know sql

[@danahgarwan9585]

This is helpful, Thank you!

[@shahsulaiman851]

ulearn

[@marcaboujaoude5874]

sorry but when i'm running your code is giving that "sqli" was not found can you help me out on this one ?

[@ismailabdow3844]

Thank you so much u help mi a lot best video

[@kartikangira]

thanks for the help working like a charm

[@johnsdaniel8394]

thank you..was really helpful

[@larryshamala8929]

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?

[@reynpimentel6819]

i have a problem in starting the MySQL and i dont know wht to do

[@unorthodoxjourney]

ken thanks for the video but i am getting access denied error and the message i have printed

[@theossettoracle]

Thanks for that, very helpful!

[@meet2football]

helpful for me....thanks dude..

[@amrityamsrivastava7598]

nicely explained. thanks ..

[@BarkhaLomor]

very helpful. simple and great!

[@aghartaatlantean4517]

how can i create database on my computer only when i don't have phpmyadmin account set up already?

[@vyuutuube]

it does not kick me to phpmyadmin HTTP Error 404. The requested resource is not found. what can i do?

[@abdulrashid7148]

Awesome work !!!

[@sltiktok6952]

Still worthy 🙏❤️

[@coolkid5146]

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

[@narsicreation7977]

I got this 'Parse error: syntax error, unexpected 'new' (T_NEW) in C:\xampp\htdocs', solution please ?

[@ravichandra1830]

thank u for your help this video helped me a lot

[@kalytheo]

Great work! Thank you!

[@ccc6495]

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

[@doc-holiday]

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?

[@coolsmarty5137]

I am unable to connect my database. it gives me error your php server doesn't have mysql module loaded or you cant use the mysql_(p) connect fuctions..can u suggest why?

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?

[@AdamMcquiff]

Great tutorial.

[@certifiedprogrammer4598]

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?