Home  >  Article  >  Backend Development  >  Summary of sorting function implemented in PHP

Summary of sorting function implemented in PHP

WBOY
WBOYforward
2022-06-20 12:06:071524browse

This article brings you relevant knowledge about PHP, which mainly introduces related issues about the sorting function, and completes the implementation of the php mysqli sorting function through examples. Let’s take a look at it together. I hope everyone has to help.

Summary of sorting function implemented in PHP

Recommended study: "PHP Video Tutorial"

Work with everyone to complete the implementation of the php mysqli sorting function.

1. sql:

-- phpMyAdmin SQL Dump
-- version 4.5.1
-- http://www.phpmyadmin.net
--
-- Host: 127.0.0.1
-- Generation Time: 2022-03-17 17:19:09
-- 服务器版本: 10.1.13-MariaDB
-- PHP Version: 5.6.21

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `a`
--

-- --------------------------------------------------------

--
-- 表的结构 `search`
--

CREATE TABLE `search` (
  `id` int(11) NOT NULL DEFAULT '0',
  `content` text COLLATE utf8_vietnamese_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_vietnamese_ci;

--
-- 转存表中的数据 `search`
--

INSERT INTO `search` (`id`, `content`) VALUES
(666, 'cyg'),
(2, 'liwen'),
(555, 'liwen&cyg');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;

2. Usage steps

Core question:
1. How to connect to the database?

$link=mysqli_connect('localhost','root','','a');

Analysis: Link to the database, localhost on the local address of your computer. Database software username: root. Password "", database name: a
2. How to set the character encoding of the linked database?

mysqli_set_charset($link,'utf8');

Set this utf8 encoding so that there will be no garbled Chinese characters.
3. How to run sql in php?

mysqli_query($link,$sql);

Analysis: The first parameter is the variable assigned by the database link. The second parameter is the sql statement variable

4. How to write variables in the insert statement?

$sql = "INSERT INTO search(id,content)
VALUES ('{$id}','{$content}')";

Analysis: Just follow this format

5. How to write the sorting sql statement in ascending order? From smallest to largest is ascending order. Getting bigger and bigger

$sql = "SELECT id,content FROM search ORDER BY id";

6. How to write sql in descending order from large to small? Getting smaller and smaller

$sql = "SELECT id,content FROM search ORDER BY id desc";

7. The data traversed by mysqli_query must be converted into an array before it can be run.

$row=mysqli_fetch_array($result)

Analysis: Because foreach does not support the direct output of mysqli_query data

1. cyg.php

The code is as follows (example):

<?php
$link=mysqli_connect(&#39;localhost&#39;,&#39;root&#39;,&#39;&#39;,&#39;a&#39;);
//然后是指定php链接数据库的字符集
mysqli_set_charset($link,&#39;utf8&#39;);
$sql="select * from search";
$result=mysqli_query($link,$sql);//运行sql

?>
<!--显示的效果-->
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>
<table border="1" cellpadding="5">
<tr>
<td>id</td>
<td>标题</td>
<td>内容</td>

<?php 
while ($row=mysqli_fetch_array($result)) {//把对象变成数组输出,不然会报错哦

?>
<tr>
<td><?=$row[&#39;id&#39;];?></td>
<td><?=$row[&#39;content&#39;];?></td>


</tr>
<?php 
}
?>
<td><a href="create.php">创建才能排序哦</a></td>
<td><a href="asc.php">升序</a></td><!--从小到大-->
<td><a href="desc.php">降序</a></td><!--从大到小-->
</tr>
</table>
</body>
</html>

2.create.php

<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>
<form action="create.php" method="POST">
<input type="text" name="id">
<input type="text" name="content">

<input type="submit" value="提交">
</form>
</body>
</html>
<?php
if(!$_POST[&#39;content&#39;]||!$_POST[&#39;id&#39;])
{
exit();
}
$content=$_POST[&#39;content&#39;];
$id=$_POST[&#39;id&#39;];

$link=mysqli_connect(&#39;localhost&#39;,&#39;root&#39;,&#39;&#39;,&#39;a&#39;);
//然后是指定php链接数据库的字符集
mysqli_set_charset($link,&#39;utf8&#39;);
$sql = "INSERT INTO search(id,content)
VALUES (&#39;{$id}&#39;,&#39;{$content}&#39;)";
 
$result=mysqli_query($link,$sql);
echo "<script>alert('创建成功');</script>";
?>
<button><a href="cyg.php">返回</a></button>

2.asc.php

<?php
$link=mysqli_connect(&#39;localhost&#39;,&#39;root&#39;,&#39;&#39;,&#39;a&#39;);
//然后是指定php链接数据库的字符集
mysqli_set_charset($link,&#39;utf8&#39;);
$sql = "SELECT id,content FROM search ORDER BY id";
 
$result=mysqli_query($link,$sql);

?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>
<table border="1" cellpadding="5">
<tr>
<td>id</td>
<td>标题</td>
<td>内容</td>

<?php 
while ($row=mysqli_fetch_array($result)) {//把对象编程数组输出,不然会报错哦

?>
<tr>
<td><?=$row[&#39;id&#39;];?></td>
<td><?=$row[&#39;content&#39;];?></td>


</tr>
<?php 
}
?>
<td><a href="create.php">创建才能排序哦</a></td>
<td><a href="asc.php">升序</a></td><!--从小到大-->
<td><a href="desc.php">降序</a></td><!--从大到小-->
</tr>
</table>
</body>
</html>

2.desc. php

<?php
$link=mysqli_connect(&#39;localhost&#39;,&#39;root&#39;,&#39;&#39;,&#39;a&#39;);
//然后是指定php链接数据库的字符集
mysqli_set_charset($link,&#39;utf8&#39;);
$sql = "SELECT id,content FROM search ORDER BY id desc";
 
$result=mysqli_query($link,$sql);

?>
<!DOCTYPE html>
<html>
<head>
<meta charset="UTF-8">
<title>Document</title>
</head>
<body>
<table border="1" cellpadding="5">
<tr>
<td>id</td>
<td>标题</td>
<td>内容</td>

<?php 
while ($row=mysqli_fetch_array($result)) {//把对象编程数组输出,不然会报错哦

?>
<tr>
<td><?=$row[&#39;id&#39;];?></td>
<td><?=$row[&#39;content&#39;];?></td>


</tr>
<?php 
}
?>
<td><a href="create.php">创建才能排序哦</a></td>
<td><a href="asc.php">升序</a></td><!--从小到大-->
<td><a href="desc.php">降序</a></td><!--从大到小-->
</tr>
</table>
</body>
</html>

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of Summary of sorting function implemented in PHP. For more information, please follow other related articles on the PHP Chinese website!

Statement:
This article is reproduced at:csdn.net. If there is any infringement, please contact admin@php.cn delete