Home Backend Development PHP Problem How does php sort the data queried by mysql?

How does php sort the data queried by mysql?

Sep 30, 2019 pm 02:08 PM
php

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)

How does php sort the data queried by mysql?

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.

How does php sort the data queried by mysql?

# 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.

How does php sort the data queried by mysql?

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:

How does php sort the data queried by mysql?

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!

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot Article

Hot Article

Hot Article Tags

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

CakePHP Date and Time CakePHP Date and Time Sep 10, 2024 pm 05:27 PM

CakePHP Date and Time

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian Dec 24, 2024 pm 04:42 PM

PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian

CakePHP File upload CakePHP File upload Sep 10, 2024 pm 05:27 PM

CakePHP File upload

CakePHP Routing CakePHP Routing Sep 10, 2024 pm 05:25 PM

CakePHP Routing

Discuss CakePHP Discuss CakePHP Sep 10, 2024 pm 05:28 PM

Discuss CakePHP

CakePHP Project Configuration CakePHP Project Configuration Sep 10, 2024 pm 05:25 PM

CakePHP Project Configuration

CakePHP Quick Guide CakePHP Quick Guide Sep 10, 2024 pm 05:27 PM

CakePHP Quick Guide

CakePHP Creating Validators CakePHP Creating Validators Sep 10, 2024 pm 05:26 PM

CakePHP Creating Validators

See all articles