对包含SQL数据的HTML表格列进行排序

问题描述：

我创建了一个简单的事务报告页面，它将输入的数据库数据接收并显示在HTML表格中。我希望能够在点击表头时以asc/desc顺序对客户端的每列进行排序，但是我无法让我的函数正常工作。对包含SQL数据的HTML表格列进行排序

<?php session_start(); 

include 'db.php'; 
include 'head.php'; 

$sql = "SELECT * FROM ach"; 


$result = $mysqli->query($sql); 


echo "<div class='w3-row-padding w3-margin'>"; 
if ($result->num_rows) { 
    echo "<table class='w3-table-all'> 
    <thead> 
     <tr> 
      <th><a href='transactions.php?sort=submittedDate'>Submitted Date</a></th> 
      <th><a href='transactions.php?sort=accountNumber'>Chief Account Number</a></th> 
      <th><a href='transactions.php?sort=accountHolderName'>Account Holder</a></th> 
      <th><a href='transactions.php?sort=achAccountType'>Account Type</a></th> 
      <th><a href='transactions.php?sort=transferType'>Transfer Type</a></th> 
      <th><a href='transactions.php?sort=recurringMonthlyTransferDate'>Transfer Date</a></th> 
      <th><a href='transactions.php?sort=status'>Status</a></th> 
      <th>&nbsp;</th> 
     </tr> 
    </thead>"; 

    // output data of each row 
    while($row = $result->fetch_assoc()) { 
     echo "<tbody><tr><td>".$row["submitDate"]."</td><td>".$row["accountNumber"]."</td><td>".$row["accountHolderName"]."</td><td>".$row["achAccountType"]."</td><td>".$row["transferType"]."</td><td>".$row["recurringMonthlyTransferDate"]."</td><td>".$row["status"]."</td><td><a href=review.php?ID=" . $row["id"] . ">Review</a></td></tr></tbody>"; 
    } 

    echo "</table>"; 
} else { 
    echo "0 results"; 
} 
echo "</div>"; 

if ($_GET['sort'] == 'submittedDate') 
{ 
    $sql .= " ORDER BY `ach`.`submitDate` ASC "; 
} 
elseif ($_GET['sort'] == 'accountNumber') 
{ 
    $sql .= " ORDER BY accountNumber"; 
} 
elseif ($_GET['sort'] == 'accountHolderName ') 
{ 
    $sql .= " ORDER BY accountHolderName ASC"; 
} 
elseif($_GET['sort'] == 'achAccountType') 
{ 
    $sql .= " ORDER BY achAccountType"; 
} 
elseif($_GET['sort'] == 'transferType') 
{ 
    $sql .= " ORDER BY transferType"; 
} 
elseif($_GET['sort'] == 'recurringMonthlyTransferDate') 
{ 
    $sql .= " ORDER BY recurringMonthlyTransferDate"; 
} 
elseif($_GET['sort'] == 'status') 
{ 
    $sql .= " ORDER BY status"; 
} 

$mysqli->close(); 

include 'foot.php'; 
?>

我明白，你需要做到这一点你自己。但请看看[引导的DataTable（https://datatables.net/manual/styling/bootstrap），它可以帮助你..引导数据表具有内置的功能来排序，搜索，过滤等...但只在客户端... – Lal

如果您想在客户端进行排序，您可以使用数据表。 –

我尝试使用数据表，但它不工作。 – xxdash

答

您必须在执行查询之前添加排序语句。查询该线路执行：

$result = $mysqli->query($sql);

答

如果你想在服务器端你必须by子句Ø刻申使用类型的数据。如果你想jQuery来在客户端进行排序可以使用Data tables

也把<tbody> </tbody>的，而在外面。由于有许多行，因此您的表格有许多tbody标签。

$sort = ""; if(isset($_GET["sort"])) { $sort = $_GET["sort"]; //validate that it is real column name so that you will not get any error if(!in_array($sort, array("submittedDate", "accountNumber", "accountHolderName", "achAccountType", "transferType", "recurringMonthlyTransferDate", "status"))) { $sort = ""; } if($sort !="") { $sort = " order by ".$sort." ASC"; } } $sql = "SELECT * FROM ach".$sort;

对包含SQL数据的HTML表格列进行排序

相关推荐