PHP Tutorial

A web server programming language.

Chapter Quiz Exercises
Course Topics
PHP Intro PHP Syntax PHP Variables PHP Echo / Print PHP Data Types PHP Strings PHP Numbers PHP Math PHP Constants PHP Operators PHP If...Else...Elseif PHP Switch PHP Loops PHP Functions PHP Arrays PHP Superglobals PHP Form Handling PHP Date and Time PHP File Handling PHP Cookies PHP Sessions PHP Exceptions PHP OOP Classes & Objects PHP Constructor MySQL Connect MySQL Insert Data MySQL Select Data PHP JSON PHP Regular Expressions PHP Include & Require

MySQL Select Data

MySQL Select Data With PHP

The SELECT statement is used to select data from one or more tables.

Selecting Data

We use the query() method to execute the SQL query, and fetch the results using a while loop with fetch_assoc().

Try It Yourself

Edit the code below and click Run to see the result live.

Source Code
Result
Topics
PHP Intro PHP Syntax PHP Variables PHP Echo / Print PHP Data Types PHP Strings PHP Numbers PHP Math PHP Constants PHP Operators PHP If...Else...Elseif PHP Switch PHP Loops PHP Functions PHP Arrays PHP Superglobals PHP Form Handling PHP Date and Time PHP File Handling PHP Cookies PHP Sessions PHP Exceptions PHP OOP Classes & Objects PHP Constructor MySQL Connect MySQL Insert Data MySQL Select Data PHP JSON PHP Regular Expressions PHP Include & Require