Web development lesson 48 php mysql select query into normal array and ordering the results part 3

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


Finding Data in Database Tables

You've learned how to construct databases, tables, and insert data so far. Retrieving the data that was inserted during the last instruction is now necessary. The records are chosen from database tables using the SQL SELECT query. Following is its fundamental syntax:

SELECT column1_name, column2_name, columnN_name FROM table_name;

Let's create a SQL query using the SELECT statement, then we'll run it by providing it to the PHP mysqli query() function in order to access the table's data.