37: How to show database data on a website using MySQLi | PHP tutorial | Learn PHP programming

How do you show database data on a website using PHP - PHP tutorial. Today we are going to learn how to get data from a database using PHP.

Regarding people asking why we are not using PDO:

In PHP there exists two methods of programming, which are
"Procedural programming (PP)" and "Object oriented programming (OOP)". In this PHP course we are using PP, and not OOP.

When using PP, it is possible to use MySQLi and Prepared statements. And when using OOP it is possible to use MySQLi, Prepared statements, and PDO. Therefore we cannot use PDO in these lessons here.

HOWEVER, in a few episodes I will show how to get and insert data into a database using prepared statements :)

➤ GET ACCESS TO MY LESSON MATERIAL HERE!

First of all, thank you for all the support you have given me!

I am really glad to have such an awesome community on my channel. It motivates me to continue creating and uploading content! So thank you!

I am now using Patreon to share improved and updated lesson material, and for a small fee you can access all the material. I have worked hard, and done my best to help you understand what I teach.

I hope you will find it helpful :)

[lawrencemichael]

in 11 minutes you managed to explain in a simple and clear way what others take 20-30 minutes.
You are amazing.

[crazyedude]

I have been staring at code and tutorials for hours now and this is the first tutorial that's actually helped! Thank you!

[davescorneroftheworld]

WOW, you did that in 11:18. It took my about 5 hours... ALL MY FAULT... While I was trying to create the TABLE "users" I typed in "user"... After I finely figured out what I did wrong, got the table created, then I FORGOT the user_uid column. Had to delete and start over, I could not figure out how to "add" a column. BUT I got it done!!
😜Go ahead and laugh... Sometimes I can not see the most simple things...😃
I STILL thing you are the very best instructor. THANK YOU MANY TIMES OVER!!!

[VaasMontennegro]

Came here because in university, my PHP teacher is awful. If this makes you feel proud, you are a WAY better teacher using only videos, than a University Professor with 40 years of experience struggling to explain PHP for 5 hours straight. I'll check everything in your channel and subscribe!

[huangJJ]

Man, thank you so much! I can't fathom how hard it was for me to figure this out by myself until I decided to look this up. Really detailed, understanding and genuine to follow along, this had helped me for my college assignment.

Kudos!

[alishalbayev]

thanks man, I had two hours to my deadline, and I finished my assignment thanks to you. Thank you!!

[gokhantaskan]

I've learned PHP in this series! Just for helping a friend to finish his work <3

[lilijaj]

Thank you so much for your great videos :) They are simple, clear and it is amazing how much effort you give in order to help others to understand and learn the basics. Thank you!

[brightl]

This is literally the solution to all of my problems.

[daniellambert]

Dani, thank you so much for this online course. I can't express enough gratitude for the quality of your teaching.

[ishmaelbanda]

Am i the only guy who subscribed to his channel upon watching his first vid?...This guy is brilliant...He produces nice work, easy to follow and apprehend

[David-Rymer]

this is way easier. the php script i had copied from some regestration form worked but i didnt understand it for a long time, until i found this vid. nice one dude : )

[pumphreybob]

You are the first person that I have found that is clear and simple.

[omarmcC]

Excellent! Now I make my queries with no problems at all through PhP. Thanks a lot

[geekie]

Great video. Got me binge watching now. So far everything presented works for me without error. Wish files were available here, but code is not too long I can't just pause and type myself. Thanks again

[sutanubhattacharya]

This is the best PHP tutorial. Thank you for such a superb series of lectures!!!

[royceronningen]

Thanks for these videos! I have already learned this before, but it's nice to get another perspective - since you explain things very well! Great job bro!

[mathewkings]

Thank you so much bro your video just helped me solve a problem i have been battling for the past 8 hours, I really appreciate it.

[okeypraisejunior]

Wow!!!

I love your PHP tutorials sir.
You're a totally amazing person, Thank You!!

[dkvehiclewraps]

IMPORTANT!! Let me tell you guys Im coming from HTML and CSS where i learned everything and all was clear in php until this lesson, but because i'm a supporter in Patreon i can download the files that MMTUTS upload there, IM SAYING this because those files are very clear "commented inside of the code" where you can understand something that is not clear at all here. thanks for all this Job, keep doing this, because you are changing peoples life's, even if you don't see it.