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

  • @kenson_kw
    @kenson_kw2 жыл бұрын

    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
    @maxmoore84808 жыл бұрын

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

  • @Mayur_
    @Mayur_10 жыл бұрын

    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
    @99plus898 жыл бұрын

    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.

  • @stevodoe4900
    @stevodoe49004 жыл бұрын

    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
    @Tommeke1110 жыл бұрын

    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

    @KenSwartwout

    10 жыл бұрын

    Getting started can be intimidating. Very happy to help!

  • @TheOriginalDarkGlitch
    @TheOriginalDarkGlitch4 жыл бұрын

    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.

  • @haritastbg
    @haritastbg9 жыл бұрын

    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

    @KenSwartwout

    9 жыл бұрын

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

  • @shahsulaiman851

    @shahsulaiman851

    4 жыл бұрын

    ulearn

  • @TheAhernFamily1
    @TheAhernFamily18 жыл бұрын

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

  • @KenSwartwout

    @KenSwartwout

    8 жыл бұрын

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

  • @Xarbrough
    @Xarbrough8 жыл бұрын

    Thank you, this is perfect for getting started!

  • @PanduricaBlues
    @PanduricaBlues6 жыл бұрын

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

  • @itstobystic
    @itstobystic4 жыл бұрын

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

  • @demiRedRush
    @demiRedRush2 жыл бұрын

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

  • @karvin9
    @karvin99 жыл бұрын

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

  • @robynbazsika239
    @robynbazsika2399 жыл бұрын

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

  • @KenSwartwout

    @KenSwartwout

    9 жыл бұрын

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

  • @420blazeurmomacrossmaptoma5

    @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

    @420blazeurmomacrossmaptoma5

    9 жыл бұрын

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

  • @420blazeurmomacrossmaptoma5

    @420blazeurmomacrossmaptoma5

    9 жыл бұрын

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

  • @420blazeurmomacrossmaptoma5

    @420blazeurmomacrossmaptoma5

    9 жыл бұрын

    420blazeurmom acrossmaptomahawk .

  • @ismailabdow3844
    @ismailabdow38443 жыл бұрын

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

  • @sistematico17
    @sistematico176 жыл бұрын

    Well explained and concise. Thanks so much!

  • @MikesTrackBuilding
    @MikesTrackBuilding9 жыл бұрын

    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

  • @colinhastings9215
    @colinhastings92158 жыл бұрын

    You are my hero! Thank you for this video!

  • @tekoreypy
    @tekoreypy5 жыл бұрын

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

  • @ethanlee2197
    @ethanlee219710 жыл бұрын

    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

    @KenSwartwout

    10 жыл бұрын

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

  • @aashimamadaan2
    @aashimamadaan27 жыл бұрын

    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

  • @lewioesports
    @lewioesports7 жыл бұрын

    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?

  • @jannvega8475
    @jannvega84759 жыл бұрын

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

  • @ccc6495
    @ccc64956 жыл бұрын

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

  • @IshaqKhan010
    @IshaqKhan0109 жыл бұрын

    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
    @arpandas4119 жыл бұрын

    Excellent video! Works Perfectly for me!

  • @420blazeurmomacrossmaptoma5

    @420blazeurmomacrossmaptoma5

    9 жыл бұрын

    Arpan Das you don't work perfectly.

  • @DylanEscobar
    @DylanEscobar8 жыл бұрын

    helped me with my pokemon go server! thnx!

  • @arbudastudio5864
    @arbudastudio58642 жыл бұрын

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

  • @tareqmahmud3902
    @tareqmahmud39022 жыл бұрын

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

  • @DaleGomes
    @DaleGomes10 жыл бұрын

    Thanks Ken. Worked just the way you said it!

  • @KenSwartwout

    @KenSwartwout

    10 жыл бұрын

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

  • @GabbeSama
    @GabbeSamaАй бұрын

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

  • @tahsinhimu3609
    @tahsinhimu3609 Жыл бұрын

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

  • @theossettoracle
    @theossettoracle9 жыл бұрын

    Thanks for that, very helpful!

  • @venkateshprasad6432
    @venkateshprasad64326 жыл бұрын

    short and simple tutorials ,thanks dude

  • @chethanabhaskara480
    @chethanabhaskara4809 жыл бұрын

    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?

  • @gunner9456
    @gunner945610 жыл бұрын

    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

  • @Dominarfans
    @Dominarfans5 жыл бұрын

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

  • @iconsworld9
    @iconsworld92 жыл бұрын

    Found this extremely useful, appreciate it

  • @imtiazxkhan
    @imtiazxkhan3 жыл бұрын

    7 years and still this video is lit!!!

  • @agborie
    @agborie2 жыл бұрын

    Great tutorial! Easy and fast.

  • @tonthekid7946
    @tonthekid79468 жыл бұрын

    Good job, Thank you for your tutorial.

  • @proo5577
    @proo55777 жыл бұрын

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

  • @aerotechplustwo6914
    @aerotechplustwo69148 жыл бұрын

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

  • @theunknownhue
    @theunknownhue7 жыл бұрын

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

  • @coolkid5146
    @coolkid51467 жыл бұрын

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

  • @jeffmatthews3312
    @jeffmatthews331210 жыл бұрын

    very helpful, thank you!

  • @papaOhmTV
    @papaOhmTV7 жыл бұрын

    Very helpful video! Thank you so much!

  • @ramasamy6098
    @ramasamy609810 жыл бұрын

    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

  • @mohamedsuhailirfankhazi6628
    @mohamedsuhailirfankhazi66286 жыл бұрын

    thank you friend! very well explained! :D

  • @uday0532
    @uday0532 Жыл бұрын

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

  • @goatskills2382
    @goatskills23828 жыл бұрын

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

  • @KenSwartwout

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

  • @soudabuhanak7141
    @soudabuhanak71414 жыл бұрын

    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

  • @swolyjr
    @swolyjr7 жыл бұрын

    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.

  • @BrofaBloke
    @BrofaBloke9 жыл бұрын

    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

    @knlkumar

    5 жыл бұрын

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

  • @BarkhaLomor
    @BarkhaLomor8 жыл бұрын

    very helpful. simple and great!

  • @davidsmith-ws4bz
    @davidsmith-ws4bz4 жыл бұрын

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

  • @michairynizarichlellyn9721
    @michairynizarichlellyn97218 жыл бұрын

    " 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

    @krank3869

    5 жыл бұрын

    Make sure you have mysql running

  • @theoschnell2272

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

  • @ankitabhishek5575
    @ankitabhishek55756 жыл бұрын

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

  • @elvisadjei2062
    @elvisadjei20629 жыл бұрын

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

  • @doc-holiday
    @doc-holiday8 жыл бұрын

    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?

  • @larryshamala8929
    @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?

  • @chrisniell3915
    @chrisniell39156 жыл бұрын

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

  • @babuhussain8215
    @babuhussain82158 жыл бұрын

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

  • @Lazar94SRB
    @Lazar94SRB7 жыл бұрын

    Finally code that works!

  • @apoozkan8361
    @apoozkan83616 жыл бұрын

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

  • @unorthodoxjourney
    @unorthodoxjourney10 жыл бұрын

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

  • @aemonwarrick4654
    @aemonwarrick46548 жыл бұрын

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

  • @radeepyenni5541
    @radeepyenni55415 жыл бұрын

    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

  • @gtuouts794
    @gtuouts7948 жыл бұрын

    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?

  • @aghartaatlantean4517
    @aghartaatlantean45175 жыл бұрын

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

  • @user-en5vj6vr2u
    @user-en5vj6vr2u5 жыл бұрын

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

  • @jeremiahrighteous7499
    @jeremiahrighteous74996 жыл бұрын

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

  • @subhashtitkare348
    @subhashtitkare3485 жыл бұрын

    hi sir I want to change MariaDB to Mysql on xampp. plz tell me.

  • @kennethkath6527
    @kennethkath65272 жыл бұрын

    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.

  • @rahulsyt_
    @rahulsyt_ Жыл бұрын

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

  • @vyuutuube
    @vyuutuube9 жыл бұрын

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

  • @tahirabbas2811
    @tahirabbas28116 жыл бұрын

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

  • @narsicreation7977
    @narsicreation79779 жыл бұрын

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

  • 10 жыл бұрын

    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?

  • @vamsikrishnakikkuri2140
    @vamsikrishnakikkuri21406 жыл бұрын

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

  • @kalytheo
    @kalytheo4 жыл бұрын

    Great work! Thank you!

  • @vyuutuube
    @vyuutuube9 жыл бұрын

    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

  • @marcaboujaoude5874
    @marcaboujaoude58749 жыл бұрын

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

  • @HustlerEli
    @HustlerEli Жыл бұрын

    Amazing and well explained tutorial.

  • @harshitpradhan2728
    @harshitpradhan27284 жыл бұрын

    How to do same task using different users ie other than root user It's giving error.What to do?

  • @elieri00
    @elieri007 жыл бұрын

    Thank you, great video.

  • @Mwaniki888
    @Mwaniki8882 жыл бұрын

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

  • @bernardnasinyama6871
    @bernardnasinyama68716 жыл бұрын

    thank you, you just inspired me to go on

  • @pockeybearmilk264
    @pockeybearmilk2646 жыл бұрын

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

  • @AISHUPONNE
    @AISHUPONNE4 жыл бұрын

    what coding you using for connect.php

  • @gopeswarnamasudra8895
    @gopeswarnamasudra88957 жыл бұрын

    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

  • @certifiedprogrammer4598
    @certifiedprogrammer45986 жыл бұрын

    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?

  • @bluffer8352
    @bluffer83526 жыл бұрын

    Great explanation, cheers.

  • @dennist.8018
    @dennist.80189 жыл бұрын

    yup, works fine, good tut, thnx!

  • @davidmallar4608
    @davidmallar46086 жыл бұрын

    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?

  • @Mohammed_cherkaoui_wushu
    @Mohammed_cherkaoui_wushu Жыл бұрын

    thanks man that was helpful!😍

  • @reynpimentel6819
    @reynpimentel68199 жыл бұрын

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

  • @kartikangira
    @kartikangira8 жыл бұрын

    thanks for the help working like a charm

  • @purpleprincess4126
    @purpleprincess41266 жыл бұрын

    Sir, will this also work on wamp server?

Келесі