php实现排序功能(提供全部)
-- 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.21SET 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 */;
cyg.php
<?php$link=mysqli_connect('localhost','root','','a');//然后是指定php链接数据库的字符集mysqli_set_charset($link,'utf8');$sql="select * from search";$result=mysqli_query($link,$sql);//运行sql?><!--显示的效果--><!DOCTYPE html><html lang="en"><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['id'];?></td><td><?=$row['content'];?></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>
asc:
<?php$link=mysqli_connect('localhost','root','','a');//然后是指定php链接数据库的字符集mysqli_set_charset($link,'utf8');$sql = "SELECT id,content FROM search ORDER BY id"; $result=mysqli_query($link,$sql);?><!DOCTYPE html><html lang="en"><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['id'];?></td><td><?=$row['content'];?></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>
desc.php
<?php$link=mysqli_connect('localhost','root','','a');//然后是指定php链接数据库的字符集mysqli_set_charset($link,'utf8');$sql = "SELECT id,content FROM search ORDER BY id desc"; $result=mysqli_query($link,$sql);?><!DOCTYPE html><html lang="en"><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['id'];?></td><td><?=$row['content'];?></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>