How to sort rows of HTML table that are called from MySQL

by

The easiest way to do this would be to put a link on your column headers, pointing to the same page. In the query string, put a variable so that you know what they clicked on, and then use ORDER BY in your SQL query to perform the ordering.

The HTML would look like this:

<th><a href="https://stackoverflow.com/questions/3489783/mypage.php?sort=type">Type:</a></th>
<th><a href="mypage.php?sort=desc">Description:</a></th>
<th><a href="mypage.php?sort=recorded">Recorded Date:</a></th>
<th><a href="mypage.php?sort=added">Added Date:</a></th>

And in the php code, do something like this:

<?php

$sql = "SELECT * FROM MyTable";

if ($_GET['sort'] == 'type')
{
    $sql .= " ORDER BY type";
}
elseif ($_GET['sort'] == 'desc')
{
    $sql .= " ORDER BY Description";
}
elseif ($_GET['sort'] == 'recorded')
{
    $sql .= " ORDER BY DateRecorded";
}
elseif($_GET['sort'] == 'added')
{
    $sql .= " ORDER BY DateAdded";
}

$>

Notice that you shouldn’t take the $_GET value directly and append it to your query. As some user could got to MyPage.php?sort=; DELETE FROM MyTable;

More Related Contents:

  1. Trying to Show 87 mysql rows in 3 html tables using PHP and mysql [closed]
  2. Show values from a MySQL database table inside a HTML table on a webpage [duplicate]
  3. Creating dynamic tables in HTML using MySQL and PHP
  4. Create table with PHP and populate from MySQL
  5. How to create PHP two column table with values from the database?
  6. recurring system my sql query [closed]
  7. MySQL query won't update database [closed]
  8. Gather column name of a table from database [closed]
  9. PHP sending form data to the database
  10. Insert form in MySQL with PDO [duplicate]
  11. Is the following code valid? [closed]
  12. How do I get the last inserted ID of a MySQL table in PHP?
  13. SET NAMES utf8 in MySQL?
  14. MySQL Prepared statements with a variable size variable list
  15. Using Jquery Ajax to retrieve data from Mysql
  16. PHP & MySQL: mysqli_num_rows() expects parameter 1 to be mysqli_result, boolean given [duplicate]
  17. How can I enable the MySQLi extension in PHP 7?
  18. PHP, MySQL error: Column count doesn’t match value count at row 1
  19. MySQL server has gone away – in exactly 60 seconds
  20. displaying an image stored in a mysql blob
  21. Why is password_verify returning false?
  22. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  23. Laravel OrderBy relationship count
  24. MySQL Prepared Statements
  25. MySQL PHP incompatibility
  26. How to store an array into mysql?
  27. Doctrine – How to print out the real sql, not just the prepared statement?
  28. How can I debug why simplest MySQL query returns false?
  29. PHP to MySQL SSL Connections
  30. how to execute mysql command DELIMITER

Leave a Comment