PHP MYSQL - 升序/降序排序按钮

Question

我相当困惑如何创建一个按钮，将打印到 php 文件的表中的数据按升序或降序排序。

<form name="Table Properties" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
 Order by Week
 <button type="submit" name="sort week" class="button" value="1"> Sort Week </button>
 </form>
<?php if('sort week' == true ){
    "SELECT * FROM `classes` ORDER BY `classes`.`week` ASC";
}
?>

这是我想要实现的一个简单示例，我只是停留在 php 代码方面。任何帮助将不胜感激。

Answer 1

我首先删除空格，然后使用 $_POST 捕获它..

<form name="Table Properties" method="post" action="<?php echo $_SERVER['PHP_SELF']; ?>">
 Order by Week
 <button type="submit" name="sort_week" class="button" value="1"> Sort Week </button>
 </form>
<?php if($_POST['sort_week'] === true) {
"SELECT * FROM `classes` ORDER BY `classes`.`week` ASC";
}?>