32: Select Data From MySQL Database | PHP Tutorial | Learn PHP Programming | PHP for Beginners

Select Data From MySQL Database | PHP Tutorial | Learn PHP Programming | PHP for Beginners. Today we will learn how to select data from a database table. This is used when we want to fetch data and display it on a website.

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

[jackfrost]

i was taking this udemy course but the instructor was not all that good in explaining but you are the real MVP. so damm well explained. keep it up

[NathalieLega]

This is the best tutorial for PHP I ever saw

[prashanthkumar]

this is really awesome
this playlist is awesome

[lawrencemichael]

Not all heroes wear capes.
thanks man.

[filmsurf]

Hi,
i just found your channel and I really love your PHP tutorials!
Keep up the good work.
Best regards,
Dominik

[adir]

the best tutorials ever! It helps me everytime! keep going do what you do the best!

[rw]

can you have code sat in myphpadmin waiting to convert an empty ( 'days') column with info from another column?

i.e : the 'days' column is empty until the value (date) from date instructed passes through from a user form .
SELECT DATEDIFF(CURDATE(), `date_instructed`) AS DAYS FROM date_tester

this would then display the number of days from the date "now" and date instructed in the empty (days) column

[djleisheng]

I two questions. When we made the table we said 'id int(11)'. If id is int type (not string), then why do we need to write where id='1' instead of where id=1. Also in phpmyadmin when you click the SQL tab it autofills with SELECT * from posts WHERE 1. Is it because id is the primary key that you don't need to specify id='1'?

EDIT. I just noticed that it also works if I write id=1 instead of id='1' so maybe you can explain if there is any difference? Thanks.

[brianjett]

Which video do I have to watch about creating tables and row in the comment part of your videos?

[mustafaqadoori]

Hi i have on problem, how can i select a picture form DB, every item in DB have a special Foto

[thewanderer]

i swear once i start doing some income im gonna donate to you. god bless you

[eeskipster]

Would you be so kind to make video on dynamically populated menu from MYSQL Database. I have a database but I just can’t seem to get it working.

[CaerelsJan]

You put single quotes around the id number "1". Is that necessary? As id is an integer number, couldn't you just write:
WHERE id=1 instead of WHERE id='1'?

[policeuac]

How we can create table into the database we created without phpmyadmin program?
So how can I connect to my database while I create a table without using phpmyadmin feature?
Thank you very much for that awesome tutorial btw :)

[cjvaans]

Didn't seem you explained The 'AND' and 'OR' or your just too fast in explaining things. Or maybe I'm too slow. lol. Anyway thanks for the tutorials.