Displaying Content from a MySQL Database in a Webpage

This is a video walk through of loading content from a MySQL database into an HTML webpage. This video includes locating phpMyAdmin, creating a MySQL database and username, connecting to MySQL using PHP, executing a query, and displaying the results in HTML.

---

[dailydose]

Never stop posting, this channel got so much potential I really appreciate the help

[lavendercode]

WOW!!! Exactly what I needed. Thank you for this walk through, Adam! Your efforts are appreciated.

[johnbryan]

Thank you for helping me get mine going. Pretag is something I guessI've ignored for years! Great video!

[dragonjarl]

Very useful and well presented teaching. The pacing is just right and slowly spoken 🙂
I think the music detracts from the tech content though, us geeks are here to listen to what you say, not hear music ;-)

[PixieSpright]

Extremely helpful, and I love your teaching style. Hope your channels sees exponential growth!

[onipaba]

Thank you senior! Very useful information

[LakWat]

Literally exactly what I needed. TYSM!!!

[kidmyn]

Thanks for this great tutorial, much appreciated. I just have two questions.

1. If you already have a MySQL table with the same values that you created in PHP, would you just import that into PHP instead?

2. If you wanted to display your values in tables, as you would see when entering your data in PHPMyAdmin, would it be CSS or HTML that would get it to be formatted as a table?

[krystalmorris]

Hey Adam! Do I need to save the PHP file somewhere special? I've never used Visual Code before, I'm just using Notepad. I did everything just like you did but it doesn't seem to be making a connection to the local host like at 13:07. So I was wondering if maybe you saved the file at a specific place or something to get it to connect.

[EDC.EveryDayCode]

Can u zoom in your code quite a bit? it's too small to read easily. Also wondering would u use mysqli() these days or PDO? I don't know PDO that well and mysqli seems to do the job but I'm worried about security...

[alejandroarango]

Is it possible to input formulas in myPHPAdmin?

[gappuma]

for me it starts downloading the php page instead of showing it, also i'm missing a "my wbesite" in MAMP localhost

[timbordasch]

12:50 I am using a different provider > how do you open your webpage? I also tried the Localhost link, but it didnt work

[WhiteOwl]

If I misstype root it doesn't even give me an error.

[gcgc]

So the username and pw is just in the sourcecode? Isnt this unsafe or something?

[diggee]

I wish you had used the entire screen to demonstrate things. I don’t have one of those huge monitors so I can’t read what you displayed. Also it wold be better to see what you are writing then your face in the corner of screen. imho