How does php sort the data queried by mysql?

Let’s learn how to sort mysql data and specify a sorting rule. For example, if we want to sort by name, or by age, these are all possible This is achieved through the order by keyword in mysql. Next, let’s take a look at how to implement it. (Recommended learning: PHP video tutorial)

1. Connect to the database.

The old rule is that the first step is to connect to the database first. I chose local testing here, so our host name here is localhost, and then connect to the database.

# 2. Write the sql statement.

When we sort myslq data, we bring the rules when querying, and implement through the keyword order by. The format is as follows: select field Name (*) from table name order by field name DESC (descending order).

select * from test1 order by id DESC.

In this example, the descending or ascending keyword is added at the end, DESC means descending order, and ASC means ascending order.

3. Execute the sql statement and output the results.

The next step is to execute the sorted query statement just written, convert the result into an array through fetch_assoc, and output the contents of the array.

4. Test.

Tested in a local browser, the results are as follows:

The above is the detailed content of How does php sort the data queried by mysql?. For more information, please follow other related articles on the PHP Chinese website!