Web development lesson 48 php mysql select query example part 2

#pashto #select_statement
MySQL SELECT Query in PHP
You'll discover how to use PHP to pick records from a MySQL table in this lesson.


Making Data Selections From Database Tables

You have so far learned how to construct a database, a table, and insert data. It is now time to recover the data that was entered during the last instruction. The records from database tables are chosen using the SQL SELECT statement. The fundamental syntax is as follows:



SELECT column1_name, column2_name, columnN_name FROM table_name;

Making use of the SELECT statement, let's create a SQL query that will be executed by passing it to the PHP mysqli query() function in order to extract the table data.