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

[@rahulsyt_]

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

[@GabbeSama]

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

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

[@maxmoore8480]

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

[@ismailabdow3844]

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

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

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

[@imtiazxkhan]

7 years and still this video is lit!!!

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

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

[@tahsinhimu3609]

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

[@itstobystic]

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

[@uday0532]

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

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

[@TheAhernFamily1]

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

[@KenSwartwout]

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

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

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

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

[@CrimeWithEli]

Amazing and well explained tutorial.

[@ankitabhishek5575]

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

[@tareqmahmud3902]

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

[@laoadventuretour5012]

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

[@karvin9]

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

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

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

[@proo5577]

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

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

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

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

[@elvisadjei2062]

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

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

[@arbudastudio5864]

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

[@julianturkson7464]

This is what it says when I try to run mysql Status change detected: stopped 16:06:10 [mysql] Error: MySQL shutdown unexpectedly. 16:06:10 [mysql] This may be due to a blocked port, missing dependencies, 16:06:10 [mysql] improper privileges, a crash, or a shutdown by another method. 16:06:10 [mysql] Press the Logs button to view error logs and check 16:06:10 [mysql] the Windows Event Viewer for more clues 16:06:10 [mysql] If you need more help, copy and post this 16:06:10 [mysql] entire log window on the forums

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

[@venkateshprasad6432]

short and simple tutorials ,thanks dude

[@Dominarfans]

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

[@chrisniell3915]

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

[@iconsworld9]

Found this extremely useful, appreciate it

[@colinhastings9215]

You are my hero! Thank you for this video!

[@Herculean61]

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

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

[@lajota-7]

Hi +Ken Swartwout , great tuturial. I just don't know where should i save the php file, i'm newbie on this stuff. Thanks

[@David0072007]

+Rafael Marques, if you have installed xampp on tu pc, save ty php file in x:\xampp\htdocs

[@lajota-7]

+Jesus Santisteban thanks, alteady did that:)

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

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

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

[@arpandas411]

Excellent video! Works Perfectly for me!

[@420blazeurmomacrossmaptoma5]

Arpan Das you don't work perfectly.

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

[@theunknownhue]

If i change my port for phpmyadmin,do i have to specify in the code too? or 'localhost' is all i need to write?

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

[@lakemartin4959]

move to fast... if you don't tell us and we can't see mouse motion we can't follow... I'm going to go here at 1:26 does not tell me anything or where you're going. But I did find it after going back twenty times.

[@tahadaboussi7831]

almost 9 years old , but still great tutorial

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

[@tahirabbas2811]

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

[@marcaboujaoude5874]

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

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?

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

[@GlennGasner]

Thank you for this!

[@lajota-7]

Hi Ken, great tuturial. I just don't know where should i save the php file, i'm newbie on this stuff. Thanks

[@devchawda9414]

+Rafael Marques C drive->xampp->htdoc there u should make ur project folder and then just save it there...... Enjoy!!!

[@lajota-7]

+Dev Chawda thank you !

[@devchawda9414]

+Rafael Marques But u should install Xampp 1st :)

[@lajota-7]

+Dev Chawda i know that

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

[@bhaveshbhoye6942]

Thanks bro Love from India

[@jupitersmoon_europa_]

honestly i still dont understand how to create a file.sql ? like you write the script on an editor saved with an .sql i guess, but how do u connect it with ur php file that got the data ?

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

[@michairynizarichlellyn9721]

" 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]

Make sure you have mysql running

[@theoschnell2272]

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.

[@aerotechplustwo6914]

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

[@vishnukv4186]

i got one error Fatal error: Class 'mysql' not found in C:\XAMPP\htdocs\test\connect.php on line 9 on the line $db = new mysql('localhost', $user, $pass, $db) or die("unable to connect") ;

[@dc37wwe2kmods]

try changing "mysql" to "mysqli"

[@emadalyousefi7784]

change mysql to mysqli

[@ayodelearibisala468]

hey how do you get that notepad youre using.. i think my netbeans is making it more difficult for me

[@KenSwartwout]

+jerry walker Notepad++. It is free and very popular. Give it a try!

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

[@WOODSYMAN]

I'm confused. You have two variables called $db. Why doesn't that cause an issue?

[@xploit6589]

It just replaces the old variable as it runs from my guess..

[@kenswartwout1246]

I meant to call it $dbc, but as said below it works by overwriting the variable.

[@loomer107]

Andrew Woods I checked the comments specifically for this question. I highly recommend putting a small correction text banner on the video for good habit formation of novice viewers

[@froglicker9267]

it is good for new SQL code to reference the old as a template

[@demiRedRush]

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

[@vamsikrishnakikkuri2140]

will "mysql_connect(host,user,password)" work. if yes please tell me how. i am having a problem when i have used it.

[@yogendralakraj3214]

i keep getting this error do you kbow whats going on: Fatal error: Uncaught Error: Class 'mysqli' not found in C:\Users\Andy Lakraj\phpproject\index.php:9 Stack trace: #0 {main} thrown in C:\Users\Andy Lakraj\phpproject\index.php on line 9

[@Xarbrough]

Thank you, this is perfect for getting started!

[@vjeraturk]

[@darshanparab8480]

+Vjera Turk thanx working

[@shaikasha6882]

if u give a name to db then it will show error so give as empty( $db='';) at ur third line

[@fotarbas]

shouldnt we disconnect from the db ?

[@lovekas7422]

works good thanks

[@saitarun6562]

where in 3rd line?

[@KerleyVinas]

Excellent tutorial it saved me lots of time and aggravation...Quick question do you know how to make this work with a copy of an existing wordpress site? I tried and I got "Error establishing a database connection" Please help Thanks

[@KenSwartwout]

Kerley Vinas You certainly can make it work. The issue is likely that you need to copy the database over to your installation of XAMPP. You probably only have a copy of the html/css/scripts - the DB is a separate entity. It is easy enough to import/export through phpMyAdmin.

[@jeremiahrighteous7499]

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

[@narsicreation7977]

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

[@muhammadsaadmansoor7777]

3:43 you said 'die' in strangely beautiful way

[@abhisheksuratkar]

How else to say it

[@tekoreypy]

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

[@vyuutuube]

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

[@gopeswarnamasudra8895]

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

[@AISHUPONNE]

what coding you using for connect.php

[@user-en5vj6vr2u]

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

[@aghartaatlantean4517]

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

[@papaOhmTV]

Very helpful video! Thank you so much!

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

[@Lazar94SRB]

Finally code that works!

[@thecrashofneo]

Why i can give you only 1 like? ....TOP

[@apoozkan8361]

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

[@ronaldvonk]

I don't really understund why you use the $db variable twice?

[@sistematico17]

Well explained and concise. Thanks so much!

[@sagarsole999]

Thanks It Really Helpful for me.

[@purpleprincess4126]

Sir, will this also work on wamp server?

[@vavr8231]

But one question, why would you have a password if you dont use it? I mean in the code....

[@sticky13337]

Still i woudlnt name the $db variable the same as the connector, it causes unwanted confusion.

[@preciouschimwenye480]

My point exactly....but great tutorial

[@MadOliveGaming]

i was stuck on this for so long just to hear you say the password was just a blanc space xD

[@tonthekid7946]

Good job, Thank you for your tutorial.

[@pockeybearmilk264]

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