PHP Tutorial - How To Get Data From MySQL Database

Learn How To Get Data From MySQL Database Using PHP

It is PHP & MySQL Tutorial For Beginners.

In this tutorial I will talk about :
- about HTML document design with bootstrap
- how to use PHP while loop
- how to get data from MySQL Database Using PHP

Also, I will teach you how to use MySQL SELECT command inside PHPMyAdmin.

[rohansaand]

Love the way you explained it at the white board first and then wrote the code. Made things very easy to understand. :)

[girishv]

Very nice lectures.. Please do video on select tag validation. Like if we select a particular country ..all the states of a particular country should be there in a another selection tag.

[adamone]

Hi Senaid,
Thank you so much for providing us with your detailed info about MySQL and PHP.
I've managed to create some small projects thanks to your excellent tutorials.
However, I got stuck with one detail: I would like to be able to search values within a certain range, e.g. Select * From mydatabase Where age Between 25 and 35 (or salaries between 5000 and 8000 and so on). So, the results shown should be within the range chosen by the user's input.
I guess I need to create two input fields (placeholders) to enter the two variables, but don't know how to define them so they can be called by the query function.
Edited (Jan 7, 18):
I just wanted to let you know that I've found the solution. :-)
Thanks again for your useful tutorials!

[AtomTCP]

Nice but, instead while use foreach beacuse when u get data from mysql u get it at array format and for array fetching is always better use foreach then while.