php - 使用链接更改内容 ORDERING BY DESC、ASC 等同一页面的

Question

这是我的查看页面:

<?php

include 'connect/con.php';

$result = mysqli_query($con,"SELECT newsvid.id, newsvid.vidTitle, newsvid.url, newsvid.vidSD, newsvid.published, videoinformation.vidLD, videoinformation.vidYear, videoinformation.vidCity, videoinformation.vidZanr, videoinformation.vidQuality, videoinformation.vidTranslated, videoinformation.vidTime  FROM newsvid, videoinformation WHERE newsvid.id = videoinformation.id ORDER BY newsvid.id DESC");

while($row = mysqli_fetch_array($result)) {
  echo '<div class="id">#<a href="details.php?id='.$row['id'].'">'.$row['id'].'</a></div>';
  echo "<div class=\"vidTitle\">" . $row['vidTitle'] . "</div>";
  echo "<div class=\"imgCover\"><img class=\"imageCover\"src=\"" . $row['url'] . "\"></div>";
  echo "<div class=\"vidSD\">" . $row['vidSD'] . "</div>";
  echo "<div class=\"vidDetails\"> 
<table class=\"tableSD\" >
<tr><td class=\"tdBR\"><strong> Years: </strong></td><td class=\"tdB\">" . $row['vidYear'] . "</td></tr>
<tr><td class=\"tdBR\"><strong> City: </strong></td><td class=\"tdB\">". $row['vidCity'] . "</td></tr>
<tr><td class=\"tdBR\"><strong> Zanr: </strong></td><td class=\"tdB\">". $row['vidZanr'] . "</td></tr>
<tr><td class=\"tdBR\"><strong> Quality: </strong></td><td class=\"tdB\">". $row['vidQuality'] . "</td></tr>
<tr><td class=\"tdBR\"><strong> Translated: </strong></td><td class=\"tdB\">". $row['vidTranslated'] . "</td></tr>
<tr><td class=\"tdBR\"><strong> Video time: </strong></td><td class=\"tdB\">". $row['vidTime'] .  "</td></tr>
</table> 
 </div>";


  echo "<div class=\"published\"><strong>Published: </strong>" . $row['published'] . "</div>"; 
}
mysqli_close($con);
?>

我需要在index.php页面中有一个LINK，“ORDER BY newsvid.id DESC”将根据点击的链接进行更改。

EG:

<div class="mainLeftCover">
<a href="#>ASC</a> |
<a href="#>DESC</a> |
</div>

如果我按 ASC，view.php 页面将显示结果 ORDERED BY newsvid.id ASC，如果我按 DESC，同一 view.php 页面将显示结果 ORDERED BY newsvid。 id DESC等等...

Answer 1

首先您需要向链接网址添加一个参数

<div class="mainLeftCover">
<a href="view.php?order=ASC">ASC</a> 
<a href="view.php?order=DESC">DESC</a> 
</div>

然后用查询的 stub 减去 ORDER 部分设置一个变量。

$query ="SELECT newsvid.id, newsvid.vidTitle, newsvid.url, newsvid.vidSD, newsvid.published, videoinformation.vidLD, videoinformation.vidYear, videoinformation.vidCity, videoinformation.vidZanr, videoinformation.vidQuality, videoinformation.vidTranslated, videoinformation.vidTime  FROM newsvid, videoinformation WHERE newsvid.id = videoinformation.id";

使用isset()与 ternary operator要么获取参数，要么如果未设置则传递默认值。

$order = isset($_GET['order']) ? $_GET['order'] : 'DESC';//Change to ASC if you want this as default

使用 in_array() sanitizer

$goodParam = array("ASC", "DESC");
if (in_array($order, $goodParam)) {

然后使用.= Concatenation assignment构建$query。

        if($order == 'DESC'){
            $query .= " ORDER BY newsvid.id DESC";
        }else{
            $query .= " ORDER BY newsvid.id ASC";
      }
}
    $result = mysqli_query($con,$query);