Akwụkwọ ndekọ ederede
Nhazi MySQL ọtụtụ ubi? MySQL OZI SITE NA-agbadata/na-arịgo njụajụjụ iwu/ọrụ
Ụdị MySQL
Anyị maara iji nkwupụta SQL SELECT ịgụ data sitere na tebụl MySQL.
Ọ bụrụ na anyị chọrọ ịhazi data agụpụtara, anyị nwere ike iji usoro ORDER BY nke MySQL kọwaa mpaghara na usoro nhazi anyị chọrọ iji, wee weghachite nsonaazụ ọchụchọ ahụ.
ụtọ asụsụ
Nke a bụ nkwupụta SQL SELECT nke na-eji ORDER BY nkebiokwu iji dozie data ajụjụ tupu iweghachite data:
SELECT field1, field2,...fieldN table_name1, table_name2... ORDER BY field1, [field2...] [ASC [DESC]]
- Ị nwere ike iji mpaghara ọ bụla dị ka ụdị ọnọdụ iji weghachi rịzọlt a haziri ahazi.
- Ị nwere ike ịtọ ọtụtụ ubi ka ịhazi.
- Ị nwere ike iji mkpụrụokwu ASC ma ọ bụ DESC iji tọọ nsonaazụ ajụjụ a ga-ahazi n'usoro nrịgo ma ọ bụ na-agbada.Site na ndabara, ọ nọ n'usoro nrịgo.
- Ị nwere ike ịgbakwunye Ebe...Dị ka nkebiokwu iji tọọ ọnọdụ.
Iji ORDER BY nkebiokwu dị na ngwa ngwa iwu
Ihe ndị a ga-eji nkebiokwu ORDER BY dị na nkwupụta SQL SELECT ịgụ data dị na MySQL data table chenweiliang_tbl:
ihe atụ
Gbalịa ihe atụ ndị dị n'okpuru, a ga-ahazikwa nsonaazụ ya n'usoro nrịgo na mgbada.
Ụdị SQL
mysql> use chenweiliang; Database changed mysql> SELECT * from chenweiliang_tbl ORDER BY submission_date ASC; +-----------+---------------+---------------+-----------------+ | chenweiliang_id | chenweiliang_title | chenweiliang_author | submission_date | +-----------+---------------+---------------+-----------------+ | 3 | 学习 Java | chenweiliang.com | 2015-05-01 | | 4 | 学习 Python | chenweiliang.com | 2016-03-06 | | 1 | 学习 PHP | 陈沩亮博客 | 2017-04-12 | | 2 | 学习 MySQL | 陈沩亮博客 | 2017-04-12 | +-----------+---------------+---------------+-----------------+ 4 rows in set (0.01 sec) mysql> SELECT * from chenweiliang_tbl ORDER BY submission_date DESC; +-----------+---------------+---------------+-----------------+ | chenweiliang_id | chenweiliang_title | chenweiliang_author | submission_date | +-----------+---------------+---------------+-----------------+ | 1 | 学习 PHP | 陈沩亮博客 | 2017-04-12 | | 2 | 学习 MySQL | 陈沩亮博客 | 2017-04-12 | | 4 | 学习 Python | chenweiliang.com | 2016-03-06 | | 3 | 学习 Java | chenweiliang.com | 2015-05-01 | +-----------+---------------+---------------+-----------------+ 4 rows in set (0.01 sec)
Gụọ data niile dị na tebụl chenweiliang_tbl wee hazie n'usoro na-arịgo site na ubi submission_date.
Iji nkeji okwu ORDER BY na edemede PHP
Ị nwere ike iji PHP ọrụ mysqli_query() na otu iwu SQL SELECT nwere ORDER BY nkeji iji nweta data ahụ.
A na-eji ọrụ a iji mezuo iwu SQL wee wepụta data niile achọrọ site na ọrụ PHP mysqli_fetch_array().
ihe atụ
Nwaa ọmụmaatụ na-esote, a na-eweghachite data a jụrụ n'usoro n'usoro nrịdata nke ubi submission_date.
MySQL ORDER site n'ule:
<?
php
$dbhost = 'localhost:3306'; // mysql服务器主机地址
$dbuser = 'root'; // mysql用户名
$dbpass = '123456'; // mysql用户名密码
$conn = mysqli_connect($dbhost, $dbuser, $dbpass);
if(! $conn )
{
die('连接失败: ' . mysqli_error($conn));
}
// 设置编码，防止中文乱码
mysqli_query($conn , "set names utf8");
$sql = 'SELECT chenweiliang_id, chenweiliang_title,
chenweiliang_author, submission_date
FROM chenweiliang_tbl
ORDER BY submission_date ASC';
mysqli_select_db( $conn, 'chenweiliang' );
$retval = mysqli_query( $conn, $sql );
if(! $retval )
{
die('无法读取数据: ' . mysqli_error($conn));
}
echo '<h2>陈沩亮博客 MySQL ORDER BY 测试<h2>';
echo '<table border="1"><tr><td>教程 ID</td><td>标题</td><td>作者</td><td>提交日期</td></tr>';
while($row = mysqli_fetch_array($retval, MYSQL_ASSOC))
{
echo "<tr><td> {$row['chenweiliang_id']}</td> ".
"<td>{$row['chenweiliang_title']} </td> ".
"<td>{$row['chenweiliang_author']} </td> ".
"<td>{$row['submission_date']} </td> ".
"</tr>";
}
echo '</table>';
mysqli_close($conn);
?>Enwere m olileanya na isiokwu a bụ "MySQL Multi-Field Condition Sorting? MySQL ORDER BY Descending/Ascending Order Query Statement Statement/Function" nke e kesara na blọgụ Chen Weiliang ( https://www.chenweiliang.com/ ) ga-abara gị uru.
Nwere onwe gị ịkọrọ njikọ akụkọ a: https://www.chenweiliang.com/cwl-476.html