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

Поделиться
HTML-код
  • Опубликовано: 3 дек 2024

Комментарии • 381

  • @kenson_kw
    @kenson_kw 2 года назад +96

    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!

  • @GabbeSama
    @GabbeSama 6 месяцев назад +1

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

  • @maxmoore8480
    @maxmoore8480 8 лет назад +6

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

  • @TheOriginalDarkGlitch
    @TheOriginalDarkGlitch 4 года назад +1

    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.

  • @rahulsyt_
    @rahulsyt_ Год назад +2

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

  • @ismailabdow3844
    @ismailabdow3844 4 года назад

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

  • @itstobystic
    @itstobystic 4 года назад +1

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

  • @robynbazsika239
    @robynbazsika239 9 лет назад +6

    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 лет назад +3

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

    • @420blazeurmomacrossmaptoma5
      @420blazeurmomacrossmaptoma5 9 лет назад +3

      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 лет назад +1

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

    • @420blazeurmomacrossmaptoma5
      @420blazeurmomacrossmaptoma5 9 лет назад +1

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

    • @420blazeurmomacrossmaptoma5
      @420blazeurmomacrossmaptoma5 9 лет назад

      420blazeurmom acrossmaptomahawk .

  • @davidsmith-ws4bz
    @davidsmith-ws4bz 4 года назад

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

  • @Tommeke11
    @Tommeke11 10 лет назад +4

    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!

  • @99plus89
    @99plus89 8 лет назад

    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.

  • @Mayur_
    @Mayur_ 10 лет назад +15

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

  • @haritastbg
    @haritastbg 10 лет назад +6

    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  10 лет назад

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

    • @shahsulaiman851
      @shahsulaiman851 5 лет назад

      ulearn

  • @imtiazxkhan
    @imtiazxkhan 4 года назад

    7 years and still this video is lit!!!

  • @tahsinhimu3609
    @tahsinhimu3609 2 года назад

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

  • @uday0532
    @uday0532 Год назад +1

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

  • @stevodoe4900
    @stevodoe4900 5 лет назад +2

    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.

  • @tareqmahmud3902
    @tareqmahmud3902 2 года назад

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

  • @PanduricaBlues
    @PanduricaBlues 6 лет назад +4

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

  • @karvin9
    @karvin9 9 лет назад

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

  • @CrimeWithEli
    @CrimeWithEli 2 года назад +1

    Amazing and well explained tutorial.

  • @ankitabhishek5575
    @ankitabhishek5575 6 лет назад

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

  • @soudabuhanak7141
    @soudabuhanak7141 4 года назад

    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

  • @venkateshprasad6432
    @venkateshprasad6432 6 лет назад

    short and simple tutorials ,thanks dude

  • @TheAhernFamily1
    @TheAhernFamily1 9 лет назад +19

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

    • @KenSwartwout
      @KenSwartwout  9 лет назад +1

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

  • @iconsworld9
    @iconsworld9 2 года назад

    Found this extremely useful, appreciate it

  • @ethanlee2197
    @ethanlee2197 10 лет назад +3

    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!

  • @arbudastudio5864
    @arbudastudio5864 2 года назад +1

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

  • @Dominarfans
    @Dominarfans 6 лет назад

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

  • @demiRedRush
    @demiRedRush 2 года назад

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

  • @DaleGomes
    @DaleGomes 10 лет назад +1

    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

  • @arpandas411
    @arpandas411 9 лет назад +2

    Excellent video! Works Perfectly for me!

  • @laoadventuretour5012
    @laoadventuretour5012 2 года назад

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

  • @colinhastings9215
    @colinhastings9215 8 лет назад +1

    You are my hero! Thank you for this video!

  • @papaOhmTV
    @papaOhmTV 8 лет назад

    Very helpful video! Thank you so much!

  • @aerotechplustwo6914
    @aerotechplustwo6914 8 лет назад

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

  • @BrofaBloke
    @BrofaBloke 10 лет назад +9

    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 6 лет назад

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

  • @elvisadjei2062
    @elvisadjei2062 9 лет назад

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

  • @proo5577
    @proo5577 7 лет назад

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

  • @agborie
    @agborie 3 года назад

    Great tutorial! Easy and fast.

  • @sistematico17
    @sistematico17 6 лет назад

    Well explained and concise. Thanks so much!

  • @jeremiahrighteous7499
    @jeremiahrighteous7499 7 лет назад

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

  • @bhaveshbhoye6942
    @bhaveshbhoye6942 4 года назад

    Thanks bro
    Love from India

  • @Xarbrough
    @Xarbrough 9 лет назад +1

    Thank you, this is perfect for getting started!

  • @tekoreypy
    @tekoreypy 5 лет назад

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

  • @GlennGasner
    @GlennGasner 2 года назад +1

    Thank you for this!

  • @chethanabhaskara480
    @chethanabhaskara480 9 лет назад +1

    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?

  • @abdurrazzak1612
    @abdurrazzak1612 8 лет назад

    thanks that was my first connection on php

  • @tahirabbas2811
    @tahirabbas2811 6 лет назад

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

  • @tonthekid7946
    @tonthekid7946 8 лет назад +1

    Good job, Thank you for your tutorial.

  • @sagarsole999
    @sagarsole999 4 года назад

    Thanks It Really Helpful for me.

  • @lakemartin4959
    @lakemartin4959 7 лет назад

    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
    @lewioesports 7 лет назад +1

    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?

  • @bluffer8352
    @bluffer8352 7 лет назад

    Great explanation, cheers.

  • @aniruddhasolanki9480
    @aniruddhasolanki9480 2 года назад

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

  • @BarkhaLomor
    @BarkhaLomor 8 лет назад

    very helpful. simple and great!

  • @aashimamadaan2
    @aashimamadaan2 7 лет назад

    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

  • @pockeybearmilk264
    @pockeybearmilk264 7 лет назад

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

  • @theossettoracle
    @theossettoracle 10 лет назад +1

    Thanks for that, very helpful!

  • @chrisniell3915
    @chrisniell3915 6 лет назад

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

  • @tahadaboussi7831
    @tahadaboussi7831 2 года назад

    almost 9 years old , but still great tutorial

  • @kartikangira
    @kartikangira 8 лет назад

    thanks for the help working like a charm

  • @johnsdaniel8394
    @johnsdaniel8394 3 года назад

    thank you..was really helpful

  • @Lazar94SRB
    @Lazar94SRB 7 лет назад +1

    Finally code that works!

  • @PeteMac84
    @PeteMac84 7 лет назад

    Great! Finally got it.

  • @gunner9456
    @gunner9456 10 лет назад +2

    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

  • @Ackerman_cher
    @Ackerman_cher Год назад

    thanks man that was helpful!😍

  • @swolyjr
    @swolyjr 7 лет назад

    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.

  • @danahgarwan9585
    @danahgarwan9585 10 лет назад +1

    This is helpful, Thank you!

  • @MikesTrackBuilding
    @MikesTrackBuilding 9 лет назад +1

    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

  • @coolkid5146
    @coolkid5146 7 лет назад

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

  • @amrityamsrivastava7598
    @amrityamsrivastava7598 7 лет назад +1

    nicely explained.
    thanks ..

  • @meet2football
    @meet2football 7 лет назад

    helpful for me....thanks dude..

  • @mohamedsuhailirfankhazi6628
    @mohamedsuhailirfankhazi6628 6 лет назад

    thank you friend! very well explained! :D

  • @ccc6495
    @ccc6495 6 лет назад +1

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

  • @shahaburrahman1474
    @shahaburrahman1474 7 лет назад

    thank u so much...it really works

  • @vyuutuube
    @vyuutuube 9 лет назад

    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

  • @gtuouts794
    @gtuouts794 9 лет назад +1

    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?

  • @kennethkath6527
    @kennethkath6527 2 года назад

    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.

  • @theunknownhue
    @theunknownhue 7 лет назад

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

  • @ravichandra1830
    @ravichandra1830 6 лет назад

    thank u for your help this video helped me a lot

  • @doc-holiday
    @doc-holiday 8 лет назад

    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?

  • @edwinmukhalisi5015
    @edwinmukhalisi5015 8 лет назад

    Awesome Helped me Big Time

  • @IshaqKhan010
    @IshaqKhan010 10 лет назад

    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 ?

  • @ismailabdow3844
    @ismailabdow3844 4 года назад

    Thank you so much u help mi a lot best video

  • @coolsmarty5137
    @coolsmarty5137 8 лет назад

    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?

  • @marcaboujaoude5874
    @marcaboujaoude5874 9 лет назад

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

  • @bernardnasinyama6871
    @bernardnasinyama6871 7 лет назад

    thank you, you just inspired me to go on

  • @Herculean61
    @Herculean61 2 года назад

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

  • @procoder1745
    @procoder1745 7 лет назад

    very nice sir you are great

  • @sajidhussain-kk6fu
    @sajidhussain-kk6fu Год назад

    Nice ❤❤❤

  • @goatskills2382
    @goatskills2382 8 лет назад

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

    • @KenSwartwout
      @KenSwartwout  8 лет назад +3

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

  • @procoder1745
    @procoder1745 7 лет назад

    this video is mind blowing

  • @larryshamala8929
    @larryshamala8929 2 года назад

    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?

  • @user-en5vj6vr2u
    @user-en5vj6vr2u 6 лет назад

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

  • @jupitersmoon_europa_
    @jupitersmoon_europa_ 4 года назад

    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 ?

  • @jeffmatthews3312
    @jeffmatthews3312 10 лет назад +2

    very helpful, thank you!

  • @vamsikrishnakikkuri2140
    @vamsikrishnakikkuri2140 6 лет назад

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

  • @AISHUPONNE
    @AISHUPONNE 5 лет назад

    what coding you using for connect.php

  • @vyuutuube
    @vyuutuube 9 лет назад

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